LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
havocdragon
 
Posts: n/a
Default What is this kind of average called?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Label an average line in a dynamic chart John Cordes Charts and Charting in Excel 3 June 17th 05 09:42 AM
Average Formula with Criteria PW11111 Excel Discussion (Misc queries) 1 June 10th 05 02:22 PM
AVERAGE and STDEV functions with logic t-rung Excel Worksheet Functions 1 May 26th 05 07:11 PM
average function in Excel 2002 Sherry New Users to Excel 13 May 8th 05 01:49 PM
Average the Last Five Cells in a Column Warrior Princess Excel Worksheet Functions 3 March 16th 05 02:12 PM


All times are GMT +1. The time now is 04:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"