Excel average Function Tips

Averaging The 5 Lowest Values In Your Data!

Let’s assume you are a math’s teacher interested in finding the average of the math’s score of last five students – he is interested in finding why they are performing poor. How will he proceed? 

Developing And X And R Chart For Quality Control

We do create different type of charts to fulfill our charting needs – quite a few of them are related to quality control purposes.

Using Moving Averages For Forecasting

Sales people often need to estimate the sales of upcoming months. They do it with a handful of techniques that uses both quantitative analysis as well as qualitative judgment.

How To Calculate Average Absolute Difference For You Data With Negative Value!

A recent question on a website requested for calculating the average of absolute differences for a year-over-data.

How To Calculate Weighted Average In Excel

The average value of number of cells or a data range in Excel can easily be calculated using AVERAGE() formula.

Operation with condition according to the average

Using AVERAGE() and IF() formulas.

Finding minimum, maximum and average number in a list and counting the number of cells. 

Using the MIN(), MAX(), COUNT() and AVERAGE() functions on a list