How to Calculate the Average Speed Using Excel
In this exercise, we woud like to calculate the average speed at which a vehicle travelled between London and Manchester City. On the way to Manchester City, the average speed was 70 Kph and on the way back to london, the average speed was 55kph. To calculate the overall average speed, we will use the following simple method.
How to calculate overall average speed.
- Select Cell B2 and type 70 as the first average speed.
- Select Cell B3 and type 55 as the second average speed.
- Select Cell B4 and type the following formula to calculate the overall average speed: =(C2+C3)/2
You should now be set!
