Mean, StdDev, and Variance (for subset of data)
Posted on 2013-06-18
I need some help with computing (in Excel) the mean, standard deviation, and variance.
Trick is that some survey answers have not been selected (e.g., value of 0) and thus must be skipped.
For example, the following data set must provide the following answers:
Answer ID: Number of Responses
Average = 4.40
StDev = 1.52
Variance = 2.30
Again, given that zeros must be ignored, what are the proper Excel functions for each of these three statistics?