Tuesday....
VIP Member
iTrader: (7)
Joined: Jun 2003
Posts: 25,095
From: Funtown
Car Info: A limousine with a chauffer
VIP Member
iTrader: (17)
Joined: May 2005
Posts: 22,776
From: Sunnyvale, CA
Car Info: '13 BRZ Limited / '02 WRX
ok math/computer smarties, here's my situation. I logged my mpg on the way to work today and was going to do a simple average on excel but the average is getting thrown off by the numbers from when I was coasting not in gear (100+ mpg ftw). So here's where I need help. What's it called when you average a set of numbers excluding the really high and really low values. As it stands now with a simple average of all the values I got 57 mpg (suck on that prius). If anyone also knows the formula to stick in excel that'd be great too
Warm Fuzzy Admin
iTrader: (45)
Joined: Mar 2001
Posts: 13,799
From: Sacramento, CA
Car Info: 97 LOB, 05 FXT, 03 Tundra
It's a corrected average.......there's no formula, you just strip what you see as the offending data (based on what you're saying).
How would a simple algorithm be ale to interpret what you see is invalid data? If you have invalid data, exclude it from the set.
How would a simple algorithm be ale to interpret what you see is invalid data? If you have invalid data, exclude it from the set.
Registered User
Joined: Dec 2005
Posts: 799
From: trunk monkey
Car Info: 92 Paseo with spinaz, 2011 tooth white wrx
Ya, my wife and I love the place. Authentic taste and clean, those two terms don't usually reside in the same sentence when it comes to burritos.

Holy crap...
I think I just got... eye f00ked at work just now.
I was talking to this girl who always does the whole giggle-head-tilt-hair-flip thing with me every time I talk to her.
I was all, "
"But this time, she looked me up and down and then bit her lip.
It totally caught me off guard and I stopped in mid sentence. I was all, "Okay, well, I should get back to work."
As I turned the corner I heard her go, "mmmmmmmmmm."
x eleventy. I think she is in heat or something.Time to start wearing the wedding ring to work again, I guess.



