Question: Please answer all question part on excel The following table contains the demand from the last 12 months: Quarter Sales 1 600 2 1550 3

Please answer all question part on excel

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 forecasting quarters 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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

the following table contains the demand from the last 1 2 quarters: quarter sales: 6 0 0 , 1 5 5 0 , 1 8 0 0 , 2 1 0 0 , 2 4 0 0 , 3 1 0 0 , 2 6 0 0 , 2 9 0 5 , 3 8 0 0 , 4 5 0 0 , 4 1 0 0 , 4 9 0 0...

The following table contains the demand from the last 12 months Quarter Sales 1 500 2 1550 3 1800 4 2100 5 2400 6 3100 7 2600 B 2905 9 3800 10 4500 11 4100 12 4900 a. Please create a spreadsheet and...

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 create a spreadsheet and...

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

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 1. Plot the actual and forecast...

he following table contains the demand from the last 1 2 quarters: Quarter Sales 1 6 0 0 2 1 5 5 0 3 1 8 0 0 4 2 1 0 0 5 2 4 0 0 6 3 1 0 0 7 2 6 0 0 8 2 9 0 5 9 3 8 0 0 1 0 4 5 0 0 1 1 4 1 0 0 1 2 4...

The following table contains the demand from the last 1 2 quarters: Quarter Sales 1 6 0 0 2 1 5 5 0 3 1 8 0 0 4 2 1 0 0 5 2 4 0 0 6 3 1 0 0 7 2 6 0 0 8 2 9 0 5 9 3 8 0 0 1 0 4 5 0 0 1 1 4 1 0 0 1 2 4...

please answer Question B and C The following table contains the demand from the last 12 months: b. Please write down the linear regression model. c. Based on the simple linear regression results....

Describe the audit implications of the Check Clearing for the 21st Century Act.

A lobstermans buoy is a solid wooden cylinder of radius r and mass M. It is weighted at one end so that it floats upright in calm sea water, having density 6. A passing shark tugs on the slack rope...

What is one of the five criteria for selecting an investment option? Multiple Choice balance liquidity ease of transfer asset allocation

What is an example of constructive feedback? provide reference