havocdragon wrote...
Ok so I know what a mean average and a weighted average is, and how to
calculate them, however lets say I have the following info, and formula. what
is this type of average called?
A B
1| Number of parts Age of parts
2| 1 5
3| 2 6
4| 3 4
5| 4 8
6| 5 9
So if you just did the regular age of parts average you get 6.4
Where as the weighted average would be 3.31
however my formula multiplies the sum of A2:A6 and multiplies it by the
Average of B2:B6 getting the result of 96
What kind of average is that called? or if thats not an average, what is
that type of number called?
I believe it's called a mistake.
|