The Wall Street Journal asked Concur Technologies, Inc., an expense management company, to examine data from 8.3 million expense reports to provide insights regarding business travel expenses. Their analysis of the data showed that New York was the most expensive city. The following table shows the average daily hotel room rate (2) and the average amount spent on entertainment (y) for a random sample of 9 of the 25 most-visited U.S. cities. These data lead to the estimated regression equation ŷ = 17.49 + 1.0334x. For these data SSE = 1541.4. Click on the datafile logo to reference the data. Use Table 1 of Appendix B. DATA file Room Rate Entertainment City ($) (s) Boston 148 161 Denver 96 105 Nashville 91 101 New Orleans 110 142 Phoenix 90 100 San Diego 102 120 San Francisco 136 167 06 82 San Jose 140 Tampa 98 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). 128 to $ 149.77 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). $ 110.69 to $ 188.84
The Wall Street Journal asked Concur Technologies, Inc., an expense management company, to examine data from 8.3 million expense reports to provide insights regarding business travel expenses. Their analysis of the data showed that New York was the most expensive city. The following table shows the average daily hotel room rate (X) and the average amount spent on entertainment (Y) for a random sample of 9 of the 25 most-visited U.S. cities. These data lead to the estimated regression equation y = 17.49 + 1.0334x. For these data SSE = 1541.4. Use Table 1 of Appendix B.
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).
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).
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images