The conversion formula becomes. Divide the result by total number of observations n minus 1. High variance indicates that data values have greater variability and are more widely dispersed from the mean.
We are testing a sample mean without a known population standard deviation.
The AVERAGE function does the same thing as mean. The result is the mean. 4 8 6 5 3 2 8 9 2 5 10 52. In excel we use the AVERAGE function to calculate the mean of data.