What is the variance function in excel

There are two excel variance functions: 1. VAR() function, which can calculate the variance based on a given sample, the syntax "VAR(num1,[num2],...)"; 2. VARP() Function that can calculate the variance based on the entire population, syntax "VARP(num1,[num2],...)".

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2007 version, Dell G3 computer.

1. Variance function: VAR()

Calculate the variance based on a given sample.

Syntax:

VAR(number1,[number2],...)

VAR function syntax has the following parameters:

• ##Number1 Required. Corresponds to the first numerical parameter of the population sample.

• Number2, ... Optional. 2 to 255 numerical parameters corresponding to the population sample.

2. Variance function: VARP()

Calculate the variance based on the entire population.

Syntax:

VARP(number1,[number2],...)

VARP function syntax has the following parameters:

##Number1 Required. Corresponds to the first numerical parameter of the population.
Number2,... Optional. Corresponds to 2 to 255 numerical parameters of the population.

Example: Take the VARP function as an example

1. Double-click the cell where the variance value needs to be filled in, and enter the "=" sign. As shown in the figure below:

2. In the function editing column, fill in the VARP function. If it is a continuous column of values, you can use ":" to indicate the starting cell and the end. The cell position is as shown in the figure below:

3. If you need to select several individual cells for variance calculation, you can enter VARP in the function edit bar. function, and then enter the cell positions respectively, separated by ",", as shown in the following figure:

4. After editing the formula, click Return Click the Car button to get the calculation results, as shown below:

Extended information:

In the statistical description , variance is used to calculate the difference between each variable (observation) and the population mean. In order to avoid the sum of squared differences from the mean being zero, the sum of squared differences from the mean is affected by the sample size. Statistics use the average sum of squared differences from the mean to describe the degree of variation of a variable.

Overall variance calculation formula:

Among them,

is the overall variance, X is the variable, u is the overall mean, and N is the overall number of cases

Related learning recommendations:

excel tutorial

The above is the detailed content of What is the variance function in excel. For more information, please follow other related articles on the PHP Chinese website!