What is the variance function in excel

The functions of variance in excel are: VAR() and VARP(). The VAR() function can calculate the variance based on a given sample, the syntax "VAR(num1,[num2],...)"; the VARP() function can calculate the variance based on the entire population, the syntax "VARP(num1,[num2], ...)".

The operating environment of this article: windows10 system, microsoft office excel 2019, thinkpad t480 computer.

Related learning recommendations: excel tutorial

excel VAR() function

The calculation is based on Determine the sample variance.

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.

excel VARP() function

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.

Remarks

VAR assumes that its parameters are the population sample. If the data are representative of the entire population, use VARP to calculate the variance.
Parameters can be numbers or names, arrays, or references containing numbers.
Logical values ​​and text representing numbers typed directly into the argument list are counted.
If the argument is an array or reference, only the numbers in it are calculated. Blank cells, logical values, text, or error values ​​in arrays or references are ignored.
If the parameter is an incorrect value or is text that cannot be converted to a number, an error will result.
Use the VARA function if you want the calculation to include logical values ​​in references and text representing numbers.
VAR uses the following formula:

• The formula for VARP is:

  Where x is the sample average AVERAGE (number1, number2,...) n is the sample size.

To read more related articles, please visit

PHP Chinese website

! !

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!