1.A random sampleof 5 dates is selected and a standard deviationis calculated for these 5 dates. The dates and the respective temperatures are:
Date Temperature
August 1 94
August 3 99
August 8 78
August 11 88
August 14 88
What is the varianceof these values?
2. If you are to determine that standard deviation for the temperature of all 14 dates in August, which formula should you use for you calculation?
1. What is the variance of these values?
See Excel file.
The variance is 61.8 degrees.
2. If you are to determine that standard deviation for the temperature of all 14 dates in August, which formula should …
The solution shows you how to use Excel to find the variance and standard deviation of a sample.