Scribd
Upload
73 views6 pages

Regression

The document describes a linear regression model predicting demand (Yt) from time (t). The regression has an R-squared of 0.978, indicating a strong fit. The regression equation is Yt = 1.685714x + 24.266667. Residual analysis shows the predictions closely match the actual values with small residuals.

Uploaded by

UtkristSrivastava
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
73 views6 pages

Regression

The document describes a linear regression model predicting demand (Yt) from time (t). The regression has an R-squared of 0.978, indicating a strong fit. The regression equation is Yt = 1.685714x + 24.266667. Residual analysis shows the predictions closely match the actual values with small residuals.

Uploaded by

UtkristSrivastava
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Year Demand t Yt

2013 25 1 26
2014 32 2 28
2015 24 3 29
2016 28 4 31
2017 26 5 32
2018 27 6 35
2019
Chart Title
40

35
f(x) = 1.6857142857x + 24.2666666667
30

25

20

15

10

5
SUMMARY OUTPUT
0
0 1 2 3 4 5 6 7
Regression Statistics
Multiple R 0.989074
R Square 0.978267
Adjusted R 0.972834
Standard E 0.525538
Observatio 6

ANOVA
df SS MS F Significance F
Regression 1 49.72857 49.72857 180.0517 0.000178
Residual 4 1.104762 0.27619
Total 5 50.83333

Coefficients
Standard Error t Stat P-value Lower 95%
Intercept 24.26667 0.48925 49.59978 9.89E-07 22.90829
X Variable 1.685714 0.125628 13.41834 0.000178 1.336916

RESIDUAL OUTPUT

ObservationPredicted Y Residuals
Standard Residuals
1 25.95238 0.047619 0.101305
2 27.6381 0.361905 0.769919
3 29.32381 -0.32381 -0.68887
4 31.00952 -0.00952 -0.02026
5 32.69524 -0.69524 -1.47905
6 34.38095 0.619048 1.316966
6 7
X Variable 1 Line Fit Plot
40
30
20 Y
Predicted Y
Y

10
0
0 1 2 3 4 5 6 7
X Variable 1
Significance F

Upper 95%
Lower 95.0%
Upper 95.0%
25.62504 22.90829 25.62504
2.034513 1.336916 2.034513
40

t Yt 35
f(x) = 1.685714285
1 26 30
2 28
25
3 29
4 31 20
5 32 15
6 35
10

0
0 1 2

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.989074
R Square 0.978267
Adjusted R 0.972834
Standard E 0.525538
Observatio 6

ANOVA
df SS MS F Significance F
Regression 1 49.72857 49.72857 180.0517 0.000178
Residual 4 1.104762 0.27619
Total 5 50.83333

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%
Lower 95.0%
Intercept 24.26667 0.48925 49.59978 9.89E-07 22.90829 25.62504 22.90829
X Variable 1.685714 0.125628 13.41834 0.000178 1.336916 2.034513 1.336916

RESIDUAL OUTPUT

ObservationPredicted Y Residuals
Standard Residuals
1 25.95238 0.047619 0.101305
2 27.6381 0.361905 0.769919
3 29.32381 -0.32381 -0.68887
4 31.00952 -0.00952 -0.02026
5 32.69524 -0.69524 -1.47905
6 34.38095 0.619048 1.316966
Yt
40

35
f(x) = 1.6857142857x + 24.2666666667
30

25

20

15

10

0
0 1 2 3 4 5 6 7

X Variable 1 Line Fit Plot


40
30
20 Y
Predicted Y
Y

10
0
0 1 2 3 4 5 6 7
X Variable 1

Upper 95.0%
25.62504
2.034513

You might also like