AVG Function


The AVG function is used to calculate the average value.

It adds all numeric values and divides them by the total count.

AVG is commonly used in analysis and reporting.

AVG works only with numeric columns.

Text values cannot be averaged.

This ensures meaningful results.

AVG is used to calculate values such as average salary, average marks, or average sales.

It helps understand trends and performance.

AVG returns a single numeric value.

It summarizes large datasets into simple results.

This helps decision making.

AVG is widely used in business analytics.

It plays an important role in data analysis.

Understanding AVG improves reporting skills.