Project_Data_Autocar_Test_Data

Project_Data_Autocar_Test_Data - SUMMARY OUTPUT AC Diesel...

Info icon This preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
SUMMARY OUTPUT AC Diesel Regression Statistics Multiple R 0.9031081366 R Square 0.8156043063 Adjusted R Square 0.8106206389 Standard Error 1.9016040462 Observations 39 ANOVA df SS MS F Significance F Regression 1 591.7941194995 591.7941194995 163.655445164 3.7417139E-015 Residual 37 133.7956240902 3.6160979484 Total 38 725.5897435897 Coefficients Standard Error t Stat P-value Lower 95% Upper 95%Lower 95.0% Upper 95.0% Intercept 6.7763828239 2.1417827676 3.1638982843 0.0031078417 2.4367187227 11.116047 2.4367187 11.116047 X Variable 1 0.5915665939 0.0462421919 12.7927887954 3.741714E-015 0.4978710133 0.6852622 0.497871 0.6852622 RESIDUAL OUTPUT Observation Predicted Y Residuals Standard Residuals 1 35.1715793304 1.8284206696 0.9744217419 2 31.0306131732 0.9693868268 0.5166161245 3 31.6221797671 -2.6221797671 -1.3974404352 4 36.9462791121 -2.9462791121 -1.5701629676 5 26.889647016 0.110352984 0.0588105072 6 26.889647016 -0.889647016 -0.4741203211 7 34.5800127365 0.4199872635 0.2238241602 8 29.8474799854 0.1525200146 0.0812826177 9 33.9884461426 -3.9884461426 -2.1255659064 10 41.6788118632 -1.6788118632 -0.8946905968 11 36.3547125182 0.6452874818 0.3438935922 12 36.9462791121 0.0537208879 0.0286295173 13 32.8053129549 2.1946870451 1.1696163848 14 33.9884461426 1.0115538574 0.5390882351 15 33.3968795488 0.6031204512 0.3214214816 16 32.8053129549 -0.8053129549 -0.4291761001 17 35.1715793304 -2.1715793304 -1.1573015713 18 36.9462791121 2.0537208879 1.0944911739 19 29.2559133916 0.7440866084 0.3965466926 20 29.2559133916 -1.2559133916 -0.669314964 21 36.3547125182 -2.3547125182 -1.2548988927 22 29.8474799854 0.1525200146 0.0812826177 23 33.9884461426 1.0115538574 0.5390882351 24 30.4390465793 2.5609534207 1.3648110277 25 38.1294122999 1.8705877001 0.9968938524 26 28.0727802038 -2.0727802038 -1.1046484709 27 34.5800127365 1.4199872635 0.7567549885 28 39.3125454876 -0.3125454876 -0.1665651256 29 35.1715793304 0.8284206696 0.4414909136 30 35.7631459243 -1.7631459243 -0.9396348179 31 35.1715793304 0.8284206696 0.4414909136 32 36.3547125182 1.6452874818 0.8768244205 33 35.1715793304 3.8284206696 2.0402833985 34 25.1149472344 -2.1149472344 -1.1271205814 35 34.5800127365 2.4199872635 1.2896858168 36 35.1715793304 2.8284206696 1.5073525702 37 36.3547125182 -0.3547125182 -0.1890372361 38 44.0450782387 -3.0450782387 -1.622816068 39 32.8053129549 -1.8053129549 -0.9621069284
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
SUMMARY OUTPUT AC Petrol Regression Statistics Multiple R 0.9671885787 R Square 0.9354537467 Adjusted R Square 0.9341364762 Standard Error 1.7238500157 Observations 51 ANOVA df SS MS F Significance F Regression 1 2110.310283667 2110.3103 710.14554 8.14E-031 Residual 49 145.6112849606 2.9716589 Total 50 2255.921568627 Coefficients Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0% Upper 95.0% Intercept 5.8305068777 0.888870392 6.5594567 3.19E-008 4.0442549 7.6167588 4.0442549 7.6167588 X Variable 1 0.6017826859 0.0225821874 26.648556 8.14E-031 0.5564021 0.6471633 0.5564021 0.6471633 RESIDUAL OUTPUT Observation Predicted Y Residuals ndard Residuals 1 32.910727745 -1.910727745 -1.11966 2 20.875074026 0.1249259738 0.0732049 3 24.485770142 0.5142298581 0.3013317 4 16.060812539 -1.0608125387 -0.621622 5 16.060812539 -2.0608125387 -1.207608 6 20.27329134 -1.2732913403 -0.746131 7 29.901814315 1.0981856847 0.6435218 8 38.326771918 -1.3267719185 -0.77747 9 21.476856712 -0.4768567122 -0.279432 10 38.9285546044 -1.9285546044 -1.130107 11 31.105379687 0.8946203128 0.5242353 12 34.716075803 2.2839241972 1.3383484 13 29.300031629 0.6999683706 0.4101719 14 33.512510431 0.487489569 0.2856622 15 23.28220477 1.71779523 1.0066045 16 34.716075803 3.2839241972 1.9243347 17 24.485770142 1.5142298581 0.887318 18 35.3178584888 -0.3178584888 -0.186261 19 40.132119976 -2.1321199763 -1.249393 20 38.326771918 1.6732280815 0.9804888 21 33.512510431 -3.512510431 -2.058283 22 20.27329134 0.7267086597 0.4258413 23 20.875074026 1.1249259738 0.6591912 24 32.308945059 1.6910549409 0.9909351 25 34.114293117 -3.1142931169 -1.824933 26 16.662595225 -0.6625952246 -0.388272 27 20.875074026 0.1249259738 0.0732049 28 35.919641175 -1.9196411747 -1.124883 29 32.308945059 3.6910549409 2.1629077 30 26.892900886 2.1070991144 1.2347313 31 30.503597001 -2.5035970013 -1.467074 32 22.680422084 -1.680422084 -0.984704 33 26.2911182 0.7088818003 0.415395 34 29.300031629 -1.3000316294 -0.761801 35 25.689335514 2.3106644863 1.3540178 36 30.503597001 0.4964029987 0.2908854 37 34.716075803 2.2839241972 1.3383484 38 16.662595225 -0.6625952246 -0.388272 39 32.308945059 -1.3089450591 -0.767024 40 32.308945059 -0.3089450591 -0.181038 41 31.105379687 3.8946203128 2.2821943 42 26.2911182 0.7088818003 0.415395 43 26.2911182 -1.2911181997 -0.756578 44 29.901814315 0.0981856847 0.0575355 45 40.132119976 -0.1321199763 -0.077421 46 33.512510431 -1.512510431 -0.88631 47 27.494683572 0.5053164284 0.2961085 48 22.078639398 -0.0786393981 -0.046082 49 28.096466258 -2.0964662575 -1.228501 50 28.096466258 -0.0964662575 -0.056528 51 28.096466258 -0.0964662575 -0.056528
Image of page 2
MPG Data Model More Detail Fuel SMMT category Price as Tested AC Test Overall AC Test best AC Worst VCA Combined VCA Urban VCA Extra 0-60mph Length Width Height Weight Engine Max power Max torque Power to weight High Speed Tyre Size VCA CO2 Emissions 1 Alfa 159 1591.9 JTDM 16v Diesel Upper Medium £22,750 37 50 27 48 36 59 9.5 9.4 4660 1828 1417 1480 1910 148 236 96 34 225 156 2 Audi A5 A5 Coupé3.0 V6 TDI quattro 240PS Tiptronic with DPF Diesel Upper Medium £34,345 32 43 14 41 33 48 6.4 5.9 4625 1854 1372 1610 2967 237 369 147 36 225 182 3 Audi Q5 Q52.0 CR TDI quattro 170PS with DPF Diesel SUV £30,335 29 37 16 42 34 49 9.9 10.2 4629 1880 1653 1730 1968 168 258 97 30 235 178 4 Audi TT TT Roadster2.0 CR TDI quattro 170PS with DPF Diesel Specialist Sports £27,365 34 48 17 51 39 63 7.7 8.7 4178 1842 1352 1370 1968 168 258 123 33 225 146 5 BMW X5 X5 Series E70X5 xDrive30d - with particle filter - from April 2009 Diesel SUV £40,100 27 35 13 34 27 40 7.9 8.2 4854 1933 1766 2180 2993 232 383 106 34 255 220 6 BMW X6 X6 Series E71X6 xDrive30d - with particle filter Diesel SUV £45,835 26 31 9 34 27 40 7.3 7.1 4877 1983 1690 2185 2993 282 428 129 34 255 220 7 Cadillac BLS BLS, MY2008 4 Door Saloon1.9D 150 hp Diesel Upper Medium £25,073 35 52 20 47 35 58 9.5 9.3 4680 1752 1471 1510 1910 148 236 101 30 225 159 8 Chevrolet Captiva Captiva 2.0 VCDi LS 2WD 5 seats Diesel SUV £26,045 30 28 17 39 32 46 12.2 12.7 4635 1850 1755 1820 1991 148 236 81 35 205 191 9 Chevrolet Epica Epica2.0CD Diesel Upper Medium £17,745 30 40 19 46 38 53 10.2 10.6 4805 1810 1450 1560 1991 148 236 94 39 215 162 10 Citroen C3 Picasso C3 Picasso1.6HDi 90hp Diesel MPV £14,645 40 53 25 59 46 69 12.8 14.5 4078 1730 1672 1364 1560 89 161 65 28 195 127 11
Image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern