- Picture and text skills
- Case
Calculates the variance based on the entire sample population. Not only numbers, but also text values and logical values such as TRUE and FALSE will be counted.
Syntax
VARPA(value1,value2,...)
Value1, value2,... are 1 to 30 parameters corresponding to the sample population.
Description
The function VARPA assumes that the parameter is the sample population. If the data represent a sample of the population, the variance must be estimated using the function VARA.
Arguments containing TRUE are evaluated as 1; arguments containing text or FALSE are evaluated as 0. If you cannot include text or logical values in the calculation, please
Use the VARP worksheet function instead.
where x is the sample mean AVERAGE(value1,value2,…) and n is the sample size.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/VARPA-han-shu-ji-suan-yang-ben-zong-ti-fang-cha.html
评论列表(196条)
测试