Question

In: Statistics and Probability

In exercise 12, the following data on x = average daily hotel room rate and y...

In exercise 12, the following data on x = average daily hotel room rate and y = amount spent on entertainment (The Wall Street Journal, August 18, 2011) lead to the estimated regression equation ŷ = 17.49 + 1.0334x. For these data SSE = 1541.4. Click on the webfile logo to reference the data.

a. Predict the amount spent on entertainment for a particular city that has a daily room rate of $89 (to 2 decimals).
$

b. Develop a 95% confidence interval for the mean amount spent on entertainment for all cities that have a daily room rate of $89 (to 2 decimals).
$ to $

c. The average room rate in Chicago is $128. Develop a 95% prediction interval for the amount spent on entertainment in Chicago (to 2 decimals).
$ to $

  • Check My Work

Icon Key

Question 7 of 10

Exercise 12.39

Solutions

Expert Solution

a). 109.46

b). 95% CI= (94.85, 124.08)

c). 95% PI = (110.69, 188.84)

Regression Analysis

0.740

n

9

r

0.860

k

1

Std. Error

14.839

Dep. Var.

Entertainment

ANOVA table

Source

SS

df

MS

F

p-value

Regression

4,378.5778

1  

4,378.5778

19.88

.0029

Residual

1,541.4222

7  

220.2032

Total

5,920.0000

8  

Regression output

confidence interval

variables

coefficients

std. error

   t (df=7)

p-value

95% lower

95% upper

Intercept

17.4915

24.8314

0.704

.5039

-41.2255

76.2084

Roomrate

1.0334

0.2318

4.459

.0029

0.4854

1.5814

Predicted values for: Entertainment

95% Confidence Intervals

95% Prediction Intervals

Roomrate

Predicted

lower

upper

lower

upper

Leverage

89

109.465

94.847

124.083

71.453

147.478

0.174

128

149.769

132.574

166.964

110.693

188.844

0.240

NOTE:: I HOPE YOUR HAPPY WITH MY ANSWER....***PLEASE SUPPORT ME WITH YOUR RATING...

***PLEASE GIVE ME "LIKE"...ITS VERY IMPORTANT FOR ME NOW....PLEASE SUPPORT ME ....THANK YOU


Related Solutions

Exercise 1: (10 marks) Average daily hotel room rate (x) and amount spent on entertainment (y)...
Exercise 1: Average daily hotel room rate (x) and amount spent on entertainment (y) is given in the following table for different cities. a.       Use these data to develop an estimated regression equation that could be used to predict the amount spent on entertainment for a given average daily hotel room rate. b.       What is the value of sample correlation coefficient? c.       Compute the coefficient of determination. What percentage of the variation in total amount spent on entertinment can be...
Ada Hotel sells two room tpes: standard rooms and deluxe rooms. Average daily rate (ADR) and...
Ada Hotel sells two room tpes: standard rooms and deluxe rooms. Average daily rate (ADR) and variable costs (VC) of the two room types are provided in the table below: (Hint: Treat two room types as two different products.)                                                 ADR ($)   Variable Cost ($)               Standard rooms    394.50   256.43               Deluxe rooms   631.20   366.10                                     ...
Problem 2. Ada Hotel sells two room tpes: standard rooms and deluxe rooms.  Average daily rate (ADR)...
Problem 2. Ada Hotel sells two room tpes: standard rooms and deluxe rooms.  Average daily rate (ADR) and variable costs (VC) of the two room types are provided in the table below: (Hint: Treat two room types as two different products.) ADR ($) Variable Cost ($) Standard rooms 461.20 299.78 Deluxe rooms 737.92 427.99 The Mock Hotel's fixed costs for a month is =          = 295168 Sales mix (contribution of each room type to total room revenue) of the hotel is: Deluxe...
A researcher wished to compare the average daily hotel room rates between San Francisco and Los...
A researcher wished to compare the average daily hotel room rates between San Francisco and Los Angeles. The researcher obtained an SRS of 15 hotels in downtown San Francisco and found the sample mean ? ̅1=$156, with a standard deviation ?_1= $15. The researcher also obtained an independent SRS of 10 hotels in downtown Los Angeles and found the sample mean ? ̅_2= $143, with a standard deviation ?_2= $10. Let 1 and 2 represent the mean cost of the...
The average daily rate of a hotel in Canada as of August 2018 was $182.65. Assume...
The average daily rate of a hotel in Canada as of August 2018 was $182.65. Assume the average daily rate follows a normal distribution with a standard deviation of $25.70. Standard Normal Distribution Table a. What is the probability that the average daily rate of a Canadian hotel will be: (i) less than $175 P(X < 175)=P(X < 175)= (ii) more than $200 P(X > 200)=P(X > 200)= (iii) Between $150 and $190 P(150 < X < 190)=P(150 < X...
The average daily rate of a hotel in Canada as of August 2018 was $184.85. Assume...
The average daily rate of a hotel in Canada as of August 2018 was $184.85. Assume the average daily rate follows a normal distribution with a standard deviation of $27.70. Standard Normal Distribution Table a. What is the probability that the average daily rate of a Canadian hotel will be: (i) less than $165 P(X < 165)=P(X < 165)= (ii) more than $215 P(X > 215)=P(X > 215)= (iii) Between $160 and $190 P(160 < X < 190)=P(160 < X...
The average daily rate of a hotel in Canada as of August 2018 was $172.75. Assume...
The average daily rate of a hotel in Canada as of August 2018 was $172.75. Assume the average daily rate follows a normal distribution with a standard deviation of $28.60. Standard Normal Distribution Table ( note you need access to this table in order to do this question) a. What is the probability that the average daily rate of a Canadian hotel will be: (i) less than $175 P(X < 175)=P(X < 175)= (ii) more than $205 P(X > 205)=P(X...
Patients arrive at the emergency room of Mercy Hospital at the average rate of 12 in...
Patients arrive at the emergency room of Mercy Hospital at the average rate of 12 in 60 minutes. what is the probability that 10 patients will arrive in 60 minutes? What is the probability that 4 patients will arrive in 30 minutes?
The manager of a hotel is negotiating with a client the room rate that will be...
The manager of a hotel is negotiating with a client the room rate that will be charged to the attendees of an assembly to be held at the hotel. In this type of activity, the organizers are responsible for obtaining a rate for the rooms that is competitive for the attendees and for a minimum number of people to stay during the activity. The cost of the rooms is paid by the attendees and is NOT included in the cost...
Solve for the predicted values of y and the residuals for the following data. x 12...
Solve for the predicted values of y and the residuals for the following data. x 12 21 28 8 20 y 17 15 22 19 24 Do not round the intermediate values. (Round your answers to 3 decimal places.) x y Predicted (ŷ) Residuals (y-ŷ) 12 17 21 15 28 22 8 19 20 24
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT