4.Ĝompute the square deviations from the mean by entering =(A2-F$2)^2 in D2 and dragging the formula to the end of the data.Ĭompute the variance as a weighted average of the square deviations.Compute the mean by entering =C9/B9 in F2.Compute the sum of values*counts by copying the formula from B9 to C9.
#Excel average and standard deviation in graph how to
Section A.3 How to compute the mean and standard deviation in both Microsoft Excel and Google Sheets