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
Mathematics, 21.06.2019 16:00
Acircle has a diameter will endpoints of (-2,8) and (6, 4). what is the center of the circle
Answers: 1
Mathematics, 21.06.2019 16:30
Arandom sample of 150 high school students were asked whether they have a job. the results are shown in the table. have a job do not have a job male 48 35 female 41 26 select a ord or phrase from the drop-down menus to correctly complete the statements describing the association.
Answers: 1
Mathematics, 21.06.2019 17:30
Consider the graph of the exponential function y=3(2)×
Answers: 1
OC Music Company has been in business for 4 years. Data about the sales of each quarter were collect...
Arts, 22.08.2020 23:01
English, 22.08.2020 23:01
Physics, 22.08.2020 23:01
History, 22.08.2020 23:01