![alejandr1872913](/avatars/36521.jpg)
alejandr1872913
31.03.2021 •
Mathematics
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.
Solved
Show answers
More tips
- L Leisure and Entertainment 10 Ways to Celebrate Your Favorite Holidays: A Guide to Festivities and Traditions...
- S Sport When will the Biathlon World Championships 2011 take place in Khanty-Mansiysk? Answers to frequently asked questions...
- O Other What is a Disk Emulsifier and How Does it Work?...
- F Family and Home What does a newborn need?...
- F Family and Home Choosing the Right Car Seat for Your Child: Tips and Recommendations...
- F Food and Cooking How to Get Reconfirmation of Registration?...
- C Computers and Internet How to Get Rid of Spam in ICQ?...
- A Art and Culture Who Said The Less We Love a Woman, the More She Likes Us ?...
- F Family and Home How to Get Rid of Your Neighbors?...
- S Society and Politics How Could Nobody Know About the Dead Mountaineers?...
Ответ:
1
Step-by-step explanation:
Divide both side by the co efficient of x
1