Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I give weights to averages
How do I give different weights to the totals That I am averaging?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I give weights to averages
Let's say column A contains the values and B contains the weights, expressed
as decimals. Column B needs to sum to 100% for this to be correct. =sumproduct(A1:A10,B1:b10)/sum(A1:a10) "sds1rrnch" wrote: How do I give different weights to the totals That I am averaging? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I give weights to averages
Multiply them by a percent.
All percents must add to 100% Example: A1: a sum that equals 100 A2: a sum that equals 50 B1: 75% B2: 25% B3: =sumproduct(A1:A2,B1:B2) The weighted average is 87.5 Note: That formula is the same as: B3: =(A1*B1)+(A2*B2) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "sds1rrnch" wrote: How do I give different weights to the totals That I am averaging? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I give weights to averages
Not quite correct:
=sumproduct(A1:A10,B1:b10) "Duke Carey" wrote: Let's say column A contains the values and B contains the weights, expressed as decimals. Column B needs to sum to 100% for this to be correct. =sumproduct(A1:A10,B1:b10)/sum(A1:a10) "sds1rrnch" wrote: How do I give different weights to the totals That I am averaging? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
averages in pivot tables | Excel Discussion (Misc queries) | |||
Help I Am Ready To Give Up | Excel Worksheet Functions | |||
calculating averages | Excel Discussion (Misc queries) | |||
Give multiple charts on a worksheet/workbook same header or footer | Charts and Charting in Excel | |||
Min & Max Averages | Excel Worksheet Functions |