Using the data in the Excel spreadsheet "auto.xlsx", estimate a regression to answer the following question.

How much does a 1 inch increase in LENGTH corresponds to a _________________ dollars increase in PRICE. Use negative values if it results in a decreased price. Round your answers to two decimals.
Transcribed Image Text:ZOOM + displaceme gear_ratio foreign 3.58 Domestic make price гep78 headroom trunk weight 2,930 3,350 2,640 3,250 length turn mpg 4,099 4,749 3,799 121 258 AMC Conc 22 3 3 11 186 40 AMC Pacei 17 3 3 11 173 40 2.53 Domestic AMC Spirit Buick Centi 22 3 12 168 35 121 3.08 Domestic 4,816 7,827 5,788 4,453 5,189 10,372 4,082 11,385 20 3 16 196 40 196 2.93 Domestic 350 231 2.41 Domestic 2.73 Domestic Buick Elect 15 4 4 20 4,080 3,670 2,230 3,280 3,880 3,400 4,330 3,900 4,290 2,110 3,690 222 43 Buick LeSa 18 3 4 21 218 43 Buick Opel Buick Rega Buick Rivie 26 3 10 170 34 304 2.87 Domestic 20 3 2 16 200 42 196 2.93 Domestic 16 4 17 207 43 231 2.93 Domestic Buick Skyla 19 3 4 13 200 42 231 3.08 Domestic Cad. Devill 14 4 20 221 44 425 2.28 Domestic 14,500 15,906 3,299 5,705 Cad. Eldor: Cad. Seville 14 2 4 16 204 43 350 2.19 Domestic 21 3 13 204 45 350 2.24 Domestic Chev. Chev 29 3 163 34 231 2.93 Domestic Chev. Impa Chev. Malit 16 4 20 212 43 250 2.56 Domestic 4,504 5,104 3,667 3,955 3,984 4,010 5,886 6,342 4,389 4,187 11,497 13,594 13,466 3,829 5,379 6,165 4,516 6,303 3,291 8,814 5,172 4,733 4,890 4,181 4,195 22 17 3,180 3,220 2,750 3,430 2,120 3,600 3,600 3,740 1,800 2,650 4,840 4,720 3,830 193 31 200 2.73 Domestic Chev. Mont 22 16 200 41 200 2.73 Domestic Chev. Mon: 24 2 2 7 179 40 151 2.73 Domestic Chev. Nova 19 3 4 13 197 43 250 2.56 Domestic Dodge Colt Dodge Dipl Dodge Maç Dodge St. F Ford Fiesta 30 2 8 163 35 98 3.54 Domestic 18 2 4 17 206 46 318 2.47 Domestic 206 220 16 2 4 17 46 318 2.47 Domestic 17 2 21 46 225 2.94 Domestic 28 4 9. 147 33 98 3.15 Domestic Ford Musta 21 2 10 179 43 140 3.08 Domestic Linc. Contir 12 3 4 22 233 51 400 2.47 Domestic Linc. Mark 12 3 18 230 48 400 2.47 Domestic Linc. Versa 14 3 4 15 201 41 302 2.47 Domestic Merc. Bobc 22 4 2,580 4,060 3,720 3,370 4,130 2,830 169 39 140 2.73 Domestic 2.75 Domestic Merc. Couç Merc. Marq 14 4 4 16 221 48 302 15 3 4 23 212 44 302 2.26 Domestic 18 2.43 Domestic 2.75 Domestic Merc. Mona 3 15 198 41 250 Merc. XR-7 14 4 16 217 45 302 Merc. Zeph 20 3 4 17 195 43 140 3.08 Domestic 4,060 3,310 3,300 3,690 3,370 2,730 Olds 98 21 4 20 220 43 350 2.41 Domestic Olds Cutl S 19 2 16 198 42 231 2.93 Domestic Olds Cutlas 19 16 198 42 231 2.93 Domestic Olds Delta 18 4 4 20 218 42 231 2.73 Domestic Olds Omeg 19 3 14 200 43 231 3.08 Domestic Olds Starfir 24 1 10 180 40 151 2.73 Domestic Olds Toron 10,371 4,647 4,425 4,482 6,486 4,060 5,798 4,934 5,222 4,723 4,424 4,172 9,690 6,295 9,735 6,229 4,589 5,079 8,129 4,296 5,799 4,499 3,995 16 3 17 4,030 3,260 1,800 206 43 350 2.41 Domestic Plym. Arrov Plym. Char Plym. Horiz Plym. Sapp Plym. Volai 28 3 11 170 37 156 3.05 Domestic 34 3 11 157 37 86 2.97 Domestic 2,200 2,520 3,330 3,700 3,470 3,210 3,200 3,420 2,690 2,830 2,070 2,650 2,370 25 3 4 17 165 36 105 3.37 Domestic 26 2 8 182 38 119 3.54 Domestic 225 231 18 2 16 201 44 3.23 Domestic Pont. Catal 18 4 4 20 214 42 2.73 Domestic Pont. Fireb 18 1 2 7 198 42 231 3.08 Domestic Pont. Gran 19 2.93 Domestic 2.93 Domestic 3 16 201 45 231 Pont. Le M: 19 4 17 199 40 231 Pont. Phoe 19 4 13 203 43 231 3.08 Domestic Pont. Sunb 24 7 179 41 151 2.73 Domestic 3.20 Foreign 3.70 Foreign Audi 5000 17 3 15 189 37 131 Audi Fox 23 3 3 11 174 36 97 3.64 Foreign 3.89 Foreign 3.70 Foreign 3.54 Foreign 3.55 Foreign 3.37 Foreign 3.05 Foreign 3.30 Foreign 3.73 Foreign 3.58 Foreign 3.72 Foreign 3.81 Foreign 3.06 Foreign 3.21 Foreign 3.05 Foreign 3.74 Foreign 3.78 Foreign 3.78 Foreign 3.78 Foreign 2.98 Foreign BMW 320i 25 3 12 177 34 121 Datsun 200 Datsun 210 23 4 6. 170 35 119 2,020 2,280 2,750 2,130 2,240 1,760 1,980 3,420 1,830 2,050 2,410 2,200 2,670 2,160 2,040 1,930 1,990 3,170 35 2 8 165 32 85 Datsun 510 24 4 3 8 170 34 119 Datsun 810 21 4 3 184 38 146 Fiat Strada 21 3 3 16 161 36 105 Honda Acc 25 3 10 172 36 107 Honda Civi 28 4 3 149 34 91 Mazda GLC 30 4 4 11 154 33 86 Peugeot 60 Renault Le 12,990 3,895 3,798 5,899 3,748 5,719 7,140 5,397 4,697 6,850 11,995 14 4 14 192 38 163 26 3 3 10 142 34 79 Subaru 35 11 164 36 97 Тоyota Celi Тoyota Cor Тоyota Cor VW Dashei 18 14 174 36 134 31 9. 165 35 97 18 11 175 36 134 23 4 12 172 36 97 VW Diesel VW Rabbit VW Scirocc 41 5 15 155 35 90 25 4 15 155 35 89 25 4 16 156 36 97 Volvo 260 17 3 14 193 37 163 -------

