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?
- Quarterly sales ($ thousands) and income ($ billions) were tracked between March 2007 and December 2016 ("Sales income data.xlsx").
- Using the first 32 observations as a training set, fit a regression model to forecast quarterly sales for next year using income. Provide the equation of the fit line
- Evaluate the regression model
- Check the regression model assumptions
- How well is the model fit?
- How accurate is the model?
- Monthly shoe sales (millions of dollars) were collected between January 2002 and December 2005 ("Shoe sales data.xlsx")
- Using the appropriate plots, how would you characterize the data? Explain
- Build a regression model to forecast sales
- Deseasonalize sales and build a regression model to forecast sales
- What is the seasonal index of the month of August? Interpret its meaning
- Using R2, MAPE and RMSE, compare the fit of the models in part (b) and (c)
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