12.2 Mean and Standard Deviation of the Population

Assume that the data contains all the Close Prices of the FB stocks (it is data from a population). You will calculate the mean and standard deviation of the populations of FB Close Prices.

1. Go to an empty column in the Lab 12 FB Daily worksheet, and type the label Population, Mean and Stand Dev in separate cells.
2. Select the cell next to the cell Mean and enter the formula = AVERAGE(F2:F389) to compute the mean.
3. Select the cell next to the cell Stand Dev and enter = STDEV.P(F2:F389) to compute the data’s standard deviation of the population.
4. Adjust the mean and standard deviation values to two (2) decimal places.