b. Use Excel to select a random sample of 5 days in June 2017 and calculate the sample mean. Calculate the sampling error.
b:
There are 30 days in June. We need to generate 5 numbers between 1 and 30. Using excel function "=RANDBETWEEN(1,30)" , following are the selected days and calculations for mean and SD:
X | (X-mean)^2 | |
22 | 1.44 | |
16 | 23.04 | |
29 | 67.24 | |
27 | 38.44 | |
10 | 116.64 | |
Total | 104 | 246.8 |
The mean is
The standard deviation is
The sampling error is
Get Answers For Free
Most questions answered within 1 hours.