Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The following table contains the demand from the last 12 months: Quarter Sales 1 600 2 1550 3 1800 4 2100 5 2400 6 3100
The following table contains the demand from the last 12 months:
Quarter | Sales |
1 | 600 |
2 | 1550 |
3 | 1800 |
4 | 2100 |
5 | 2400 |
6 | 3100 |
7 | 2600 |
8 | 2905 |
9 | 3800 |
10 | 4500 |
11 | 4100 |
12 | 4900 |
a. Please use simple linear regression to forecast the next 4 quarter demand. [You need to generate the regression report and calculate the next 4 quarters' forecasting demand]
b. Please write down the linear regression model.
c. Based on the simple linear regression results, please answer the following questions: 1) What % of the variation in the data is explained by the model? 2) Is there a significant relationship between demand and quarter (significance level =0.05)? (yes or no)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started