Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Weighted Average Standard Deviation
I'm doing a customer survey where people have responded:
Agree strongly 331 Agree somewhat 100 Neither 50 Disagree somewhat 10 Disagree strongly 5 I want to assign a 1 to 5 score to each response (1=agree strongly) and get the weighted average standard deviation using just the frequencys above. Is this possible in Excel? If so, what would the equation be? I saw another post about a wmean, wsd...but the equation returns a !NAME error. Please help...Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating a weighted average using formula | Excel Worksheet Functions | |||
calculating a weighted average uisng formula | Excel Worksheet Functions | |||
Show weighted average value after filter. | Excel Worksheet Functions | |||
How to calculate 2 standard deviation? | Excel Worksheet Functions | |||
Histrogramms: Calculating average and standard deviation | Excel Worksheet Functions |