Text exercise 39 page 638. This question uses the same data as exercise 2 above, and...

90.2K

Verified Solution

Question

Statistics

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
cityroom rateEntertainment
Boston148161
Denver96105
Nashville91101
New Orleans110142
Phoenix90100
San Fdiego102120
San Francisco136167
San Jose90140
Tampa8298

Answer & Explanation Solved by verified expert
3.8 Ratings (716 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students