Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i need the solution as a code from R studio softawre solve for a like 2. Conduct a pairs plot of the data. Explain briefly
i need the solution as a code from R studio softawre solve for a like
2. Conduct a pairs plot of the data. Explain briefly what you see. 3. Regress "Price" as a function of "Mileage". Plot Price as a function of mileage and add your regression line. Is your model significant? Is it a good model? Do we have outliers? How much is it explaining in terms of the overall variability? Do you need to do any transformation on Price? If so, choose an appropriate one, defend your choice and refit the model. Is it a better model? How much does it explain in terms of the overall variability? Use your model to estimate the average price difference between 2 cars, where one of the two cars has 20,000 miles more miles than the other. 4. Fit a regression that predicts "Price" from "Mileage" and "Liter". Another with "Mileage" and "Cylinder". And a third with them both in your model along with Mileage. Explain what do you see? Do we have a multicollinaerity problem between "Cylinder" and "Liter" when you add them to your regression? Which of the three regressions is the better model? Is cylinder an important predictor? Is Liter an important predictor? Plot "Liters" versus "Cylinder". What do you see? Can I include them both in my model? 5. Run a model that predicts log (Price) from mileage and Make. Explain what the model coefficients mean. What is the most expensive car irrespective of mileage? If a Chevrolet has 10,000 miles less, by how much will that impact its price on average? \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & A & B & c & D & E & F & G & H & I & j & K & L \\ \hline 56 & 20952 & 20158 & Buick & Lesabre & Limited S & Sedan & 6 & 3.8 & 4 & 1 & 1 & c \\ \hline 57 & 21562 & 23767 & Buick & Lesabre & Limited S & Sedan & 6 & 3.8 & 4 & 1 & 0 & \\ \hline 58 & 19981 & 24323 & Buick & Lesabre & Limited S & Sedan & 6 & 3.8 & 4 & 1 & 1 & ( \\ \hline 59 & 19426 & 27839 & Buick & Lesabre & Limited S & Sedan & 6 & 3.8 & 4 & 1 & 1 & \\ \hline 60 & 19192 & 29187 & Buick & Lesabre & Limited S & Sedan & 6 & 3.8 & 4 & 1 & 1 & \\ \hline 61 & 19642 & 31324 & Buick & Lesabre & Limited S & Sedan & 6 & 3.8 & 4 & 1 & 1 & \\ \hline 62 & 25590 & 2308 & Buick & Park Aven & Sedan 4D & Sedan & 6 & 3.8 & 4 & 1 & 1 & s \\ \hline 63 & 25099 & 10014 & Buick & Park Aven & Sedan 4D & Sedan & 6 & 3.8 & 4 & 1 & 1 & ( \\ \hline 64 & 23421 & 18910 & Buick & Park Aven & Sedan 4D & Sedan & 6 & 3.8 & 4 & 1 & 0 & \\ \hline 65 & 22661 & 20105 & Buick & Park Aven & Sedan 4D & Sedan & 6 & 3.8 & 4 & 1 & 0 & \\ \hline 66 & 23493 & 20453 & Buick & Park Aven & Sedan 4D & Sedan & 6 & 3.8 & 4 & 1 & 1 & ( \\ \hline 67 & 22435 & 22287 & Buick & Park Aven & Sedan 4D & Sedan & 6 & 3.8 & 4 & 1 & 1 & \\ \hline 68 & 21878 & 23237 & Buick & Park Aven & Sedan 4D & Sedan & 6 & 3.8 & 4 & 1 & 1 & , \\ \hline 69 & 23078 & 23798 & Buick & Park Aven & Sedan 4D & Sedan & 6 & 3.8 & 4 & 1 & 0 & \\ \hline 70 & 21698 & 25489 & Buick & Park Aven & Sedan 4D & Sedan & 6 & 3.8 & 4 & 1 & 1 & \\ \hline 71 & 21832 & 25564 & Buick & Park Aven & Sedan 4D & Sedan & 6 & 3.8 & 4 & 1 & 1 & \\ \hline 72 & 26831 & 4695 & Buick & Park Aven & Special Ed & Sedan & 6 & 3.8 & 4 & 1 & 1 & \\ \hline 73 & 26060 & 9795 & Buick & Park Aven & Special Ed & Sedan & 6 & 3.8 & 4 & 1 & 1 & ( \\ \hline 74 & 26782 & 12052 & Buick & Park Aven & Special Ed & Sedan & 6 & 3.8 & 4 & 1 & 1 & \\ \hline 75 & 26302 & 13050 & Buick & Park Aven & Special Ed & Sedan & 6 & 3.8 & 4 & 1 & 1 & \\ \hline 76 & 26190 & 17335 & Buick & Park Aven & Special Ed & Sedan & 6 & 3.8 & 4 & 1 & 0 & \\ \hline 77 & 25508 & 17480 & Buick & Park Aven & Special Ed & Sedan & 6 & 3.8 & 4 & 1 & 1 & \\ \hline 78 & 23348 & 24027 & Buick & Park Aven & Special Ed & Sedan & 6 & 3.8 & 4 & 1 & 0 & \\ \hline 79 & 23407 & 25387 & Buick & Park Aven & Special Ed & Sedan & 6 & 3.8 & 4 & 1 & 0 & \\ \hline 80 & 23160 & 25869 & Buick & Park Aven & Special Ed & Sedan & 6 & 3.8 & 4 & 1 & 0 & ( \\ \hline 81 & 21537 & 37128 & Buick & Park Aven & Special Ed & Sedan & 6 & 3.8 & 4 & 1 & 1 & \\ \hline 82 & 51154 & 2202 & Cadillac & CST-V & Sedan 4D & Sedan & 8 & 5.7 & 4 & 1 & 1 & \\ \hline 83 & 49248 & 6685 & Cadillac & CST-V & Sedan 4D & Sedan & 8 & 5.7 & 4 & 1 & 0 & \\ \hline 84 & 46748 & 15343 & Cadillac & CST-V & Sedan 4D & Sedan & 8 & 5.7 & 4 & 1 & 1 & \\ \hline 85 & 44131 & 21341 & Cadillac & CST-V & Sedan 4D & Sedan & 8 & 5.7 & 4 & 1 & 0 & \\ \hline 86 & 44085 & 21367 & Cadillac & CST-V & Sedan 4D & Sedan & 8 & 5.7 & 4 & 1 & 1 & \\ \hline 87 & 43892 & 23371 & Cadillac & CST-V & Sedan 4D & Sedan & 8 & 5.7 & 4 & 1 & 0 & \\ \hline 88 & 44301 & 23751 & Cadillac & CST-V & Sedan 4D & Sedan & 8 & 5.7 & 4 & 1 & 0 & \\ \hline 89 & 42678 & 24052 & Cadillac & CST-V & Sedan 4D & Sedan & 8 & 5.7 & 4 & 1 & 0 & \\ \hline 90 & 43374 & 25199 & Cadillac & CST-V & Sedan 4D & Sedan & 8 & 5.7 & 4 & 1 & 1 & \\ \hline 91 & 40619 & 30082 & Cadillac & CST-V & Sedan 4D & Sedan & 8 & 5.7 & 4 & 1 & 1 & \\ \hline 92 & 33418 & 6598 & Cadillac & CTS & Sedan 4D & Sedan & 6 & 2.8 & 4 & 1 & 1 & \\ \hline 93 & 30957 & 10625 & Cadillac & CTS & Sedan 4D & Sedan & 6 & 2.8 & 4 & 1 & 1 & \\ \hline 94 & 31431 & 11013 & Cadillac & CTS & Sedan 4D & Sedan & 6 & 2.8 & 4 & 1 & 1 & \\ \hline 95 & 30782 & 14937 & Cadillac & CTS & Sedan 4D & Sedan & 6 & 2.8 & 4 & 1 & 1 & \\ \hline 96 & 30646 & 17094 & Cadillac & CTS & Sedan 4D & Sedan & 6 & 2.8 & 4 & 1 & 1 & \\ \hline 97 & 30792 & 17870 & Cadillac & CTS & Sedan 4D & Sedan & 6 & 2.8 & 4 & 1 & 1 & \\ \hline 98 & 30393 & 18449 & Cadillac & CTS & Sedan 4D & Sedan & 6 & 2.8 & 4 & 1 & 1 & \\ \hline 99 & 28817 & 21039 & Cadillac & CTS & Sedan 4D & Sedan & 6 & 2.8 & 4 & 1 & 0 & \\ \hline 100 & 29275 & 21056 & Cadillac & CTS & Sedan 4D & Sedan & 6 & 2.8 & 4 & 1 & 1 & \\ \hline 101 & 28040 & 27484 & Cadillac & CTS & Sedan 4D & Sedan & 6 & 2.8 & 4 & 1 & 1 & \\ \hline 102 & 39802 & 14095 & Cadillac & Deville & DHS SedaI & Sedan & 8 & 4.6 & 4 & 1 & 0 & \\ \hline 103 & 40336 & 14743 & Cadillac & Deville & DHS Seda & Sedan & 8 & 4.6 & 4 & 1 & 0 & \\ \hline 104 & 39307 & 16041 & Cadillac & Deville & DHS SedaI & Sedan & 8 & 4.6 & 4 & 1 & 0 & \\ \hline 105 & 38600 & 17138 & Cadillac & Deville & DHS Sedal & Sedan & 8 & 4.6 & 4 & 1 & 0 & \\ \hline 106 & 38446 & 18661 & Cadillac & Deville & DHS Seda & Sedan & 8 & 4.6 & 4 & 1 & 0 & \\ \hline 107 & 36078 & 21966 & Cadillac & Deville & DHS Seda & Sedan & 8 & 4.6 & 4 & 1 & 0 & \\ \hline 108 & 35867 & 24415 & Cadillac & Deville & DHS Sedal & Sedan & 8 & 4.6 & 4 & 1 & 1 & \\ \hline 109 & 35339 & 25163 & Cadillac & Deville & DHS Sedal & Sedan & 8 & 4.6 & 4 & 1 & 0 & \\ \hline 110 & 36154 & 25339 & Cadillac & Deville & DHS Seda & Sedan & 8 & 4.6 & 4 & 1 & 1 & \\ \hline 111 & 34686 & 25421 & Cadillac & Deville & DHS SedaI & Sedan & 8 & 4.6 & 4 & 1 & 0 & \\ \hline 112 & 42820 & 5499 & Cadillac & Deville & DTS Sedar & Sedan & 8 & 4.6 & 4 & 1 & 0 & \\ \hline 113 & 41378 & 8125 & Cadillac & Deville & DTS Sedar & Sedan & 8 & 4.6 & 4 & 1 & 0 & \\ \hline 114 & 40856 & 12791 & Cadillac & Deville & DTS Sedar & Sedan & 8 & 4.6 & 4 & 1 & 1 & \\ \hline 115 & 41419 & 14452 & Cadillac & Deville & DTS Sedar & Sedan & 8 & 4.6 & 4 & 1 & 0 & \\ \hline 116 & 37510 & 21593 & Cadillac & Deville & DTS Sedar & Sedan & 8 & 4.6 & 4 & 1 & 0 & \\ \hline 117 & 37215 & 22211 & Cadillac & Deville & DTS Sedar & Sedan & 8 & 4.6 & 4 & 1 & 0 & \\ \hline 118 & 36333 & 25153 & Cadillac & Deville & DTS Sedar & Sedan & 8 & 4.6 & 4 & 1 & 0 & \\ \hline 119 & 36245 & 26250 & Cadillac & Deville & DTS Sedar & Sedan & 8 & 4.6 & 4 & 1 & 1 & \\ \hline 120 & 32954 & 36074 & Cadillac & Deville & DTS Sedar & Sedan & 8 & 4.6 & 4 & 1 & 0 & \\ \hline 121 & 32537 & 41829 & Cadillac & Deville & DTS Sedar & Sedan & 8 & 4.6 & 4 & 1 & 1 & \\ \hline 122 & 35716 & 6447 & Cadillac & Deville & Sedan 4D & Sedan & 8 & 4.6 & 4 & 1 & 0 & \\ \hline 123 & 35652 & 10555 & Cadillac & Deville & Sedan 4D & Sedan & 8 & 4.6 & 4 & 1 & 1 & \\ \hline 124 & 35129 & 11975 & Cadillac & Deville & Sedan 4D & Sedan & 8 & 4.6 & 4 & 1 & 1 & \\ \hline 125 & 35166 & 13449 & Cadillac & Deville & Sedan 4D & Sedan & 8 & 4.6 & 4 & 1 & 1 & \\ \hline 126 & 32501 & 17508 & Cadillac & Deville & Sedan 4D & Sedan & 8 & 4.6 & 4 & 1 & 0 & \\ \hline 127 & 33220 & 18661 & Cadillac & Deville & Sedan 4D & Sedan & 8 & 4.6 & 4 & 1 & 0 & \\ \hline 128 & 32509 & 20910 & Cadillac & Deville & Sedan 4D & Sedan & 8 & 4.6 & 4 & 1 & 0 & \\ \hline 129 & 31132 & 23124 & Cadillac & Deville & Sedan 4D & Sedan & 8 & 4.6 & 4 & 1 & 1 & \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started