Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Label an average line in a dynamic chart | Charts and Charting in Excel | |||
Average Formula with Criteria | Excel Discussion (Misc queries) | |||
AVERAGE and STDEV functions with logic | Excel Worksheet Functions | |||
average function in Excel 2002 | New Users to Excel | |||
Average the Last Five Cells in a Column | Excel Worksheet Functions |