The law firm of Adams, Babcock, and Connors is located in the Dallas-Fort metroplex.? Randall Adams is the senior and founding partner of the firm.? John Babcock has been a partner in the firm for the past eight years, and Blake Connors became a partner just last year.? The firm employs two paralegal assistants and three secretaries.? In addition, you, the newly hired office manager, are in charge of day-to-day operations and manage the financial affairs of the law firm.?

A major aspect of the law firm?s business is the preparation of contracts and other legal documents for its clients.? A courier service is employed by the firm to deliver legal documents to its many clients as they are scattered throughout the metroplex.? The downtown centers of Dallas and Fort Worth are separated by a distance of approximately (30) miles.? With the large sizes of these cities and their associated heavy traffic, a trip by car from the southwest side of Fort Worth to the northeast side of Dallas can easily take longer than an hour which could impact courier costs.

In order to improve the firm?s planned expenditures, you have been asked to derive a regression model that would be best in predicting courier costs.? The information provided in the Excel file E281 Project 2 Data, includes cost (charge for the delivery), pickup time (time in minutes from when the order is phoned in until a courier agent arrives), delivery time (time in minutes that it takes for the documents to be delivered), and mileage (distance in miles from the law firm to the destination).? (Use ? = .05 for all tests)

(a).? Select only (1) of the (3) independent variables provided to use in your regression model.? Justify your selection by ONLY applying the p-value approach.

Based on the data, in the first regression test what would be the X and Y input ranges?

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
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
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

A
B
C
Pickup Time Delivery Time
Mileage
13
14
7
20
51
20
22
33
12
11
47
19
17
18
8
15
88
17
17
20
11
17
39
11
19
23
10
25
20
8
19
32
10
9
35
16
13
23
9
17
21
10
14
37
16
17
25
12
29
15
6
26
34
15
15
13
4
23
12
4
12
41
14
6
28
13
7
26
10
17
54
16
13
18
8
12
50
13
18
19
7
6
19
8
19
45
14
24
12
5
16
16
5
14
35
13
4
12
6
15
30
11
10
13
8
21
20
8
10
19
8
10
14
7
9
11
4
19
25
12
12
32
14
15
44
16
18
28
9
15
31
11
14
19
8
16
28
10
25
18
9
20
32
14
16
44
15
15
34
13
5
33
12
11
33
12
10
46
20
12
29
10
23
18
8
10
52
23
24
41
12
11
18
7
13
24
13
18
41
18
18
40
13
25
11
5
13
13
6
10
32
12
16
42
12
8
47
17
18
57
13
20
18
7
17
27
10
11
10
4
25
16
7
27
24
10
12
42
14
19
15
5
9
19
9
19
48
18
10
30
10
25
39
16
17
23
9
18
34
15
14
34
15
11
24
8
12
57
19
16
61
24
14
54
20
14
52
18
8
45
17
13
11
5
22
29
11
7
36
12
15
82
22
9
7
3
19
16
6

D
Cost
16.55
26.50
19.00
25.60
15.70
23.05
18.40
18.40
17.50
17.20
17.50
22.90
16.60
17.50
22.40
19.00
13.90
22.00
13.00
14.60
20.50
19.75
18.50
22.90
16.00
20.45
16.55
17.20
21.10
15.25
15.25
19.75
15.90
18.40
17.20
17.20
16.00
15.25
14.60
19.00
20.50
22.00
17.85
18.40
16.00
18.50
17.85
21.10
21.25
19.75
19.80
19.80
26.50
17.50
15.70
26.95
19.00
15.25
19.75
23.70
20.20
15.25
15.90
19.00
19.80
23.80
20.45
14.80
17.50
12.10
15.25
18.50
20.50
13.00
16.75
24.70
17.50
22.00
16.60
22.00
21.25
15.70
25.60
28.00
26.50
23.70
23.05
15.25
18.25
19.30
28.30
12.25
14.50

A
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
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
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

B
14
24
13
22
19
20
20
8
7
18
32
7
25
15
13
17
11
14
15
14
23
13
15
30
23
12
17
14
11
11
11
19
11
13
21
13
15
11
9
12
15
9
14
16
21
12
14
15
10
10
14
20
20
17
8
15
21
19
9
20
17
7
13
33
18
14
12
10
14
11
14
12
9
13
38
18
9
20
21
7
10
17
10
15
17
10
8
24
10

C
50
15
28
7
17
33
43
27
21
33
21
39
25
27
42
26
43
52
30
15
49
41
20
28
35
19
49
48
84
8
24
53
30
17
12
41
19
13
28
29
65
41
18
28
37
27
67
31
47
43
25
36
29
21
33
47
22
40
26
21
22
31
4
64
63
28
43
44
36
43
34
6
38
8
48
15
38
26
40
20
32
16
27
63
45
15
40
53
21

22
5
12
3
7
13
14
12
9
11
10
14
11
12
18
11
16
21
15
4
15
14
8
11
17
8
22
12
24
4
9
15
12
9
4
14
7
5
9
11
22
15
6
12
12
10
24
8
18
16
10
16
14
11
11
17
10
16
11
9
11
15
2
22
21
11
16
14
15
17
16
2
13
4
25
6
17
12
11
9
11
6
13
19
13
6
12
19
8

D
26.50
15.25
19.00
13.95
15.25
20.20
20.50
19.30
16.75
18.40
18.50
21.10
19.15
19.30
24.70
19.15
22.90
27.40
22.00
13.00
21.25
20.50
16.00
19.15
22.75
15.70
28.30
19.00
30.10
14.60
17.85
22.00
19.00
17.85
14.60
20.50
14.80
15.25
16.75
18.40
26.50
22.00
14.50
19.80
19.00
17.50
30.10
17.20
24.70
22.00
17.50
22.90
20.50
18.25
19.15
22.75
17.50
22.90
19.15
16.60
18.40
21.25
13.30
26.50
25.75
19.15
22.90
20.50
22.00
23.05
22.40
11.50
20.20
14.60
28.75
15.90
23.80
19.80
18.25
17.85
18.25
15.90
19.75
24.35
20.20
14.50
19.80
25.60
15.70