In: Statistics and Probability
Admin | Experience | Complexity | Performance |
---|---|---|---|
1 | 26 | 1 | 45 |
2 | 32 | 3 | 78 |
3 | 8 | 3 | 120 |
4 | 60 | 2 | 68 |
5 | 72 | 5 | 140 |
6 | 20 | 5 | 135 |
Question 1. What is the predicted performance time(rounding to the nearest 10th decimal) for administrator 1?
Question 2. What is the predicted performance time(rounding to the nearest 10th decimal) for administrator 2?
Question 3. What is the predicted performance time(rounding to the nearest 10th decimal) for administrator 3?
Question 4. What is the predicted performance time(rounding to the nearest 10th decimal) for administrator 4?
Question 5. What is the predicted performance time(rounding to the nearest 10th decimal) for administrator 5?
Question 6. What is the predicted performance time(rounding to the nearest 10th decimal) for administrator 6?
SUMMARY OUTPUT | ||||||||
Regression Statistics | ||||||||
Multiple R | 0.946311411 | |||||||
R Square | 0.895505286 | |||||||
Adjusted R Square | 0.738763215 | |||||||
Standard Error | 20.09050147 | |||||||
Observations | 6 | |||||||
ANOVA | ||||||||
df | SS | MS | F | Significance F | ||||
Regression | 3 | 6918.076835 | 2306.025612 | 5.71324137 | 0.15257313 | |||
Residual | 2 | 807.2564985 | 403.6282493 | |||||
Total | 5 | 7725.333333 | ||||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
Intercept | 30.70050067 | 22.08190995 | 1.390300963 | 0.298947824 | -64.31028944 | 125.7112908 | -64.3102894 | 125.7112908 |
Admin | 2.67257088 | 9.098576289 | 0.293735063 | 0.796638159 | -36.47544322 | 41.82058498 | -36.4754432 | 41.82058498 |
Experience | -0.245972085 | 0.387988685 | -0.63396716 | 0.590939069 | -1.91535266 | 1.423408491 | -1.91535266 | 1.423408491 |
Complexity | 21.01552221 | 10.27636907 | 2.045033813 | 0.1775107 | -23.2001252 | 65.23116962 | -23.2001252 | 65.23116962 |
performance time = 30.70050067 + 2.67257088 Admin - 0.245972085 Experience + 21.01552221 Complexity
the predicted performance time(rounding to the nearest 10th decimal) for administrator 1
performance time = 30.70050067 + 2.67257088 Admin - 0.245972085 Experience + 21.01552221 Complexity
= 30.70050067 + 2.67257088 * 1 - 0.245972085 * 26 + 21.01552221 * 1
= 47.9933195500
the predicted performance time(rounding to the nearest 10th decimal) for administrator 2
performance time = 30.70050067 + 2.67257088 * 2 - 0.245972085 * 32 + 21.01552221 *3
= 91.2211023400
the predicted performance time(rounding to the nearest 10th decimal) for administrator 3
performance time = 30.70050067 + 2.67257088 * 3 - 0.245972085 * 8 + 21.01552221 *3
= 99.7970032600
the predicted performance time(rounding to the nearest 10th decimal) for administrator 4
performance time = 30.70050067 + 2.67257088 * 4 - 0.245972085 * 60 + 21.01552221 *2
= 68.6635035100
the predicted performance time(rounding to the nearest 10th decimal) for administrator 5
performance time = 30.70050067 + 2.67257088 * 5 - 0.245972085 * 72 + 21.01552221 *5
= 131.4309760000
the predicted performance time(rounding to the nearest 10th decimal) for administrator 6
performance time = 30.70050067 + 2.67257088 * 6 - 0.245972085 * 20 + 21.01552221 *5
= 146.8940953000