Scribd
Upload
69 views4 pages

Plotting Residuals in Excel

This document contains the output of a linear regression analysis with one predictor variable (x1) performed on a dataset with 30 observations. The regression shows a very weak correlation (R=0.1377) between x1 and y. The residual output lists the predicted and residual values for each observation.

Uploaded by

Priyal Baid
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
69 views4 pages

Plotting Residuals in Excel

This document contains the output of a linear regression analysis with one predictor variable (x1) performed on a dataset with 30 observations. The regression shows a very weak correlation (R=0.1377) between x1 and y. The residual output lists the predicted and residual values for each observation.

Uploaded by

Priyal Baid
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

y x1 x2 SUMMARY OUTPUT

26 19 26
30 22 26 Regression Statistics
22 23 34 Multiple R 0.137715819
37 24 35 R Square 0.018965647
20 21 27 Adjusted R Square -0.01607129
16 23 25 Standard Error 6.222109941
25 23 25 Observations 30
22 25 29
31 18 32 ANOVA
22 20 31 df SS MS
23 21 26 Regression 1 20.9564074874 20.95641
39 20 28 Residual 28 1084.01025918 38.71465
26 25 34 Total 29 1104.96666667
17 19 26
24 19 29 Coefficients Standard Error t Stat
24 23 30 Intercept 36.08531317 12.4458996032 2.899374
24 22 29 x1 -0.41198704 0.5599674964 -0.73573
16 23 25
28 22 34
16 23 26
21 18 27 RESIDUAL OUTPUT
34 23 26
39 25 25 Observation Predicted y Residuals
28 23 32 1 25.78563715 1.214362851
39 24 27 2 26.60961123 2.3903887689
18 20 30 3 28.66954644 6.3304535637
31 23 35 4 27.43358531 -1.4335853132
40 23 33 5 28.66954644 -0.6695464363
39 25 28 6 26.60961123 12.3903887689
20 25 27 7 26.60961123 9.3903887689
8 27.02159827 -8.0215982721
9 27.43358531 -11.4335853132
10 28.2575594 -3.2575593952
11 27.84557235 1.1544276458
12 26.60961123 11.3903887689
13 26.60961123 -0.6096112311
14 27.43358531 12.5664146868
15 28.66954644 -9.6695464363
16 26.60961123 8.3903887689
17 26.60961123 -7.6096112311
18 27.84557235 6.1544276458
19 26.60961123 1.3903887689
20 25.78563715 -0.785637149
21 27.43358531 -2.4335853132
22 28.66954644 -1.6695464363
23 28.66954644 -11.6695464363
24 27.84557235 0.1544276458
25 27.43358531 -5.4335853132
26 28.66954644 -12.6695464363
27 28.2575594 -0.2575593952
28 27.84557235 -11.8455723542
29 26.60961123 -8.6096112311
30 27.84557235 2.1544276458
x1 Line Fit Plot
50
40
30
20

y
10
0
17 18 19 20 21 22 23 24 25 26
x1
F Significance F F=
0.541304 0.468011596

P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%


0.007194 10.59104354 61.5795828 10.591043542 61.5795828083
0.468012 -1.55902846 0.73505438 -1.55902846 0.7350543778
ne Fit Plot

y
Predicted y

21 22 23 24 25 26
x1

You might also like