Exclude 0 mAh values from average computations

TheBum · 09-17-2009

The subject says it all. I sometimes don't enter a value, especially if I forget to time a flight. Including the 0 values just skews the data.

gregt · 09-18-2009

Quote:

Originally Posted by TheBum

The subject says it all. I sometimes don't enter a value, especially if I forget to time a flight. Including the 0 values just skews the data.

I'll double check it, but I'm pretty sure I'm throwing out null and 0 values before averaging.

gregt · 09-18-2009

Yep. I thought I had thought of that.

select avg(mah) mahs
from flights
where battery_id = $bid
and mah > 0

TheBum · 10-02-2009

OK, thanks. I thought that I had some skew on my averages due to the 0 values, but I guess not.

09-17-2009	#1
TheBum Junior Member Join Date: Oct 2008 Posts: 10	Exclude 0 mAh values from average computations The subject says it all. I sometimes don't enter a value, especially if I forget to time a flight. Including the 0 values just skews the data.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode


Home Flights Aircraft Batteries Fuels Locations Calculators Forums

09-18-2009	#3
gregt Administrator Join Date: Aug 2008 Posts: 89	Yep. I thought I had thought of that. select avg(mah) mahs from flights where battery_id = $bid and mah > 0

10-02-2009	#4
TheBum Junior Member Join Date: Oct 2008 Posts: 10	OK, thanks. I thought that I had some skew on my averages due to the 0 values, but I guess not.