I took the CNN list of cars and corrected and filled in the numbers.
I than calculated a $/avg mpg and sorted it but that.

edit well it great in a list format before I sent it.... I just fixed it but the spacing got killed.

CAR model cost EPA MPG city EPA MPG hiway calc avg $/avgmpg Notes
Smart 4-2 $11,590 33 41 37 $313.24 5 spd stick
Yaris $11,350 29 36 32.5 $349.23 5 spd stick
Corolla CE Coupe $14,505 28 37 32.5 $446.31 5 spd stick
Fit$13,950 28 34 31 $450.00 5 spd stick
Prius$21,100 48 45 46.5 $453.76 auto
Focus S Coupe $14,300 24 35 29.5 $484.75 5 spd stick
Civic DX Coupe$14,810263430$493.675 spd stick
Civic Hybrid Coupe$22,600404542.5$531.76auto
Cooper Clubman $19,950 28 37 32.5 $613.85 6 spd stick
Altima Hybrid Coupe $25,170 35 33 34 $740.29 6 spd stick
Camry Hybrid $25,350 33 34 33.5 $756.72 auto
Civic GX $24,590 24 36 30 $819.67 5 spd stick

Here's the list sorted by inital cost (lowest 1st)
CAR modelcost EPA MPG cityEPA MPG hiwaycalc avg$/avgmpgNotes
Yaris$11,350293632.5$349.235 spd stick
Smart 4-2$11,590334137$313.245 spd stick
Fit$13,950283431$450.005 spd stick
Focus S Coupe$14,300243529.5$484.755 spd stick
Corolla CE Coupe$14,505283732.5$446.315 spd stick
Civic DX Coupe$14,810263430$493.675 spd stick
Cooper Clubman$19,950283732.5$613.856 spd stick
Prius$21,100484546.5$453.76auto
Civic Hybrid Coupe$22,600404542.5$531.76auto
Civic GX$24,590243630$819.675 spd stick
Altima Hybrid Coupe$25,170353334$740.296 spd stick
Camry Hybrid$25,350333433.5$756.72auto

Here's the list sorted by best calculated avg mpg
CAR modelcost EPA MPG cityEPA MPG hiwaycalc avg$/avgmpgNotes
Prius$21,100484546.5$453.76auto
Civic Hybrid Coupe$22,600404542.5$531.76auto
Smart 4-2$11,590334137$313.245 spd stick
Altima Hybrid Coupe$25,170353334$740.296 spd stick
Camry Hybrid$25,350333433.5$756.72auto
Yaris$11,350293632.5$349.235 spd stick
Corolla CE Coupe$14,505283732.5$446.315 spd stick
Cooper Clubman$19,950283732.5$613.856 spd stick
Fit$13,950283431$450.005 spd stick
Civic DX Coupe$14,810263430$493.675 spd stick
Civic GX$24,590243630$819.675 spd stick
Focus S Coupe$14,300243529.5$484.755 spd stick

Have fun

 

Wonder why the Mini Clubman is on there but not the regular, smaller Cooper?

 

Probably didn't have one on hand to compare at the time. When doing product comparisons sometimes you are at the mercy of what the manufacturer sends you. If they don't send you the device to test, then you have no data. Happens all the time in the tech industry when I get calls from people wondering if our device works with this other company's device, sometimes the answer is we don't know.

 

FIXED

CARmodel----------cost ------MPG c/h/avg-----cost/avgmpg
Smart 4-2-------$11,590-----33 41 37 ------$313.24-----5MT
Yaris-----------$11,350 ----29 36 32.5 ----$349.23-----5MT
Corolla CE------$14,505 ----28 37 32.5 ----$446.31-----5MT
Fit-------------$13,950 ----28 34 31 ------$450.00-----5MT
Prius-----------$21,100 ----48 45 46.5 ----$453.76-----AT
Focus S --------$14,300 ----24 35 29.5 ----$484.75-----5MT
Civic DX -------$14,810-----26 34 30-------$493.67-----5MT
Civic Hybrid----$22,600-----40 45 42.5-----$531.76-----AT
Cooper Clubman--$19,950 ----28 37 32.5- ---$613.85-----6MT
Altima Hybrid --$25,170 ----35 33 34 ------$740.29-----6MT
Camry Hybrid ---$25,350 ----33 34 33.5 ----$756.72-----AT
Civic GX -------$24,590 ----24 36 30 ------$819.67-----5MT

 

Thanks for the post up pcs0snq
But I was curious as to what corrections you are speaking of.
Were they just missing info or wrong data? If you dont mind Just curious.

And thanks cojaro for the help in making some of it easier to read and look at

 

Snap. The model description was missing on many, EPA MPG was missing on many, I think two had a price error.

I had some time this AM to research that for this form, but it got busy and and was not able to clean up how it looked after the send key was hit .
Thanks cojaro for the assist.

I have the MS excel spread sheet if anyone wants it. Drop me an email
pcs0snq@comcast.net

I think I'm going to add some additional info and build it some more. Was going to look at the crash ratings and take a swag at the total cost of ownership over 5 and 10 years.....