The senior vice president for marketing at Kean Hotel believes that the company’s recentadvertising of the hotel has decreased the average room idle rate. To test the hypothesis, random sample of daily idle rates (in percentages) before the advertising is collected. A similar random sample of daily idle rates is collected after the advertising took place. The data are as follows. Is there evidence that the average room idle rate of the hotel has decreased after the advertising at the 0.01 level of significance. (Show me every step including pre-step and post-step for full credit) Before (%) 8 17 12 21 19 10 After (%) 6 3 1 11 7 8
The senior vice president for marketing at Kean Hotel believes that the company’s recentadvertising of the hotel has decreased the average room idle rate. To test the hypothesis, random sample of daily idle rates (in percentages) before the advertising is collected. A similar random sample of daily idle rates is collected after the advertising took place. The data are as follows.
Is there evidence that the average room idle rate of the hotel has decreased after the advertising at the 0.01 level of significance.
(Show me every step including pre-step and post-step for full credit)
|
Before (%) |
8 |
17 |
12 |
21 |
19 |
10 |
|
After (%) |
6 |
3 |
1 |
11 |
7 |
8 |
Given data and calculation for mean and standard deviation is shown below-
Calculate mean using excel function-
=AVERAGE(-2:-2)
And standard deviation-
=STDEV.S(-2:-2)
Step by step
Solved in 2 steps with 2 images
