Given the following data set: with x as product produced in one month in million

Question

Given the following data set: with x as product produced in one month in millions of pounds and y1 as water usage in one month in million pounds, and y2 as payroll for one month is hundred thousand dollars

X: 1.61, 3.17, 3.65, 4.26, 3.38, 6.19. 7.39, 8.66, 9.37, 9.44, 11.3, 11.18, 12.03, 13.14, 15.9, 15.67

And Y1: 7.4, 8.73, 11.51, 11.48, 10.72, 13.7, 20.75, 21.03, 23.43, 22.78, 24.98, 27.12, 29.79, 29.59, 36.47, 36.48

And Y2: 3.77, 13.48, 12, 15.54, 13.81, 18.93, 25.88, 28.1, 28.08, 31.16, 37.01, 30.75, 39.4, 42.54, 51.55, 48.91

estimate with 95% CI the monthly payroll for this plant if monthly production was 10million pounds

Explanation / Answer

Regression Analysis: Y2 versus X

The regression equation is
Y2 = 1.51 + 3.06 X

Predictor Coef SE Coef T P
Constant 1.510 1.109 1.36 0.195
X 3.0567 0.1157 26.41 0.000

S = 2.02764 R-Sq = 98.0% R-Sq(adj) = 97.9%

Analysis of Variance

Source DF SS MS F P
Regression 1 2868.5 2868.5 697.72 0.000
Residual Error 14 57.6 4.1
Total 15 2926.1

Unusual Observations

Obs X Y2 Fit SE Fit Residual St Resid
12 11.2 30.750 35.684 0.593 -4.934 -2.54R

R denotes an observation with a large standardized residual.

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.