REGRESSION ANALYSIS
n=3
Month Cost A Made B Made C Made
1 $ 44,439.00 515 541 928
2 $ 43,936.00 929 692 711
3 $ 44,464.00 800 710 824
4 $ 41,533.00 979 675 758
5 $ 46,343.00 1165 1147 635
6 $ 44,922.00 651 939 901
7 $ 43,203.00 847 755 580
8 $ 43,000.00 942 908 589
9 $ 40,967.00 630 738 682
10 $ 48,582.00 1113 1175 1050
11 $ 45,003.00 1086 1075 984
12 $ 44,303.00 843 640 828
13 $ 42,070.00 500 752 708
14 $ 44,353.00 813 989 804
15 $ 45,968.00 1190 823 904
16 $ 47,781.00 1200 1108 1120
17 $ 43,202.00 731 590 1065
18 $ 44,074.00 1089 607 1132
19 $ 44,610.00 786 513 839
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.803398743793
R Square 0.645449541529
Adjusted R Square 0.574539449834
Standard Error 1252.763897542
Observations 19
ANOVA
df SS MS F
Regression 3 42856229.886804 14285409.96227 9.1023650669
Residual 15 23541260.744775 1569417.382985
Total 18 66397490.631579
Coefficients Standard Error t Stat P-value
Intercept 35102.90044874 1837.2269111864 19.10645888921 6.111984279E-12
A Made 2.065953295996 1.6649817791893 1.2408263692843 0.233726820319
B Made 4.176355531102 1.6812525655229 2.484073848716 0.025287785452
C Made 4.790641037264 1.7893161070527 2.677358694968 0.017222642821
Significance F
0.001126532135
Lower 95% Upper 95% Lower 95,0% Upper 95,0%
31186.9439838 39018.85691368 31186.9439838 39018.856913679
-1.48287136062 5.614777952614 -1.482871360622 5.6147779526142
0.592850514347 7.759860547856 0.592850514347 7.7598605478565
0.976804034024 8.604478040504 0.976804034024 8.6044780405044
