View Single Post
  #1   Report Post  
kthenning
 
Posts: n/a
Default 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