2. We wish to analyze the monthly water usage of a production plant, Y (in gallons), with respect to its monthly production X₁ (in tons), mean monthly temperature X₂ (in °F) and the monthly number of days X3 of plant operation using the data given in the file 'WATER.xlsx'. The following models are considered: I: II: Y Y = Bo + B1X1 + B₂X2 + B3X3 + E, Bo + B1X1 + B₂X2 + B3X3 + B₁X1X2 + B5X1X3 + B6X2 X3 + ε Perform your tests at a = 10% in this question.

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
2. We wish to analyze the monthly water usage of a production plant, Y (in gallons), with
respect to its monthly production X₁ (in tons), mean monthly temperature X₂ (in °F)
and the monthly number of days X3 of plant operation using the data given in the file
'WATER.xlsx'. The following models are considered:
I:
II:
Y =
Y =
Bo + B₁X₁ + B₂X2 + ß3X3 + E,
Bo + B₁X₁ + B2X2 + B3X3 + B₁X1X2 + B5X₁X3 + B6X2X3 + ε
Perform your tests at a = 10% in this question.
(a) Generate a matrix scatter plot and state the relationship among these variables.
(b) Use R/Minitab to estimate the parameters of Model I, set up three hypotheses to test
whether each variable is useful given that the other variables are in the model.
(c) In Model II, the interaction terms among these three variables are considered. Using
the sum of squared residuals from the estimates of models I and II, do an F-test to
test the whether all these interaction terms are useful jointly in predicting the monthly
water usage of the production plant.
1
(d) Use backward selection to perform the model selection based on Model II as the full
model.
i. State your selected model. Is it a good model for the prediction of monthly water
usage of the production plant? Explain your answer.
ii. Use your model in 2(d)i to estimate the water usage of the plant during a month
when its production is 90.0 tons, the mean temperature is 65 °F, and it operates
for 20 days.
Transcribed Image Text:2. We wish to analyze the monthly water usage of a production plant, Y (in gallons), with respect to its monthly production X₁ (in tons), mean monthly temperature X₂ (in °F) and the monthly number of days X3 of plant operation using the data given in the file 'WATER.xlsx'. The following models are considered: I: II: Y = Y = Bo + B₁X₁ + B₂X2 + ß3X3 + E, Bo + B₁X₁ + B2X2 + B3X3 + B₁X1X2 + B5X₁X3 + B6X2X3 + ε Perform your tests at a = 10% in this question. (a) Generate a matrix scatter plot and state the relationship among these variables. (b) Use R/Minitab to estimate the parameters of Model I, set up three hypotheses to test whether each variable is useful given that the other variables are in the model. (c) In Model II, the interaction terms among these three variables are considered. Using the sum of squared residuals from the estimates of models I and II, do an F-test to test the whether all these interaction terms are useful jointly in predicting the monthly water usage of the production plant. 1 (d) Use backward selection to perform the model selection based on Model II as the full model. i. State your selected model. Is it a good model for the prediction of monthly water usage of the production plant? Explain your answer. ii. Use your model in 2(d)i to estimate the water usage of the plant during a month when its production is 90.0 tons, the mean temperature is 65 °F, and it operates for 20 days.
A
B
Water Production
2228
2609
3088
5
2378
6
1980
7
1717
8 2723
9 2031
10 1902
11 1721
123+
4
12
2254
13 2522
14
2609
15
2228
16
2559
17 2723
18 3088
19 2522
20 2012
21
2254
22 2436
23
246
24
2147
25
2378
26
2031
27
1717
28 2117
29 1902
30 2251
31 2357
32
1721
33
1980
98.5
108.2
109.6
101
83.3
70
144.7
84.4
97.4
131.8
82.1
64.5
108
97
113
144
109
64
91
82
126
111
85
101
84
70
107
97
98
96
132
84
D
Days
67.4
19
70.3
20
82.1
21
69.2
21
64.5 19
63.7 21
58 19
20
17
23
18
44.1 19
70
20
68
Temperature
58.1
36.6
49.6
44.3
66
58
82
44
61
44
59
62
1999903aa13
21
20
18
21
21
54
18
69
21
58
20
64
21
51 22
36
17
56 22
85 19
49 23
64 19
Transcribed Image Text:A B Water Production 2228 2609 3088 5 2378 6 1980 7 1717 8 2723 9 2031 10 1902 11 1721 123+ 4 12 2254 13 2522 14 2609 15 2228 16 2559 17 2723 18 3088 19 2522 20 2012 21 2254 22 2436 23 246 24 2147 25 2378 26 2031 27 1717 28 2117 29 1902 30 2251 31 2357 32 1721 33 1980 98.5 108.2 109.6 101 83.3 70 144.7 84.4 97.4 131.8 82.1 64.5 108 97 113 144 109 64 91 82 126 111 85 101 84 70 107 97 98 96 132 84 D Days 67.4 19 70.3 20 82.1 21 69.2 21 64.5 19 63.7 21 58 19 20 17 23 18 44.1 19 70 20 68 Temperature 58.1 36.6 49.6 44.3 66 58 82 44 61 44 59 62 1999903aa13 21 20 18 21 21 54 18 69 21 58 20 64 21 51 22 36 17 56 22 85 19 49 23 64 19
Expert Solution
steps

Step by step

Solved in 5 steps with 6 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman