VAR |
VAR(number1 [,number2] [..]) |
Returns the variance based on a sample. |
number1 | The first number. |
number2 | (Optional) The second number. |
REMARKS |
* This function is only available for backwards compatibility and should not be used. * VAR.S was added in Excel 2010 to replace this function. * 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. * This function assumes that the arguments represent a sample from the population (as opposed to the entire population). * Text and logical values such as True and False are ignored. * You can have a maximum of 255 arguments * If you do not want to count any arguments that are text, logical values or errors you can use the VARA function. * You can use the VAR.P function to return the variance based on an entire population. * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.com |
|
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top