(a) Use Excel functions to calculate the mean and standard deviation for weekend occupancy rates (percent) in nine resort hotels during the off-season (b) What conclusion would a casual observer draw about center and variability based on your statistics? (c) Now calculate the median for each sample (d) Make a dot plot for each sample (e)What did you learn from the medians and dot plots that was not apparent from the means and standard deviations?
Observation | Week 1 | Week 2 | Week 3 | Week 4 |
1 | 32 | 33 | 38 | 37 |
2 | 41 | 35 | 39 | 42 |
3 | 44 | 45 | 39 | 45 |
4 | 47 | 50 | 40 | 46 |
5 | 50 | 52 | 56 | 47 |
6 | 53 | 54 | 57 | 48 |
7 | 56 | 58 | 58 | 50 |
8 | 59 | 59 | 61 | 67 |
9 | 68 | 64 | 62 | 68 |
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.