Home > Software Tutorial > Office Software > How to calculate the variance of a set of data in Excel

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

WBOY
Release: 2024-04-25 12:49:40
forward
630 people have browsed it

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.

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

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

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

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.

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

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

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

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

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

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

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

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!

source:zol.com.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template