Import the data from the Hill City Excel file into Minitab. You are trying to predict Price. Note: Mtn View=1 if there is a mountain view, 0 otherwise. The rest of the variables should be self explanatory. 1.Perform an F Test for overall significance of the model 2.Perform a T test for slope for the age variable 3. Find a 95% confidence interval for the slope of the SqFeet variable 4. Create a prediction, CI, and PI for 1 new set of x values (any valid numbers you want), and interpret each. 5. Run the residual plots and indicate if they show any problems with the model.
Import the data from the Hill City Excel file into Minitab. You are trying to predict Price. Note: Mtn View=1 if there is a mountain view, 0 otherwise. The rest of the variables should be self explanatory. 1.Perform an F Test for overall significance of the model 2.Perform a T test for slope for the age variable 3. Find a 95% confidence interval for the slope of the SqFeet variable 4. Create a prediction, CI, and PI for 1 new set of x values (any valid numbers you want), and interpret each. 5. Run the residual plots and indicate if they show any problems with the model.
Algebra: Structure And Method, Book 1
(REV)00th Edition
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Chapter7: Applying Fractions
Section7.5: Percents
Problem 23OE
Related questions
Question
Import the data from the Hill City Excel file into Minitab.
You are trying to predict Price.
Note: Mtn View=1 if there is a mountain view, 0 otherwise. The rest of the variables
should be self explanatory.
1.Perform an F Test for overall significance of the model
2.Perform a T test for slope for the age variable
3. Find a 95% confidence interval for the slope of the SqFeet variable
4. Create a prediction, CI, and PI for 1 new set of x values (any valid
numbers you want), and interpret each.
5. Run the residual plots and indicate if they show any problems with
the model.
Transcribed Image Text:A
B
E
F
G
1
Price
Bathrooms Garage spaceMtn View
SqFeet
1000
Age
Bedrooms
110000
28
3
1
1
3
133500
1400
23
3
1
1
1
4
112500
1248
58
3
4
1
1
5
141750
1106
12
1
1
1
6
195250
2112
78
2
6.
2
1
7
132250
1078
33
2
1
1
1
8
136000
952
13
2
2
9
162750
1100
1
1
1
10
148500
1040
17
3
1
2
1
11
123500
1416
27
4
2
1
1
12
142250
1150
25
3
2
13
145500
1220
17
3
2
1
14
155250
1464
28
3
2
2.
1
15
150750
1228
15
2
1
16
150900
1132
1
3
4
2
17
144000
1132
3
4
2
1
18
151900
1132
1
3
4
2
1
19
161500
2100
28
2
2
1
20
155750
1270
3
2
1
21
157250
1362
23
3
4
2
1
22
152900
1120
1
3
3
2
1
23
145250
1025
1
3
5
2
1
24
164750
1290
19
3
3
2
1
25
152500
1260
22
3
4
2
1
26
150750
1085
1
3
4
2
1
27
144750
1312
41
3
4
2
1
28
148250
1489
34
3
4
1
1
29
174500
1540
24
3
4
2
1
30
215500
2112
12
4
4
2
1
31
155750
1351
1
4
5
2
1
32
167900
1351
1.
4
4
2
1
33
148500
1193
5
3
4
2
1
34
152500
1200
1
4
4
2
1
35
167200
1256
1
3
4
2
1
36
159500
1058
1
3
4
2
1
37
153600
1210
13
3
4
2
1
38
168000
1380
1
4
2
1
39
166100
1301
7
4
2
1
40
165200
1375
8.
3
4
2
1
41
174900
1437
8.
3
4
2
1
42
160250
1330
1
3
4
2
1
43
165100
1361
1
3
4
1
44
170500
1594
16
3
3
2
1
45
155900
1186
2
3
4
2
1
46
167700
1336
1
3
4
2
47
165400
1325
5
3
4
1
48
163500
1352
3
4
2
1
49
178500
1354
7
3
2
1
50
164000
1318
1
3
4
2
1
Transcribed Image Text:51
172750
1415
3
1
52
149000
1337
2
3
4
2
53
176000
2028
25
4
4
2
54
205500
1820
21
3
4
2
55
216750
2182
1
4
4
3
1
56
181250
2600
37
5
3
1
57
229500
1930
1
3
4
3
58
207500
1834
2
3
4
3
59
206250
1933
3
4.
3
60
265400
2172
1
3
4
3
61
219250
2193
4
4
2
1
62
272100
2018
1
4
5
4
63
229600
2310
1
4
5
3
1
64
261000
2256
1
4
4
3
65
274600
2710
20
4
4
1
66
82200
1450
40
3
3
2
67
93300
1728
61
4
1
2.
68
111400
1976
37
4
4
1
69
90250
1608
7
3
1
1
70
72500
1532
41
3
2
2
71
70600
1288
5
3
4.
72
65950
1320
9
3
4
2
73
90100
1416
41
2
4
2
74
110200
2022
36
4
3
75
122500
1550
42
3
2
2
76
93900
1568
40
3
3
2
77
84800
1968
40
3
3
78
103600
1536
22
3
4
2
79
121000
1872
39
4
4
2.
80
102150
2200
31
4
1
81
129600
1763
29
3
4
2
82
82950
2073
71
3
2
83
111700
1563
52
3
1
3
84
127150
2080
28
5
2
85
139300
1968
47
3
3
2
86
111900
1340
9
3
4
3
87
96400
1730
12
3
4
2
88
106250
2168
2
4
1
89
126100
2320
22
4
4
1
90
121950
1750
8
3
4
91
150950
2000
39
3
4
2
92
142100
2073
44
3
2.
2
93
173200
2000
20
3
3
2
94
157850
1900
45
6.
3
95
164700
2400
38
4
4
2
96
130100
3000
43
4
5
97
123900
2172
1
5
6
3
98
180500
2515
51
2
4
2
99
169900
2500
49
4
6
3
100
213000
2345
44
5
4
4
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 1 images
Recommended textbooks for you
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell