Moving MPG average

Prius Maximus · 08-01-2004, 12:07 AM

I made a chart in my mpg speadsheet that shows a moving average of my mpg. The chart runs from my 1st tank in March, 2004 to my most recent tank, at 13,000 miles.

I am not a statistician, but the results look pretty impressive....

Frank Hudon · 08-01-2004, 12:25 AM

Wow! your learing to drive the car. As is visable in the spike when you first got it and were trying to get the best mileage and then a "drive it like it's a car" lower mileage then a slow and steady climb to where your "driving it like a Prius" and also it's fully broken in. Nice graph!

V8Cobrakid · 08-01-2004, 02:04 AM

Very nice graph... I wish the prius was able to display this information. :mrgreen:

LeVautRien · 08-01-2004, 02:04 AM

It'd be nice to see these from multiple Prius owners, to further establish this as a trend in the form of several graphs with the same data.

Prius Maximus · 08-01-2004, 03:17 PM

Since the moving average smooths out the curve a lot, I thought I'd post tha chart of the actual MPGs also. Most of the really low mpgs are due to uncontrollable factors. I had a cross state trip with 4 adults and baggage on one. Very strong March winds hurt me on a couple of early tankfulls.

I believe that in addition to learning how to drive, the car is getting "looser" as it breaks in, and there is always the temperature affect. After next February, I will post a full year graph to see how the temperature might affect the mpgs. If anybody else has a years' worth of mpg data, go ahead and graph it for us please.

LeVautRien · 08-01-2004, 03:46 PM

What's the difference between this one and the moving one? I mean, how did you get the smooth curve of the moving one?

08-01-2004, 05:18 PM

ok - if you are interested here is the MPG graph data for my UK classic Prius (more than 2 years of data) - not a moving average though - just your plain old average.

you can see how the winters have affected my MPGs and the summers have helped to boost them again.

cheers

Prius Maximus · 08-01-2004, 06:31 PM

Quote:

Originally posted by LeVautRien
What's the difference between this one and the moving one? I mean, how did you get the smooth curve of the moving one?

The first graph is a "moving average". It takes the first few numbers and averages them for the first point. then the next few are averaged for the next point. This is what smooths out the curve.

A 5 point average takes the average of readings 1 2 3 4 5 for the first point, 2 3 4 5 6 for the second, 3 4 5 6 7 for the third etc.... That is why it's called a "moving" average, the set of numbers used at each time is moving through the entire set. The more numbers used in each set smooths out the curve more.

If you have quattro pro, the option for moving average is in analyze under tools. Or you could look it up in help. I don't know if XL has it but it should.

LeVautRien · 08-01-2004, 11:03 PM

Ah yes, ok, I understand it now. I'll look in Excel, I'm sure it has a similar feature.

08-01-2004, 12:07 AM	#1
Prius Maximus Senior Member Join Date: May 2004 Location: Northeastern IL Posts: 197 My Car: 2004 Prius Package: #9 Nominated 0 Times in 0 Posts TOTM Awards: 0 Friends: 0	Moving MPG average I made a chart in my mpg speadsheet that shows a moving average of my mpg. The chart runs from my 1st tank in March, 2004 to my most recent tank, at 13,000 miles. I am not a statistician, but the results look pretty impressive....

08-01-2004, 03:17 PM	#5
Prius Maximus Senior Member Join Date: May 2004 Location: Northeastern IL Posts: 197 My Car: 2004 Prius Package: #9 Nominated 0 Times in 0 Posts TOTM Awards: 0 Friends: 0	Since the moving average smooths out the curve a lot, I thought I'd post tha chart of the actual MPGs also. Most of the really low mpgs are due to uncontrollable factors. I had a cross state trip with 4 adults and baggage on one. Very strong March winds hurt me on a couple of early tankfulls. I believe that in addition to learning how to drive, the car is getting "looser" as it breaks in, and there is always the temperature affect. After next February, I will post a full year graph to see how the temperature might affect the mpgs. If anybody else has a years' worth of mpg data, go ahead and graph it for us please. __________________ MMIV Driftwood IX - ordered 2/5/04 delivered 03/08/2004 best tank: 60.5 mpg. LT Avg: 52.2 mpg. 141,000 miles as of 11/15/08 2,320 gallons saved, $6,160 gas cost saved compared to Dodge Neon

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PC moving to the right?	Schmika	Fred's House of Pancakes	52	04-13-2007 01:12 PM
Moving on up	jrfaris	Prius Main Forum	1	03-02-2007 03:25 PM
Moving to LA?	Oxo	Prius Main Forum	8	01-22-2007 05:44 PM
Moving to the UK from the US...	Mike Lane	International Owners	4	10-10-2006 12:04 PM
MOVING DAY IS HERE	InTheWASide	WA - Washington State	2	09-10-2004 01:22 AM

08-01-2004, 12:25 AM	#2
Frank Hudon Senior Member Join Date: Jan 2004 Posts: 4,144 My Car: Package: Nominated 0 Times in 0 Posts TOTM Awards: 0 Friends: 0	Wow! your learing to drive the car. As is visable in the spike when you first got it and were trying to get the best mileage and then a "drive it like it's a car" lower mileage then a slow and steady climb to where your "driving it like a Prius" and also it's fully broken in. Nice graph!

08-01-2004, 02:04 AM	#3
V8Cobrakid ...disgusted with life... Join Date: Jun 2004 Location: San Jose, CA Posts: 2,623 My Car: 2004 Prius Package: #9 Nominated 0 Times in 0 Posts TOTM Awards: 0 Friends: 5	Very nice graph... I wish the prius was able to display this information. :mrgreen:

08-01-2004, 02:04 AM	#4
LeVautRien Senior Member Join Date: Jul 2004 Location: Claremont, California Posts: 367 My Car: Package: Nominated 0 Times in 0 Posts TOTM Awards: 0 Friends: 0	It'd be nice to see these from multiple Prius owners, to further establish this as a trend in the form of several graphs with the same data.

08-01-2004, 03:46 PM	#6
LeVautRien Senior Member Join Date: Jul 2004 Location: Claremont, California Posts: 367 My Car: Package: Nominated 0 Times in 0 Posts TOTM Awards: 0 Friends: 0	What's the difference between this one and the moving one? I mean, how did you get the smooth curve of the moving one?

08-01-2004, 05:18 PM	#7
priusfanmh Guest Posts: n/a My Car: Package:	ok - if you are interested here is the MPG graph data for my UK classic Prius (more than 2 years of data) - not a moving average though - just your plain old average. you can see how the winters have affected my MPGs and the summers have helped to boost them again. cheers

08-01-2004, 11:03 PM	#9
LeVautRien Senior Member Join Date: Jul 2004 Location: Claremont, California Posts: 367 My Car: Package: Nominated 0 Times in 0 Posts TOTM Awards: 0 Friends: 0	Ah yes, ok, I understand it now. I'll look in Excel, I'm sure it has a similar feature.