VARA |
VARA(value1 [,value2] [..]) |
Returns the variance based on a sample (including logical values and text). |
value1 | The first value. |
value2 | (Optional) The second value. |
REMARKS |
* This function assumes that the arguments represent a sample from the population (as opposed to the entire population). * This is identical to the VAR function except that text, logical values and errors are included. * The variance is the average of the square of the deviations. * If your data represents the entire population, you must compute the variance using VARPA. * Any values that contain TRUE evaluate to the number 1. * Any values that contain FALSE evaluate to the number 0. * You can have a maximum of 30 arguments. * You can use the VAR.P function to * You can use the VAR.S function to * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.com |
|
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top