Formulas and Functions

Table Of Contents

Chapter 10 Statistical Functions 301

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).

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

temperatures.