need half work

profilehary-din22
hw_6.xlsx
Home>Reading homework help>need half work

Q1

Old Process
Elapsed Time
Week
1 31.7 SUMMARY OUTPUT
2 27
3 33.8 Regression Statistics
4 30 Multiple R 0.5745518821
5 32.5 R Square 0.3301098652
6 33.5 Adjusted R Square 0.2631208517
7 38.2 Standard Error 3.4883134897
8 37.5 Observations 12
9 29
10 31.3 ANOVA
11 38.6 df SS MS F Significance F
12 39.3 Regression 1 59.9633566434 59.9633566434 4.9278209667 0.0507057521
Residual 10 121.6833100233 12.1683310023
average 33.5333333333 Total 11 181.6466666667
standard deviation 4.0636600908
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 29.3242424242 2.1469085422 13.6588223705 0.0000000857 24.5406320896 34.1078527589 24.5406320896 34.1078527589
X Variable 1 0.6475524476 0.2917074284 2.2198695833 0.0507057521 -0.0024122071 1.2975171022 -0.0024122071 1.2975171022
New Process
Elapsed Time
Week
1 24 SUMMARY OUTPUT
2 25.8
3 31 Regression Statistics
4 23.5 Multiple R 0.1713144422
5 28.5 R Square 0.0293486381
6 25.6 Adjusted R Square -0.0677164981
7 28.7 Standard Error 2.5093057575
8 27.4 Observations 12
9 28.5
10 25.2 ANOVA
11 24.5 df SS MS F Significance F
12 23.5 Regression 1 1.9038461538 1.9038461538 0.3023602424 0.5944737741
Residual 10 62.9661538462 6.2966153846
average 26.35 Total 11 64.87
standard deviation 2.4284300952
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 27.1 1.5443709351 17.5475977854 0.0000000077 23.6589271177 30.5410728823 23.6589271177 30.5410728823
X Variable 1 -0.1153846154 0.209838689 -0.5498729329 0.5944737741 -0.5829343511 0.3521651203 -0.5829343511 0.3521651203

Q4

Old Process Old process y= 29.32 + 0.65X New Process
Elapsed Time New process y=27.1+ -0.12X Elapsed Time
Week Y^ Y-Y^=e Week Y^ Y-Y^=e
1 31.7 0.65 31.05 1 24 -0.12 24.12
2 27 1.3 25.7 2 25.8 -0.24 26.04
3 33.8 1.95 31.85 3 31 -0.36 31.36
4 30 2.6 27.4 4 23.5 -0.48 23.98
5 32.5 3.25 29.25 5 28.5 -0.6 29.1
6 33.5 3.9 29.6 6 25.6 -0.72 26.32
7 38.2 4.55 33.65 7 28.7 -0.84 29.54
8 37.5 5.2 32.3 8 27.4 -0.96 28.36
9 29 5.85 23.15 9 28.5 -1.08 29.58
10 31.3 6.5 24.8 10 25.2 -1.2 26.4
11 38.6 7.15 31.45 11 24.5 -1.32 25.82
12 39.3 7.8 31.5 12 23.5 -1.44 24.94
29.3083333333 27.13
0.65 -0.12