How to calculate the variance of a set of data in Excel

Want to calculate the variance of a set of data, how to do it in Excel? PHP editor Yuzai will provide you with detailed step-by-step instructions to help you easily master the variance calculation method in Excel. Please continue reading below to learn the specific steps and practical demonstrations of calculating variance in Excel.

1. For the standard deviation calculation function in Excel, we only need to use this function to operate.

2. The author here uses the calculation of the variance of some score data as a demonstration.

3. First, we have a total of 42 data samples. We click on the cell that needs to be used as a demonstration.

4. Enter =STDEVP() in the address bar of the cell. This STDEVP is the function for calculating the standard deviation. You need to know this.

5. Next, we put the mouse inside the brackets and find that there is a range that needs to be selected.

6. Then we select the data we need to calculate the variance and drag it from the top to the bottom.

7. Finally, press Enter to confirm. Finally, we can find the range data and standard results we confirmed.

8. The above is the process of calculating the standard deviation. In addition, the standard deviation is the arithmetic square root of the variance. The standard deviation is represented by s. The variance is the square of the standard deviation. The variance is represented by s^2. Finally, We can square the result

9. Finally, when entering brackets, the input method needs to be in English mode, otherwise an error will be displayed

Note:

1. STDEV: Purpose: Estimate the standard deviation of the sample. It does not evaluate text values ​​and logical values ​​(such as TRUE and FALSE). It reflects the degree of dispersion of data relative to the mean. 2.STDEVA: Estimate the standard deviation based on the sample. Standard deviation reflects the spread of values ​​relative to the mean (mean). Text values ​​and logical values ​​such as TRUE and FALSE are also counted.

2. Simply put, the denominator in the root of the function stdev is n-1, and stdevp is n. If it is sampling, of course use stdev. If the standard deviation of the ten data is the population, use STDEVP. If If it is a sample, use STDEV.

The above is the detailed content of How to calculate the variance of a set of data in Excel. For more information, please follow other related articles on the PHP Chinese website!