In: Statistics and Probability
A coffee company uses a? data-based approach to improving the quality and customer satisfaction of its products. When survey data indicated that the coffee company needed to improve its?package-sealing process, an experiment was conducted to determine the factors in the? bag-sealing equipment that might be affecting the ease of opening the bag without tearing the inner liner of the bag. One factor that could affect the rating of the ability of the bag to resist tears was the plate gap on the? bag-sealing equipment. Data were collected on 19 bags in which the plate gap was varied. Complete parts? (a) through? (e) below.
Total FT Jobs Added |
Total Worldwide Revenues? ($millions) |
FT Voluntary Turnover? (%) |
||||
415 |
8,843.900 |
4.504 |
||||
6,163 |
11,814.000 |
11.549 |
||||
?64 |
4,487.000 |
8.322 |
||||
36 |
551.000 |
12.383 |
||||
?973 |
7,998.700 |
8.329 |
||||
494 |
6,332.446 |
16.986 |
||||
?122 |
9,374.000 |
6.802 |
||||
1,160 |
3,651.328 |
6.168 |
||||
329 |
236.698 |
7.893 |
||||
5 |
888.000 |
10.837 |
||||
498 |
6,671.684 |
4.260 |
||||
60 |
9,502.000 |
4.908 |
||||
4,040 |
1,396.000 |
13.136 |
||||
224 |
2,870.000 |
1.771 |
||||
373 |
8,657.000 |
9.030 |
||||
1,264 |
12,316.379 |
20.038 |
||||
569 |
1,309.239 |
6.996 |
||||
95 |
706.757 |
10.535 |
||||
-111 |
23,420.000 |
14.355 |
||||
263 |
332.268 |
1.950 |
a. State the multiple regression equation.
Let X1 represent the Total Worldwide Revenues? ($millions) and let X2 represent the FT Voluntary Turnover? (%).
^Yi=_______+(______) X1i+(________) X2i
?(Round the constant and X2i?-coefficient to the nearest integer as needed. Round the iX1i?-coefficient to four decimal places as? needed.)
The statistical software output for this problem is:
Multiple linear regression results:
Dependent Variable: Total FT Jobs Added
Independent Variable(s): Total Worldwide Revenues? ($millions), FT
Voluntary Turnover? (%)
Total FT Jobs Added = 200.51023 + 0.0079350191 Total Worldwide
Revenues? ($millions) + 74.245875 FT Voluntary Turnover? (%)
Parameter estimates:
Parameter | Estimate | Std. Err. | Alternative | DF | T-Stat | P-value |
---|---|---|---|---|---|---|
Intercept | 200.51023 | 884.00825 | ? 0 | 14 | 0.22681941 | 0.8238 |
Total Worldwide Revenues? ($millions) | 0.0079350191 | 0.074077867 | ? 0 | 14 | 0.10711727 | 0.9162 |
FT Voluntary Turnover? (%) | 74.245875 | 88.548993 | ? 0 | 14 | 0.83847228 | 0.4159 |
Analysis of variance table for multiple regression
model:
Source | DF | SS | MS | F-stat | P-value |
---|---|---|---|---|---|
Model | 2 | 2614542.5 | 1307271.2 | 0.44437211 | 0.65 |
Error | 14 | 41185746 | 2941839 | ||
Total | 16 | 43800289 |
Summary of fit:
Root MSE: 1715.179
R-squared: 0.0597
R-squared (adjusted): -0.0746
Hence,
The regression equation will be:
= 201 + 0.0079 x1 + 74 x2