Profit RD Example

Sheet1

Run # 1 Profit vs R & D
Time R&D Profit SUMMARY OUTPUT
1 2 20
2 3 25 Regression Statistics
3 5 34 Multiple R 0.9090909091
4 4 30 R Square 0.826446281
5 11 40 Adjusted R Square 0.7830578512 Ycap = 20 + 2 (R&D)
6 5 31 Standard Error 3.2403703492
Observations 6
ANOVA critical F 7.7086474222 21.1976895844
df SS MS F p value
Regression 1 200 200 19.0476190476 0.0120210368
Residual 4 42 10.5
Total 5 242
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 20 2.6457513111 7.5592894602 0.0016412894 12.6542167228 27.3457832772 12.6542167228 27.3457832772
R&D 2 0.4582575695 4.3643578047 0.0120210368 0.7276730143 3.2723269857 0.7276730143 3.2723269857
critical T 2.7764451052
Run # 2 Profit vs Time
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.7375891678
R Square 0.5440377804
Adjusted R Square 0.4300472255
Standard Error 5.252210419
Observations 6
ANOVA
df SS MS F Significance F
Regression 1 131.6571428571 131.6571428571 4.7726566546 0.0942544352
Residual 4 110.3428571429 27.5857142857
Total 5 242
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 20.4 4.8895418034 4.1721700765 0.0140065996 6.8244555932 33.9755444068 6.8244555932 33.9755444068
Time 2.7428571429 1.255518431 2.1846410814 0.0942544352 -0.7430208594 6.2287351451 -0.7430208594 6.2287351451
RESIDUAL OUTPUT
Observation Predicted Profit Residuals
1 23.1428571429 -3.1428571429
2 25.8857142857 -0.8857142857
3 28.6285714286 5.3714285714
4 31.3714285714 -1.3714285714
5 34.1142857143 5.8857142857
6 36.8571428571 -5.8571428571
Run # 3 Profit vs Time and R& D
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.9309366705
R Square 0.8666430845
Adjusted R Square 0.7777384742
Standard Error 3.279856376
Observations 6
ANOVA 9.5520944959
df SS MS F Significance F
Regression 2 209.7276264591 104.8638132296 9.7480106101 0.0486993666
Residual 3 32.2723735409 10.757457847
Total 5 242
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 18.4435797665 3.138556766 5.8764525041 0.0098311971 8.4552913828 28.4318681503 8.4552913828 28.4318681503
Time 0.9727626459 1.0229590978 0.9509301476 0.4117941742 -2.2827497555 4.2282750473 -2.2827497555 4.2282750473
R&D 1.6303501946 0.6051907638 2.693944277 0.0741656224 -0.2956369156 3.5563373047 -0.2956369156 3.5563373047
3.1824463053
RESIDUAL OUTPUT
Observation Predicted Profit Residuals
1 22.6770428016 -2.6770428016
2 25.280155642 -0.280155642
3 29.513618677 4.486381323
4 28.8560311284 1.1439688716
5 41.2412451362 -1.2412451362
6 32.4319066148 -1.4319066148


You Need a Professional Writer To Work On Your Paper?