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.
- Go to an empty column in the Lab 12 FB Daily worksheet, and type the label Population, Mean and Stand Dev in separate cells.
- Select the cell next to the cell Mean and enter the formula
= AVERAGE(F2:F389)
to compute the mean. - 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. - Adjust the mean and standard deviation values to two (2) decimal places.