Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A travel agency has offices in 12 cities. Management believes that monthly airline bookings are related to the mean income in those cities (Travel agency
- A travel agency has offices in 12 cities. Management believes that monthly airline bookings are related to the mean income in those cities ("Travel agency data.xlsx")
- Fit a regression model to forecast bookings. Provide the equation of the fit line and interpret the model parameters in the context of the problem.
- Evaluate the regression model
- What are the forecasted monthly bookings for a city with an average income of $47,250?
Location | Bookings | Income |
1 | 1,098 | 43,299 |
2 | 1,131 | 45,021 |
3 | 1,120 | 40,290 |
4 | 1,142 | 41,893 |
5 | 971 | 30,620 |
6 | 1,403 | 48,105 |
7 | 855 | 27,482 |
8 | 1,054 | 33,025 |
9 | 1,081 | 34,687 |
10 | 982 | 28,725 |
11 | 1,098 | 37,892 |
12 | 1,387 | 46,198 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started