VAR.P |
VAR.P(number1 [,number2] [..]) |
Returns the variance based on an entire population. |
number1 | The first number. |
number2 | (Optional) The second number. |
REMARKS |
* The variance is a measure of how Dispersed the values are from the mean. * The standard deviation is a measure of how Dispersed the values are from the mean and is the square root of the variance. * You can have a maximum of 255 arguments. * You can use the VAR.S function to return the variance based on a sample. * You can use the VARA function to return the variance based on a sample (including logical values and text). * You can use the VARPA function to return the variance based on an entire population (including logical values and text). * You can use the DVARP function to return the variance of the values in a column that satisfies multiple conditions based on an entire population. * This function was added in Excel 2010 to replace the VARP function. * For the Microsoft documentation refer to support.microsoft.com |
|
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top