Formulas and Functions

Table Of Contents

Example

Assume you have installed a temperature sensor in Cupertino, California. The sensor records each

day’s high and low temperatures. In addition, you have kept a record of each day you turned on the

air conditioner in your condo. The data from the rst few days is shown in the following table and is

used as a sample for the population of high and low temperatures (note that this is an example only;

this would not be statistically valid).

=STDEVA(B2:B13) returns 24.8271, the dispersion as measured by STDEVA, of the sample of daily high

temperatures.

It exceeds the actual range of high temperatures of 15 degrees because the “unavailable” temperature

is given a value of zero.