Quote:
Originally Posted by Mr. Kite
If you go to the Civic Hybrid II database and sort by distance, you will see the inactive entries with single digit miles. Can these be deleted as well? Can we come up with some guidelines here?
|
Agreed. An extra EDIT or six
would eliminate some future obviously incorrect entries. So long as the VAST majority of people are entering data in honestly (without malice, at least), then the mean, median, and averages will work out OK for the more popular vehicles. But just a few wildly incorrect entries can ruin the reliability of a small sample size (say, currently for the Altima and VUE hybrids).
EASY EDITS:
(1) IF FUEL (MPG) < 1, error. Do not save entry.
(2) IF FUEL (MPG) > 300, error. Do not save entry.
(3) IF FUEL (GAL) < 1, error. Do not save entry. An entry of this sort *could* be valid, although highly statistically inaccurate, due to the small fuel usage, and variability of fuel refills.
(4) IF FUEL (GAL) > 50, error. Do not save entry. It's possible someone wants to input an entry covering many, many miles (and thus many GAL). Make them separate this large and unusual entry into chunks of 50 GAL or less.
(5) IF DISTANCE < 10, error. Do not save entry.
(6) IF DISTANCE / GAL less than 1, or greater than 300, error. Do not save entry.
These are simple edits.
You could change any of the numbers to make the valid ranges tighter, although as time goes by, we hope to be in vehicles that CAN hit 301 MPG
