Text exercise 39 page 638. This question uses the same data asexercise 2 above, and the data is in the accompanyingspreadsheet.
(a) Estimate the regression in Excel and report the regressionline.                                  [2pts]
(b) Calculate a  95% confidence interval for theforecast of the average amount spent on entertainment at a citywhere the room rate is$89.                                                       [3pts]
(b) Calculate a  90% confidence interval for theforecast of the idiosyncratic amount spent on entertainment at acity where the room rate is the average rate of$128.                        [3pts]
(d) Use a t-test to test the hypothesis that there is a 1 to 1relationship between entertainment expenses and hotel expenses. (ietest H0:β=1)                                                   Â
DATA:
| Data for Problem 39 p638 | |
| | | |
| city | room rate | Entertainment |
| Boston | 148 | 161 | |
| Denver | 96 | 105 | |
| Nashville | 91 | 101 | |
| New Orleans | 110 | 142 | |
| Phoenix | 90 | 100 | |
| San Fdiego | 102 | 120 | |
| San Francisco | 136 | 167 | |
| San Jose | 90 | 140 | |
| Tampa | 82 | 98 | |
