3 2 6

4 1 4
5 3 15
12 6 25 4.166667

MEAN MEDIAN MODE Q1 Q2 Q3

2 2 2 2 2 2 2
110 3 3 3 3 3 3
5 5 5 5 5 5 5
6 6 6 6 6 6 6
7 7 7 7 7 7 7
7 7 7 7 7 7 7
3 110 110 110 110 110 110
20 6 7 3 6 7
-18 324 1 -3 9 11 -3 9
-17 289 2 -2 4 12 -2 4
-15 225 5 1 1 15 1 1
-14 196 6 2 4 16 2 4
-13 169 6 2 4 16 2 4
-13 169 20 22 70 22
90 8100 4 5.5 14 5.5
9472
1578.667 4.4
5.5
2.345208

1983 26.3 0.08 0.0064

1984 26.2 -0.02 0.0004
1985 26.4 0.18 0.0324
1986 26.3 0.08 0.0064
1987 25.9 -0.32 0.1024
26.22

0.037
0.192354
 3 -9 81
6 -6 36
15 3 9
18 6 36
18 6 36
60 198
12 49.5
 Y X X-Xavg Sq X-Xavg * Y - Yavg
5.2 36.2 36.2 5.2 0.006944444 0.7486111111
4.4 28.8 28.8 4.4 0.513611111 -1.1347222222
3 22.6 22.6 3 4.480277778 9.7719444444
1.2 8.8 8.8 1.2 15.34027778 72.1319444444
7.5 41.5 41.5 7.5 5.680277778 34.0419444444
9.4 25.4 25.4 9.4 18.34694444 -7.7813888889

Mean 27.21667 5.116667 44.36833333 107.7783333333

Slope b1 2.429172458

Intercept b0 14.78740092

X 40 Change this value

Y 111.9543 Regresssion equation
45

40

35

30

25
Y

20

15

10

0
0 1 2 3 4 5 6 7 8 9 10
X
 Predicted Y Residual/Error E Sq Prd Y - Yavg
27.4190977 -8.7809022952 77.10424512 0.2024310382 0.040978
25.47575974 -3.3242402614 11.05057332 -1.740906928 3.030757
22.0749183 -0.5250817024 0.275710794 -5.141748369 26.43758
17.70240787 8.9024078735 79.25286595 -9.514258793 90.52112
33.00619436 -8.4938056422 72.14473429 5.7895276912 33.51863
37.62162203 12.2216220277 149.368045 10.404955361 108.2631

SSE 389.1961744 SSR 261.8122

SST = SSE + SSR 651.0083333 651.0083333 OK

r sq = SSR/SST or 1 - SSE/SST

Cofficient of Determinationr sq 0.4022 0.4022

Correlation Cofficient r 0.6342

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.770207984
R Square 0.593220339
Adjusted R Square 0.491525424
Standard Error 1.732050808
Observations 6

ANOVA
df SS MS F Significance F
Regression 1 17.5 17.5 5.833333 0.07314
Residual 4 12 3
Total 5 29.5

Coefficients Standard Error t Stat P-value Lower 95%

Intercept 6 2.384473587 2.5162786593 0.065616 -0.62036
X 0.1 0.041403934 2.4152294577 0.07314 -0.014956
RESIDUAL OUTPUT

Observation Predicted Y Residuals Standard Residuals

1 9 -1 -0.645497224
2 10 1 0.6454972244
3 13 -1 -0.645497224
4 12 -2 -1.290994449
5 14 1 0.6454972244
6 11 2 1.2909944487
 Y-Yavg X Y
8.983333 80.70028 5.2 36.2
1.583333 2.506944 4.4 28.8
-4.616667 21.31361 3 22.6
-18.41667 339.1736 1.2 8.8
14.28333 204.0136 7.5 41.5
-1.816667 3.300278 9.4 25.4

SST 651.0083

X Line Fit Plot

50
40
30 Y
20 Predicted Y
Y

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

Upper 95%Lower 95.0%

Upper 95.0%
12.62036 -0.62036 12.62036
0.214956 -0.014956 0.214956
Sales Y Advt X
11 5 0 0 2 0
6 3 -2 4 -3 6
10 7 2 4 1 2
6 2 -3 9 -3 9
12 8 3 9 3 9
9 5 26 26

Advt X Sales Y 14

5 11 12
3 6
7 10 10
2 6
8
8 12
Sales

0
1 2 3 4 5 6 7 8 9
Advt

Advt X Sales Y Est Y Err Err^2

5 11 9 -2 4 2 4
3 6 7 1 1 -3 9
7 10 11 1 1 1 1
2 6 6 0 0 -3 9
8 12 12 0 0 3 9
9 SSE 6 SST 32

rsq 0.1875
 SUMMARY OUTPUT

Regression Statistics
Multiple R 0.9013878189
R Square 0.8125
Adjusted R Square 0.75
Standard Error 1.4142135624
Observations 5

ANOVA
df SS
Regression 1 26
Residual 3 6
Total 4 32

Coefficients Standard Error

Intercept 4 1.524164336
Advt X 1 0.2773500981

7 8 9
RESIDUAL OUTPUT

Observation Predicted Sales Y Residuals

1 9 2
2 7 -1
3 11 -1
4 6 -8.8817842E-16
5 12 0
 Advt X
15
10

Sales Y
5
0
1 2 3 4 5
Advt
MS F Significance F
26 13 0.0366183833
2

t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
2.6243889229 0.078704 -0.8505711597 8.85057116 -0.85057116 8.8505711597
3.6055512755 0.036618 0.117348205 1.882651795 0.117348205 1.882651795

Standard Residuals
1.6329931619
-0.8164965809
-0.8164965809
-7.251946429389E-16
0
 Advt X Line Fit Plot
15
10
Sales Y
Sales Y

5 Predicted Sales Y

0
1 2 3 4 5 6 7 8 9
Advt X