S 40 60 2 displaystyle s frac 4060 2 s 100 2 displaystyle s frac 100 2 s 50 displaystyle s50 So if Ben traveled 40 mph for 2 hours then 60 mph for another 2 hours his average speed is 50 mph. This will give you the average speed for the entire trip. In the example below the formula in column I computes an average of the top 3 quiz scores in each row.
But in excel we have a simple formula for calculating an average.
But in excel we have a simple formula for calculating an average. For this from the Insert Function option in excel we can search AVERAGE to use it. Suppose we wish to find out the average of all items except pastries we will use the following formula AVERAGEIFA12A15 Pastries B12B15. The calculation for the simple moving average is the same as computing an average or mean.