VAR.S |
VAR.S(number1 [,number2] [..]) |
Returns the variance based on a sample. |
number1 | The first number. |
number 2 | (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 VARA function to return the variance based on a sample (including logical values and text). * You can use the VAR.P function to return the variance based on an entire population. * You can use the VARPA function to return the variance based on an entire population (including logical values and text). * You can use the DVAR function to return the variance of the values in a column that satisfies multiple conditions based on a sample. * This function was added in Excel 2010 to replace the VAR function. * For the Microsoft documentation refer to support.microsoft.com |
|
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top