Chapter 4, Problem 4.BE

Interpretation Introduction

Interpretation:

Using spreadsheet, the mean and standard deviation of a given column of numbers in two different ways has to be computed.

Concept Introduction:

Mean:

The Mean or the arithmetic mean ( $\overline{x}$) is given as the summation of measured values divided by the number of measurements (n). Mean is also called as average.

$\overline{x}=\frac{{\displaystyle \sum _i{x}_i}}{n}$

Standard deviation:

Standard deviation measures how closely the data are clustered about the mean.

The standard deviation (s) is given by the formula:

$s=\sqrt{\frac{{\displaystyle \sum _i{(x_i-\overline{x})}^2}}{n-1}}$

To Compute: The mean and standard deviation of a given column of numbers in two different ways using spreadsheet.