Given the following data set with x as product produced in o

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

Solution

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.