VAR.P function - Function that calculates variance based on the entire set, ignoring logical values and text in Excel
The following article introduces you to the VAR.P function - one of the functions in the statistical function group is very popular in Excel.
Description: The function performs calculation of variance based on the entire population, ignoring logical values and text. Support functions from Excel 2010 onwards.
Syntax: VAR.P (number1, [number2], .)
Inside:
- number1, [number2], .): The arguments in the whole need to calculate the variance, where number1 is the required argument, the next arguments are optional and contain up to 254 number arguments .
Attention:
- The VAR.P function assumes that its arguments are whole.
- Arguments can be numbers, names or arrays that contain numbers.
- If the argument is an array or a reference, only values in that array are used.
- When typing logical values and presenting numeric values into function arguments -> these values are still calculated.
- Function error occurs when arguments are text or error values cannot be converted.
- If you want to calculate both logical values and text -> use VARPA function .
- The equation to calculate the VAR.P function is:
[frac {{sum {{{left ({x - overline x} right)} ^ 2}}}} {n}]
Inside:
+ x is the sample mean AVERAGE (number1, number2, .)
+ n is the sample size.
For example:
Calculate variance based on the entire set of number values in the following data table:
- In the cell to calculate enter the formula : = VAR.P (D6: D10)
- Press Enter -> variance based on the entire set of number values is:
-Where the values are text or logic -> the function ignores these values:
Above are instructions and some specific examples when using VAR.P function in Excel.
Good luck!
You should read it
- VARA - Function that calculates variance based on a sample, including logical values and text in Excel
- VARP function - Functions for calculating variance based on an entire population in Excel
- STDEVPA function - The function of estimating standard deviations based on an entire population including both text and logical values in Excel
- STDEV.P function - The function returns the standard deviation based on the whole in Excel
- STDEV.S function - The function returns the standard deviation based on a sample in Excel
- STDEVA function - The function of estimating standard deviations based on a sample including both text and logical values in Excel
- MAXA function - The function returns the largest value in a set of values including text and logical values in Excel
- VAR function - The function of estimating variance based on a sample in Excel
May be interested
- MINA function - The function returns the smallest value in the given numbers including text and logical values in Excelmina function: the function returns the smallest value in the given numbers including text and logical values. syntax: mina (value1, [value2], ...)
- AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values in Excelaveragea function: the function returns the average of the arguments including numeric, text, and logical values. syntax: averagea (value1, [value2], ...)
- FREQUENCY function - Function that calculates and returns the frequency of occurrences of values in a range in Excelfrequency function: function that calculates and returns the frequency of occurrences of values within a certain range and returns a vertical number array. syntax: frequency (data_array, bins_array)
- How to use the SUMIF function in Excelthe sumif function in excel is a function used to compute values in a specified range. the sumif function can be used for summing cells based on the date, data and text that are connected to the specified area.
- How to use the MAXA function in Excel, detailed examplesthe maxa function in excel helps find the largest value in a data set, including numbers, logical values, and text containing numbers. this is different from the max function, which only counts numbers. let's learn the syntax and usage of the maxa function with practical examples.
- MINA function in Excel, how to use and examplesthe mina function in excel helps determine the smallest value in a range of numbers, including logical values and text numbers. with simple syntax, mina supports optimizing the calculation process in spreadsheets.
- SUMPRODUCT function in Excel: Calculates the sum of corresponding valuesthe sumproduct function is an extremely useful function when you have to deal with a lot of data numbers in microsoft excel. here are the things you need to know about the sumproduct function in excel.
- AND function in Excellogical functions are used a lot in excel with results that return true, false. the and function is a very common logical function in excel, but for those of you who are new to excel, it may not be clear.
- Logical functions (logical) in Excellogical functions are used a lot during data processing in excel. the article summarizes the syntax and functions of functions in logical function groups in excel.
- IFERROR function in Excel, formulas, and usagethe iferror function in excel corrects a formula error, returning a different value that replaces the error message in the normal way.