Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

John Henry, the owner of the Red Sox would like to know the success of an advertising campaign for Sox memorabilia to be called Fangs

John Henry, the owner of the Red Sox would like to know the success of an advertising campaign for Sox memorabilia to be called "Fangs for the Memories" after trading away one of his best players. Henry has hired various students to forecast sales for the first two quarters of 2023. This is the sixth year of the advertising campaign. Hence they have six years of quarterly data (2017 Q1 to 2022 Q4) to make their forecast. The various student groups use the will the following models:

Model 1 (Steve, Pat, Wei, Landon, Jiaqi): A simple linear trend model

Model 2(Dan, Besty, Nick, Michelle, Eric): A model with dummy variables to account for seasonality

Model 3(Kaylee, John, Zach, Evan, Connor): A model with both dummy variables to account for seasonality and trend

Use those SPSS results to answer the following questions for John Henry: (30 points) a) Using Model 3, developed the 95% confidence intervals estimates for the first quarter of 2023

b) Which of the models are statistically significant?

c) Evaluate the assumptions of OLS satisfied for all three models.

d) Given that actual sales (in the millions) for the first two quarters of 2023 are:

2023 Q1 = 90

2023 Q2 = 80

Calculate the MAD for using model 3.

e) For what quarter are sales the lowest? WHY?

f) Should John Henry utilize any of these models in making their forecasts for 2023? WHY? g) If you were John Henry of the Sox, would you continue this advertising campaign? WHY?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematical Applications For The Management, Life And Social Sciences

Authors: Ronald J. Harshbarger, James J. Reynolds

12th Edition

978-1337625340

More Books

Students also viewed these Mathematics questions