Quote:
|
Originally Posted by bwilson4web
It is easy to 'cut and paste' the detailed vehicle records into an excel spreadsheet and convert back to miles and gallons and recalculate the averge MPG. Then eliminate all single entry records and calculate the average MPG for 'trustable' data. It took me 10-15 minutes to do this for the Prius I database:
45 MPG - current Prius I average
45.9 MPG - calculated using > 5 tank entries and usable miles
My experiment suggests those with lower MPG rates are more likly to make data entry errors. BUT it is not a significant source of error.
Bob Wilson
|
Your right, but it is still not correct
By eliminating the low ones you are selecting your pool. I took your advice and i cut and paste the insight into the chart and i will work on it later.
What im proposing is Substituting those who are using their highest ever MPG with their LMPG with people who have them listed seperatly within signature/post etc and you will see the average DROP.