Enter your Student ID
References
Use Excel to answer the following questions. Where written responses are necessary, p
A deep-foundation engineering contractor has bid on a foundation system for a new bu
auger cast piles. The contractor was given bid information for cost-estimating purposes
determined exactly until construction was performed.
The Pile Foundation data below contains the estimates and actual pile lengths after the
1. Construct a scatter chart and interpret it.
2. Develop a linear regression model to estimate the actual pile length as a function o
a. Interpret the R-squared value.
b. Use the model to estimate the actual length of a pile given the estimate
c. The pile with estimated length of 61.08 feet was actually 55.75 feet. Ba
Pile Foundation Data
Pile
Number
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
Pile Length (ft.) Pile Length (ft.)
Estimated
Actual
10.58
18.58
10.58
18.58
10.58
18.58
10.58
18.58
10.58
28.58
10.58
26.58
10.58
17.58
10.58
27.58
10.58
27.58
10.58
37.58
10.58
28.58
5.83
1.83
5.83
8.83
5.83
8.83
5.83
8.83
10.83
16.83
10.83
19.83
10.83
18.33
10.83
14.83
21.33
12
16.33
27
21.33
42
21.33
46
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
21.33
31.33
41.08
41.08
41.08
46.33
61.33
61.33
61.33
61.33
61.33
61.33
61.33
61.33
61.33
11.33
5.83
5.83
5.83
5.83
15.83
15.83
15.83
15.83
11.33
21.08
21.08
21.08
21.08
21.08
41.08
41.08
41.08
41.08
41.08
61.08
61.08
61.08
61.08
61.33
61.33
11.33
20.08
20.08
46
57
55.75
55.75
55.75
57
77
76
75
75
36
56.42
45
45.42
37
8
2.83
2.83
2.83
2.83
14.83
16.83
16.83
16.83
11
42.75
43.17
43.17
42.75
42.75
31.75
31.75
31.75
36.75
44.75
36.75
55.75
40.17
56.75
26.42
66.00
13.33
38.75
38.75
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
20.08
20.08
20.08
20.05
40.08
40.08
40.08
40.08
40.08
40.08
60.08
60.08
60.08
60.08
61.33
8.42
20.58
20.58
20.55
20.58
20.58
20.55
23.50
20.52
20.52
20.52
20.52
20.52
20.52
38.42
35.83
35.83
35.83
35.83
35.83
34.75
34.75
4.75
19.75
34.75
34.75
4.75
17.25
17.25
38.75
38.75
38.75
38.75
54.75
25.75
25.75
54.75
23.75
73.08
57.75
56.75
57.75
58.17
62.00
9.09
16.25
16.25
16.25
16.25
16.25
16.25
29.17
21.19
20.19
20.19
36.19
26.19
22.19
29.51
26.51
27.09
34.51
37.09
31.51
55.42
28.84
14.42
22.42
42.42
55.42
14.42
21.92
21.92
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
17.25
17.25
17.25
17.25
19.75
28.42
28.42
28.42
28.42
28.42
28.42
35.92
40.53
40.83
40.83
40.83
40.83
53.42
50.83
50.83
50.83
50.83
53.42
53.42
5.58
5.58
5.58
6.58
5.58
5.58
20.58
20.58
20.55
20.58
20.58
20.58
28.75
28.75
28.75
28.75
28.75
28.75
39.25
39.25
21.92
21.92
21.92
21.92
22.42
32.09
32.09
32.09
32.09
32.09
32.09
46.59
55.51
56.51
67.09
57.09
67.09
55.09
50.34
50.34
45.34
47.76
41.51
41.09
19.25
19.25
19.25
19.25
19.25
19.25
28.25
28.25
28.25
28.25
28.25
28.25
32.42
32.42
32.42
32.42
32.42
32.42
56.92
60.92
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
39.25
39.25
39.25
49.75
49.75
49.75
49.75
53.42
13.42
6.97
6.97
6.97
8.42
21.67
21.67
21.67
28.42
31.67
31.67
31.67
38.42
41.67
41.67
41.67
53.42
13.42
13.42
10.83
10.83
10.83
10.83
10.83
15.42
15.42
15.42
15.42
9.42
9.42
9.42
9.42
9.42
10.58
10.58
10.55
59.92
59.34
57.92
47.42
48.42
48.42
48.42
45.09
22.09
26.64
26.64
26.64
22.09
29.34
29.34
29.34
37.09
34.34
35.34
29.34
59.09
61.34
60.34
61.34
49.09
11.59
14.09
26.50
24.50
33.92
32.92
16.09
18.51
28.09
29.09
29.09
14.09
14.09
14.09
14.09
14.09
23.25
23.25
23.25
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
10.58
10.58
10.55
20.55
20.55
20.58
20.55
20.58
20.55
30.58
30.55
30.58
30.58
30.58
30.55
40.83
40.83
40.83
40.83
40.83
50.83
50.83
50.83
50.83
63.42
53.42
22.58
22.58
20.83
20.83
20.83
20.83
22.68
20.83
20.83
20.83
20.83
24.83
24.83
24.83
24.83
10.83
10.83
10.83
23.25
23.25
26.25
29.25
31.25
30.25
31.25
31.25
32.25
31.25
32.25
31.25
32.25
31.25
29.25
61.50
61.50
58.50
57.92
57.50
51.50
51.50
49.50
48.50
49.09
52.09
23.25
21.25
22.50
22.50
27.50
25.92
37.25
22.92
26.92
21.50
22.50
33.50
33.50
31.50
32.50
14.50
17.50
14.50
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
10.83
11.67
11.67
11.67
11.67
20.83
20.83
20.83
20.83
25.83
25.83
25.83
25.83
30.83
30.83
30.83
30.83
40.83
40.83
40.83
40.53
50.83
50.83
50.83
50.83
53.42
53.42
53.42
22.58
22.58
22.58
20.83
20.83
20.83
25.42
26.67
26.67
26.67
23.42
11.67
11.67
11.67
13.42
11.67
14.50
17.50
17.50
17.50
17.50
26.50
31.50
28.50
26.50
34.50
34.50
34.50
34.50
29.92
30.92
31.50
34.50
66.50
69.50
68.50
66.50
53.34
54.34
61.76
51.34
52.09
52.09
52.09
38.25
43.25
50.25
29.50
29.50
38
31.69
27.34
32.34
26.76
10.51
18.34
18.34
18.34
8.09
22.34
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
11.67
11.67
13.42
21.67
21.67
21.67
28.42
26.67
26.67
26.67
28.42
31.67
31.67
31.67
38.42
41.67
41.67
41.67
53.42
51.67
51.67
51.67
53.42
53.42
21.34
21.34
16.09
29.34
30.34
30.34
31.09
24.34
35.34
35.34
37.09
37.34
37.34
39.76
63.09
67.34
67.34
67.34
64.09
51.34
50.76
46.34
50.09
49.09
onses are necessary, provide your written response below each individual question using RED font.
n system for a new building housing the world headquarters for a Fortune 500 company. A part of the pro
estimating purposes, which consisted of the estimated depth of each pile; however, actual drill footage o
l pile lengths after the project was completed.
e length as a function of the estimated pile lengths.
ile given the estimated length was 61.08 feet.
actually 55.75 feet. Based on the estimated length derived from the regression model, what is the residual
RED font.
ny. A part of the project consists of installing 311
actual drill footage of each pile could not be
what is the residual?
Use Excel to answer the following questions. Where written responses are necessary, p
The Golfing Statistics data below provides data for a portion of the 2010 professional se
1. Find the best multiple regression model for estimating Earnings/Event
in estimating Earnings/Event? Explain.
2. Find the best multiple regression model for predicting Average Score as a function
independent variables statistically significant in estimating Average Score? Explain.
*GIR: Greens in Regulation
Golfing Statistics
Earnings/Event
$239,493.68
$177,249.18
$218,619.18
$186,380.08
$209,511.75
$181,987.29
$162,536.13
$174,534.95
$135,353.70
$212,540.82
$297,079.50
$168,904.45
$135,791.58
$133,695.52
$112,192.04
$215,121.67
$183,922.93
$150,251.76
$183,356.69
$130,274.35
$286,285.40
$72,708.05
$99,597.31
$85,557.56
$46,406.25
Events
22
28
22
24
20
21
23
21
27
17
12
20
24
23
26
12
14
17
13
17
5
19
13
9
8
Avg. Score
70.37
69.43
70.23
70.46
69.78
70.34
69.92
70.25
70.64
69.93
70.26
69.96
70.21
70.53
70.59
70.22
70.86
70.94
71.13
71.53
69.73
70.79
71.07
71.10
71.24
GIR (%)*
67.9
69.4
67.1
68.0
68.3
65.1
66.3
65.3
68.0
68.7
69.3
66.0
68.5
68.2
66.5
66.5
62.9
66.2
66.9
62.5
69.4
61.9
64.1
64.1
61.1
written responses are necessary, provide your written response below each individual question using
ortion of the 2010 professional season for the top 25 golfers.
ating Earnings/Event as a function of the other variables. Upon completing the analysis, are all independe
cting Average Score as a function of GIR, putts/round, driving accuracy, and driving distance. Upon comple
ating Average Score? Explain.
Driving Distance
288.4
286.9
276.0
308.5
282.9
299.1
287.8
277.0
291.8
294.2
298.7
291.4
309.8
289.1
279.7
292.4
287.2
300.0
291.7
286.8
308.4
292.1
295.8
290.4
289.9
Driving Accuracy (%)
60.2
67.9
71.0
56.4
68.5
52.7
65.2
62.4
67.9
61.3
61.3
64.8
55.7
64.8
71.2
60.1
52.0
62.6
67.1
62.7
70.6
56.7
57.2
69.3
65.5
Putts/Round
31.82
31.30
31.81
31.81
31.43
31.72
31.68
31.52
32.35
31.55
32.31
31.79
31.73
31.86
31.30
32.29
31.99
32.31
32.06
32.47
32.09
31.50
31.52
31.95
32.31
l question using RED font.
ysis, are all independent variables statistically significant
istance. Upon completing the analysis, are all
Use Excel to answer the following questions. Where written responses are necessary, p
A national homebuilder builds single-family homes and condominium-style townhouse
country for closings during one month.
1. Develop a multiple regression model for sales price as a function of lot cost and typ
2. Determine if an interaction exists between lot cost and type of home and find the
3. What is the estimated Selling Price for either a single-family home or a townhouse
House Sales
Region
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
South
Midwest
Midwest
Midwest
Midwest
Midwest
South
Midwest
Midwest
Midwest
South
South
Midwest
Midwest
Type
Selling Price Lot Cost
Townhouse
$85,145 $17,030
Townhouse
$112,740 $20,700
Townhouse
$115,350 $18,030
Townhouse
$116,415 $19,600
Townhouse
$133,070 $24,455
Single Family
$136,530 $25,500
Townhouse
$139,435 $29,155
Townhouse
$139,955 $30,400
Townhouse
$147,905 $24,650
Single Family
$153,845 $27,500
Townhouse
$155,270 $19,600
Townhouse
$155,870 $24,650
Single Family
$160,000 $29,500
Single Family
$165,220 $25,500
Single Family
$165,350 $25,000
Single Family
$168,354 $27,316
Single Family
$168,500 $33,000
Single Family
$170,000 $25,200
Townhouse
$172,749 $45,025
Single Family
$175,000 $28,000
Townhouse
$175,470 $28,600
Townhouse
$179,365 $32,200
Townhouse
$181,916 $45,025
Townhouse
$182,237 $45,025
Single Family
$183,370 $28,000
Single Family
$184,210 $28,000
Midwest
Midwest
Midwest
South
Midwest
Midwest
Midwest
South
South
South
South
South
Midwest
South
South
Midwest
South
South
South
South
South
Midwest
Midwest
South
Midwest
South
Midwest
South
South
Midwest
Midwest
South
South
South
South
Midwest
Midwest
Midwest
South
South
South
South
South
South
Single Family
Townhouse
Single Family
Single Family
Townhouse
Single Family
Single Family
Single Family
Townhouse
Townhouse
Single Family
Townhouse
Single Family
Single Family
Townhouse
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Townhouse
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Townhouse
Single Family
Single Family
Townhouse
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
$184,460
$184,873
$185,160
$186,000
$187,390
$188,603
$189,120
$191,028
$196,898
$198,202
$200,119
$200,423
$201,700
$202,000
$203,076
$203,950
$204,900
$205,821
$206,400
$207,345
$209,400
$210,380
$211,513
$211,797
$212,079
$214,205
$214,900
$216,049
$219,990
$220,257
$223,890
$224,108
$225,900
$226,000
$230,000
$230,440
$230,555
$233,900
$234,971
$239,000
$239,870
$241,195
$242,191
$242,899
$22,300
$33,400
$29,000
$35,851
$27,000
$31,300
$35,000
$45,000
$45,025
$45,025
$45,000
$45,025
$40,940
$31,160
$45,025
$33,000
$34,000
$39,299
$35,851
$35,600
$43,579
$33,856
$31,300
$34,000
$33,400
$36,500
$31,300
$35,600
$37,557
$31,300
$28,000
$45,025
$28,618
$35,600
$45,025
$33,000
$28,000
$44,200
$29,202
$39,169
$41,354
$41,340
$33,434
$48,252
South
Midwest
South
Midwest
South
South
South
South
South
South
South
South
Midwest
South
South
Midwest
South
South
South
South
Midwest
South
South
South
Midwest
Midwest
South
Midwest
South
South
Midwest
South
Midwest
South
South
Midwest
South
South
South
South
South
South
South
Midwest
Single Family
Single Family
Single Family
Single Family
Townhouse
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Townhouse
Single Family
Single Family
Single Family
Townhouse
Townhouse
Single Family
Townhouse
Single Family
Single Family
Single Family
Townhouse
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Townhouse
Single Family
Single Family
Single Family
Single Family
Single Family
$246,648
$248,500
$249,900
$250,005
$250,800
$252,135
$253,055
$254,048
$255,000
$256,235
$257,040
$260,100
$262,740
$262,890
$265,058
$265,500
$267,060
$267,250
$267,640
$268,000
$268,210
$268,500
$269,410
$270,518
$271,105
$274,455
$274,903
$277,720
$280,622
$280,804
$281,487
$281,824
$283,440
$286,758
$287,771
$289,000
$290,000
$290,190
$294,450
$294,990
$299,096
$301,500
$305,000
$307,373
$41,600
$20,000
$38,200
$33,000
$73,400
$41,341
$41,340
$39,680
$43,198
$48,500
$37,631
$73,400
$44,900
$48,500
$41,404
$35,800
$73,400
$45,676
$73,400
$43,344
$29,700
$41,099
$73,400
$46,499
$45,000
$41,000
$45,345
$44,650
$45,130
$40,667
$57,285
$50,448
$50,900
$57,000
$46,300
$44,000
$48,300
$82,250
$73,400
$57,000
$43,784
$59,000
$49,067
$41,292
South
South
South
South
South
South
South
South
South
South
Midwest
South
South
South
South
Midwest
South
South
South
South
South
South
South
South
South
Midwest
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Townhouse
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
$307,387
$307,663
$309,075
$310,100
$310,372
$312,898
$318,274
$318,523
$319,602
$322,920
$323,716
$324,266
$324,412
$326,570
$329,611
$330,486
$330,710
$333,158
$335,000
$337,374
$337,380
$338,065
$340,000
$340,730
$342,423
$348,744
$350,702
$352,781
$354,065
$354,117
$355,688
$358,162
$359,949
$366,990
$367,600
$369,101
$371,152
$379,000
$379,424
$379,575
$385,000
$385,942
$387,527
$398,651
$45,850
$44,840
$82,250
$41,800
$60,000
$40,768
$85,800
$50,000
$82,250
$82,250
$34,500
$47,891
$62,523
$51,000
$48,611
$35,000
$49,920
$49,123
$68,375
$70,399
$49,150
$54,850
$40,000
$50,850
$48,309
$53,000
$46,386
$60,000
$48,115
$56,219
$65,373
$44,470
$50,591
$55,508
$50,000
$46,773
$58,223
$72,915
$64,902
$44,294
$75,000
$49,123
$48,000
$65,429
South
South
South
Midwest
South
South
South
South
South
South
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
Single Family
$400,330
$404,510
$407,076
$410,810
$417,790
$432,426
$444,304
$446,507
$492,820
$575,120
$75,510
$58,225
$48,668
$66,500
$63,099
$57,422
$53,938
$75,510
$84,122
$79,790
responses are necessary, provide your written response below each individual question using RED
ominium-style townhouses. The House Sales data below provides information on the selling price, lot cost
function of lot cost and type of home without any interaction term.
type of home and find the best model.
mily home or a townhouse with a lot cost of $30,000?
on using RED font.
selling price, lot cost, type of home, and region of the
Purchase answer to see full
attachment