Mathematics, 31.03.2021 01:00 Lovely3719

OC Music Company has been in business for 4 years. Data about the sales of each quarter were collected below. The manager wants use these data to forecast sales of the 5th year. Please copy and paste it to Excel and run regression analysis. Answer the following 4 questions. Year Quarter Sales
1 Q1 7
Q2 2
Q3 4
Q4 10
2 Q1 6
Q2 3
Q3 8
Q4 14
3 Q1 10
Q2 3
Q3 5
Q4 16
4 Q1 12
Q2 4
Q3 7
Q4 22
1) Develop a model for trend and seasonality. Please clearly define your variables. How many independent variables do you have in your regression?
2) What is the intercept in your estimated regression model? Rounded to two decimal places.
3) Use the model to forecast for sales of last quarter in the 5th year. Rounded to two decimal places.
4) Calculate the MAE for this time series forecast.

Answers: 2

Show answers

Other questions on the subject: Mathematics

Mathematics, 21.06.2019 16:40, dubouuu

Which data set has a greater spread? why? set a: {38, 12, 23, 48, 55, 16, 18} set b: {44, 13, 24, 12, 56} has a greater spread because .

Answers: 2

continue

Mathematics, 21.06.2019 20:30, nosugh

If m∠abc = 70°, what is m∠abd? justify your reasoning. using the addition property of equality, 40 + 70 = 110, so m∠abd = 110°. using the subtraction property of equality, 70 − 30 = 40, so m∠abd = 30°. using the angle addition postulate, 40 + m∠abd = 70. so, m∠abd = 30° using the subtraction property of equality. using the angle addition postulate, 40 + 70 = m∠abd. so, m∠abd = 110° using the addition property of equality.

Answers: 2

continue

Mathematics, 21.06.2019 22:30, alonnachambon

Factor the polynomial by its greatest common monomial factor.

Answers: 1

continue

Mathematics, 21.06.2019 23:30, yaretxi

If you measured the width of a window in inches and then in feet with measurement would you have the greater number of units

Answers: 3

continue

You know the right answer?

OC Music Company has been in business for 4 years. Data about the sales of each quarter were collect...