I am trying to figure out what my overall average speed is while on a bike.
I have miles traveled in column 1 and then avg speed in miles per hour in column 2.
The problem is that I have different distances associated with the differing speeds, so I cant juts average my all of the speeds to get an accurate average.
How do I find the overall average speed, weighted, so that I have the actual avg speed?
Distance 9.82, 8.69, 8.43, 9.07, 8.16, 12.41, 7.22, 3.13, 10.28, 9.79, 10.44,
Avg Speed 18.4, 12.8, 16.7, 18.1, 16.2, 19, 13.5, 16, 10.9, 16.8, 15.6,