CALCULATE THE AVERAGE SPEED USING MICROSOFT EXCEL

In this example, someone travels from New York to Los Angeles with an average speed of 90 miles per hour. On the way back, the average speed is 75 miles per hour. What is the overall average speed?

To calculate the average speed, the speed in each direction has to be taken into consideration.

To calculate the overall average speed:

1. In cell C2, enter 90.
2. In cell C3, enter 75.
3. In cell C4, type the following formula: =(C2+C3)/2.

CALCULATE THE AVERAGE SPEED USING MICROSOFT EXCEL

Microsoft Excel Tutorials, MS Excel Tutorials, Calculate the Average Speed using MS Excel, Microsoft Excel Tutorials, Formulas in Excel, Basic Functions in Excel, Microsoft Excel Video Tutorials