![]() VAR takes the sum of the squares of each value's deviation from the mean and divides by the number of such values minus one. To calculate variance across an entire population, use VARP. To calculate variance while interpreting text values as 0, use VARA. ![]() VAR will return an error if all of the value arguments are text. If the total number of values supplied as value arguments is not at least two, VAR will return the #DIV/0! error. Additional values or ranges to include in the sample.Īlthough VAR is specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function. Value1 - The first value or range of the sample. Tip: Returning sample variance across multiple columns is not supported. column - The data column of the sample.Calculates the sample variance of a data column.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |