subject
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.

ansver
Answers: 2

Another question on Mathematics

question
Mathematics, 21.06.2019 14:30
Which interval for the graphed function contains the local maximum? [–3, –2] [–2, 0] [0, 2] [2, 4]
Answers: 2
question
Mathematics, 21.06.2019 15:00
Aregular hexagon rotates counterclockwise about its center. it turns through angles greater than 0° and less than or equal to 360°. at how many different angles will the hexagon map onto itself?
Answers: 2
question
Mathematics, 22.06.2019 03:40
True or false? the sum of the differences (% - 7) is never zero for any distribution consisting of n observations.
Answers: 1
question
Mathematics, 22.06.2019 04:20
Out of the 180 students at a summer camp, 72 signed up for canoeing. there were 23 students who signed up for trekking, and 13 of those students also signed up for canoeing. use a two-way table to organize the information and answer the following question: approximately what percentage of students signed up for neither canoeing nor trekking? 72% 40% 54% 98%
Answers: 1
You know the right answer?
OC Music Company has been in business for 4 years. Data about the sales of each quarter were collect...
Questions
question
Chemistry, 12.02.2021 23:10
question
Mathematics, 12.02.2021 23:10
question
Social Studies, 12.02.2021 23:10
Questions on the website: 13722360