Homework Help is Here – Start Your Trial Now!
Math
Statistics
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.

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.

MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
See similar textbooks
icon
Related questions
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 -------
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 -------
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
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
SEE MORE TEXTBOOKS