anat0l
Enthusiast
- Joined
- Dec 30, 2006
- Posts
- 11,669
Nope not even going to try and work that one out on excel.... Especially since I've got all the ages in days....
Just take the age and divide by 365.25, then use ROUND(). After that, do a COUNTIF on a range of answers from 1 - 10, or do a frequency plot.
I don't think the formula you gave works to find the middle number.
9.17 is the age of the aircraft in the middle. The youngest aircraft is 43 days old from first test flight.
In Excel, MEDIAN() will find it (but you probably knew that already).
If you really want to try and impress the inner statisticians, an age distribution histogram would be most useful (and if you can code / colour code them by aircraft type, even better :mrgreen