VARPA |
VARPA(value1 [,value2] [..]) |
Returns the variance based on an entire population (including logical values and text). |
value1 | The first value. |
value2 | (Optional) The second value. |
REMARKS |
* This function assumes that the arguments represent the entire population (as opposed to a sample). * This is identical to the VAR.P function except that text and logical values are included. * VARPA assumes that its arguments are the entire population. If your data represents a sample of the population, you must compute the variance using VARA. * Arguments that contain TRUE evaluate as 1; arguments that contain text or FALSE evaluate as 0 (zero). * Using the data from the VARA example and assuming that only 10 tools are produced during the production run, VARPA measures the variance of breaking strengths for all the tools. * You can have a maximum of 30 arguments. * For the Microsoft documentation refer to support.microsoft.com |
|
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top