Question

Using the data in the Excel spreadsheet "auto.xlsx", estimate a regression to answer the following question.

How much does a 1 inch increase in LENGTH corresponds to a _________________ dollars increase in PRICE. Use negative values if it results in a decreased price. Round your answers to two decimals.

ZOOM
+
displaceme gear_ratio foreign
3.58 Domestic
make
price
гep78
headroom trunk
weight
2,930
3,350
2,640
3,250
length
turn
mpg
4,099
4,749
3,799
121
258
AMC Conc
22
3
3
11
186
40
AMC Pacei
17
3
3
11
173
40
2.53 Domestic
AMC Spirit
Buick Centi
22
3
12
168
35
121
3.08 Domestic
4,816
7,827
5,788
4,453
5,189
10,372
4,082
11,385
20
3
16
196
40
196
2.93 Domestic
350
231
2.41 Domestic
2.73 Domestic
Buick Elect
15
4
4
20
4,080
3,670
2,230
3,280
3,880
3,400
4,330
3,900
4,290
2,110
3,690
222
43
Buick LeSa
18
3
4
21
218
43
Buick Opel
Buick Rega
Buick Rivie
26
3
10
170
34
304
2.87 Domestic
20
3
2
16
200
42
196
2.93 Domestic
16
4
17
207
43
231
2.93 Domestic
Buick Skyla
19
3
4
13
200
42
231
3.08 Domestic
Cad. Devill
14
4
20
221
44
425
2.28 Domestic
14,500
15,906
3,299
5,705
Cad. Eldor:
Cad. Seville
14
2
4
16
204
43
350
2.19 Domestic
21
3
13
204
45
350
2.24 Domestic
Chev. Chev
29
3
163
34
231
2.93 Domestic
Chev. Impa
Chev. Malit
16
4
20
212
43
250
2.56 Domestic
4,504
5,104
3,667
3,955
3,984
4,010
5,886
6,342
4,389
4,187
11,497
13,594
13,466
3,829
5,379
6,165
4,516
6,303
3,291
8,814
5,172
4,733
4,890
4,181
4,195
22
17
3,180
3,220
2,750
3,430
2,120
3,600
3,600
3,740
1,800
2,650
4,840
4,720
3,830
193
31
200
2.73 Domestic
Chev. Mont
22
16
200
41
200
2.73 Domestic
Chev. Mon:
24
2
2
7
179
40
151
2.73 Domestic
Chev. Nova
19
3
4
13
197
43
250
2.56 Domestic
Dodge Colt
Dodge Dipl
Dodge Maç
Dodge St. F
Ford Fiesta
30
2
8
163
35
98
3.54 Domestic
18
2
4
17
206
46
318
2.47 Domestic
206
220
16
2
4
17
46
318
2.47 Domestic
17
2
21
46
225
2.94 Domestic
28
4
9.
147
33
98
3.15 Domestic
Ford Musta
21
2
10
179
43
140
3.08 Domestic
Linc. Contir
12
3
4
22
233
51
400
2.47 Domestic
Linc. Mark
12
3
18
230
48
400
2.47 Domestic
Linc. Versa
14
3
4
15
201
41
302
2.47 Domestic
Merc. Bobc
22
4
2,580
4,060
3,720
3,370
4,130
2,830
169
39
140
2.73 Domestic
2.75 Domestic
Merc. Couç
Merc. Marq
14
4
4
16
221
48
302
15
3
4
23
212
44
302
2.26 Domestic
18
2.43 Domestic
2.75 Domestic
Merc. Mona
3
15
198
41
250
Merc. XR-7
14
4
16
217
45
302
Merc. Zeph
20
3
4
17
195
43
140
3.08 Domestic
4,060
3,310
3,300
3,690
3,370
2,730
Olds 98
21
4
20
220
43
350
2.41 Domestic
Olds Cutl S
19
2
16
198
42
231
2.93 Domestic
Olds Cutlas
19
16
198
42
231
2.93 Domestic
Olds Delta
18
4
4
20
218
42
231
2.73 Domestic
Olds Omeg
19
3
14
200
43
231
3.08 Domestic
Olds Starfir
24
1
10
180
40
151
2.73 Domestic
Olds Toron
10,371
4,647
4,425
4,482
6,486
4,060
5,798
4,934
5,222
4,723
4,424
4,172
9,690
6,295
9,735
6,229
4,589
5,079
8,129
4,296
5,799
4,499
3,995
16
3
17
4,030
3,260
1,800
206
43
350
2.41 Domestic
Plym. Arrov
Plym. Char
Plym. Horiz
Plym. Sapp
Plym. Volai
28
3
11
170
37
156
3.05 Domestic
34
3
11
157
37
86
2.97 Domestic
2,200
2,520
3,330
3,700
3,470
3,210
3,200
3,420
2,690
2,830
2,070
2,650
2,370
25
3
4
17
165
36
105
3.37 Domestic
26
2
8
182
38
119
3.54 Domestic
225
231
18
2
16
201
44
3.23 Domestic
Pont. Catal
18
4
4
20
214
42
2.73 Domestic
Pont. Fireb
18
1
2
7
198
42
231
3.08 Domestic
Pont. Gran
19
2.93 Domestic
2.93 Domestic
3
16
201
45
231
Pont. Le M:
19
4
17
199
40
231
Pont. Phoe
19
4
13
203
43
231
3.08 Domestic
Pont. Sunb
24
7
179
41
151
2.73 Domestic
3.20 Foreign
3.70 Foreign
Audi 5000
17
3
15
189
37
131
Audi Fox
23
3
3
11
174
36
97
3.64 Foreign
3.89 Foreign
3.70 Foreign
3.54 Foreign
3.55 Foreign
3.37 Foreign
3.05 Foreign
3.30 Foreign
3.73 Foreign
3.58 Foreign
3.72 Foreign
3.81 Foreign
3.06 Foreign
3.21 Foreign
3.05 Foreign
3.74 Foreign
3.78 Foreign
3.78 Foreign
3.78 Foreign
2.98 Foreign
BMW 320i
25
3
12
177
34
121
Datsun 200
Datsun 210
23
4
6.
170
35
119
2,020
2,280
2,750
2,130
2,240
1,760
1,980
3,420
1,830
2,050
2,410
2,200
2,670
2,160
2,040
1,930
1,990
3,170
35
2
8
165
32
85
Datsun 510
24
4
3
8
170
34
119
Datsun 810
21
4
3
184
38
146
Fiat Strada
21
3
3
16
161
36
105
Honda Acc
25
3
10
172
36
107
Honda Civi
28
4
3
149
34
91
Mazda GLC
30
4
4
11
154
33
86
Peugeot 60
Renault Le
12,990
3,895
3,798
5,899
3,748
5,719
7,140
5,397
4,697
6,850
11,995
14
4
14
192
38
163
26
3
3
10
142
34
79
Subaru
35
11
164
36
97
Тоyota Celi
Тoyota Cor
Тоyota Cor
VW Dashei
18
14
174
36
134
31
9.
165
35
97
18
11
175
36
134
23
4
12
172
36
97
VW Diesel
VW Rabbit
VW Scirocc
41
5
15
155
35
90
25
4
15
155
35
89
25
4
16
156
36
97
Volvo 260
17
3
14
193
37
163
-------

Accepted Answer

Based on the given statement, the dependent variable is Price.
And the independent variable is…