Formulas and Functions

Table Of Contents

Chapter 10 Statistical Functions 295

The standard deviation is the square root of the variance returned by the VARPA Â

function.

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 sensor failed after the rst few days so the following table is the

population of high and low temperatures.

=STDEVPA(B2:B13) returns 23.7702, the dispersion as measured by STDEVPA, 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.