I need a formula to calculate the weighted average of a group of rate per miles for commuter train fares.The data is a set of fares (in$) between a central city and several outlying cities,. together with the respective mileages between the central city and each outlying city. I have calculated the rate per mile (fare divided by miles) for each city pair. But I don't know the formula for the weighted average rate per mile for the entire data set. Your help would be most appreciated.
Solved by E. J. in 26 mins