AVERAGEA:
Change Summary from
Average the set of numbers, including logical values inside a range.
to
Average values, including values of type Text and Logical.
Change Semantics to
Behaves similarly to the AVERAGE function, but includes values of type Text and Logical. Text values are treated as number 0. Logical True is treated as 1, and False is treated as 0. Empty cells are not included. Any N may be of type ReferenceList.
MAXA:
Change Summary from
Return the maximum from a set of numbers; logicals are always considered numbers.
to
Return the maximum from a set of values, including values of type Text and Logical.
Change Semantics to
Behaves similarly to the MAX function, but includes values of type Text and Logical. Text values are treated as number 0. Logical True is treated as 1, and False is treated as 0. Empty cells are not included. What happens when MAXA is provided 0 parameters is implementation-defined. Any N may be of type ReferenceList.
MINA:
Change Summary from
Return the minimum from a set of numbers; logicals are always considered numbers.
to
Return the minimum from a set of values, including values of type Text and Logical.
Change Semantics to
Behaves similarly to the MIN function, but includes values of type Text and Logical. Text values are treated as number 0. Logical True is treated as 1, and False is treated as 0. Empty cells are not included. What happens when MINA is provided 0 parameters is implementation-defined. Any N may be of type ReferenceList.
STDEVA:
Change Summary from
Calculates the standard deviation using a sample set of numbers.
to
Calculate the standard deviation using a sample set of values, including values of type Text and Logical.
Change Semantics from
In the sequence, only numbers and logical types are considered; cells with text are converted to 0; other types are ignored. If logical types are a distinct type, they are still included, with True considered 1 and False considered 0.
to
Behaves similarly to the STDEV function, but includes values of type Text and Logical. Text values are treated as number 0. Logical True is treated as 1, and False is treated as 0. Empty cells are not included.
and
The handling of strings is implementation defined. Either, strings are converted to numbers, if possible and otherwise, they are treated as zero, or strings are always treated as zero.
to
The handling of string constants as parameters is implementation-defined. Either, string constants are converted to numbers, if possible and otherwise, they are treated as zero, or string constants are always treated as zero.
STDEVPA:
Change Summary from
Calculates the standard deviation using the population of a random variable.
to
Calculates the standard deviation using the population of a random variable, including values of type Text and Logical.
Change Semantics same as in STDEVA.
VARA:
Change Summary from
Estimates the variance using a sample set of numbers.
to
Estimates the variance using a sample set of values, including values of type Text and Logical.
Change Semantics same as in STDEVA.
VARPA:
Change Summary from
Calculates the variance using the population of the distribution
to
Calculates the variance using the population of the distribution, including values of type Text and Logical.
Change Semantics same as in STDEVA.