Column 1 Column 2 Column 3
Column 1 1.00
Column 2 -0.73 1.00
Column 3 -0.88 0.91 1.00
min
average
mode
median
count
skew
slope
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.9089
R Square 0.8262
Adjusted R Square 0.7682
Standard Error 9.9632
Observations 5.0000
1415/99.27
ANOVA mean sum of squareration of 2 variances
df SS MS F Significance F
Regression 1 1415.40 ### 14.2587 0.0325
Residual 3 297.80 ###
Total 4 1713.20
Coefficients Standard Error t Stat P-value Lower 95%
Intercept 9.23 12.52 0.74 0.51 -30.60
X Variable 1 10.52 2.78 3.78 0.03 1.65
Upper 95% Lower 95.0% Upper 95.0%
49.07 -30.60 49.07
19.38 1.65 19.38
Week No. of cars sold No. of sales rep Slope 10.51563
1 79 6 Intercept 9.234375
2 64 6 min 23
3 49 4 max 79
4 23 2 count 5
5 52 3 sum 267
Week No. of cars sold No. of sales rep
Mean 3.00 53.40 4.20
Standard Error 0.71 9.26 0.80
Median 3.00 52.00 4.00
Mode #N/A #N/A 6.00
Standard Deviation 1.58 20.70 1.79
Sample Variance 2.50 428.30 3.20
Kurtosis (1.20) 0.84 (2.32)
Skewness - (0.48) (0.05)
Range 4.00 56.00 4.00
Minimum 1.00 23.00 2.00
Maximum 5.00 79.00 6.00
Sum 15.00 267.00 21.00
Count 5.00 5.00 5.00
Confidence Level(95.0%) 1.9632431615 25.696745673016 2.2211560841582
Week No. of cars sold No. of sales rep
Week 1.00
No. of cars sold (0.73) 1.00
No. of sales rep (0.88) 0.91 1.00
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.91 regression
R Square 0.83 trying to explain varience of y
Adjusted R Square 0.77
Standard Error 9.96 Error SD of residuals
Observations 5.00 n
If F is large, it will go in the rejection region
ANOVA n-1 sum of square 2 variences Ratio of 2 variences
df SS MS F Significance F
Regression 1 1,415.40 1,415.40 14.26 0.03
Residual 3 297.80 99.27
Total 4 1,713.20
Coefficients Standard Error t Stat P-value Lower 95%
Intercept 9.23 12.52 0.74 0.51 (30.60)
X Variable 1 10.52 2.78 3.78 0.03 1.65
beta-coffecients
o in the rejection region
p-value for overall model fit
Upper 95% Lower 95.0% Upper 95.0%
49.07 (30.60) 49.07
19.38 1.65 19.38
Gold Copper Silver Aluminium Predicted Gold Residuals
161.1 64.2 4.4 39.8 176.4 15.35
308.0 93.3 11.1 61 379.4 71.36
613.0 101.3 20.6 71.6 595.9 (17.15)
460.0 84.2 10.5 76 420.6 (39.45)
376.0 72.8 8 76 372.8 (3.19)
424.0 76.5 11.4 77.8 443.3 19.29
361.0 66.8 8.1 81 392.0 30.96 N
318.0 67 6.1 81 354.4 36.42
368.0 66.1 5.5 81 343.1 (24.91) k=3 indepe
448.0 82.5 7 72.3 341.6 (106.39)
438.0 120.5 6.5 110.1 468.7 30.69 k
382.6 130.9 5.5 87.8 371.7 (10.91) n-k-1
N-1
predicted-original
G=-51.57+.07C+18.78S+3.54A
y=b0+b1x1+b2x2+b3x3
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.91
R Square 0.82
Adjusted R Square 0.75 p-546
Standard Error 53.44
Observations 12
ANOVA
df SS MS F Significance F
Regression 3 104,445.06 34,815.02 12.19 0.00
Residual 8 22,845.47 2,855.68
Total 11 127,290.53
Coefficients Standard Error t Stat P-value Lower 95%
Intercept (51.57) 87.82 (0.59) 0.57 (254.10)
Copper 0.07 0.88 0.08 0.94 (1.95)
Silver 18.78 3.80 4.94 0.00 10.01
Aluminium 3.54 1.17 3.03 0.02 0.84
RESIDUAL OUTPUT
Observation Predicted Y Residuals
1.00 176.35 (15.25)
2.00 379.23 (71.23)
3.00 595.73 17.27
4.00 420.39 39.61
5.00 372.64 3.36
6.00 443.13 (19.13)
7.00 391.79 (30.79)
8.00 354.23 (36.23)
9.00 342.90 25.10
10.00 341.44 106.56
11.00 468.42 (30.42)
12.00 371.47 11.13
Upper 95% Lower 95.0% Upper 95.0%
150.95 (254.10) 150.95
2.09 (1.95) 2.09
27.56 10.01 27.56
6.23 0.84 6.23
Gold Copper Silver Aluminium
Mean 388.14 85.51 8.73 76.28
Standard Error 31.05 6.38 1.27 4.73
Median 379.30 79.50 7.50 76.90
Mode #N/A #N/A 5.50 81.00
Standard Deviation 107.57 22.10 4.39 16.37
Sample Variance 11,571.87 488.33 19.29 267.98
Kurtosis 2.24 0.22 4.70 2.89
Skewness (0.04) 1.09 1.97 (0.29)
Range 451.90 66.70 16.20 70.30
Minimum 161.10 64.20 4.40 39.80
Maximum 613.00 130.90 20.60 110.10
Sum 4,657.70 1,026.10 104.70 915.40
Count 12 12 12 12
Confidence Level(95.0%) 68.35 14.04 2.79 10.40
Gold Copper Silver Aluminium
Gold 1.000
Copper 0.421 1.000
Silver 0.724 0.173 1.000
Aluminium 0.481 0.509 (0.084) 1.000
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.91
R Square 0.82
Adjusted R Square 0.75
Standard Error 53.44
Observations 12
ANOVA
df SS MS F Significance F
Regression 3 104,445.06 34,815.02 12.19 0.0024
Residual 8 22,845.47 2,855.68
Total 11 127,290.53
Coefficients Standard Error t Stat P-value Lower 95%
Intercept (51.57) 87.82 (0.59) 0.573 (254.10)
Copper 0.07 0.88 0.08 0.939 (1.95)
Silver 18.78 3.80 4.94 0.001 10.01
Aluminium 3.54 1.17 3.03 0.016 0.84
G=-51.57+.07C+18.78S+3.54A
Upper 95% Lower 95.0% Upper 95.0%
150.95 (254.10) 150.95
2.09 (1.95) 2.09
27.56 10.01 27.56
6.23 0.84 6.23
