1. Introduction:
Search some information related to your dataset topic and do introduction about the topic. Make assumptions before doing the data analysis (such as bigger house, the price of the house may be more expensive).
2. Describing the data:
Plot histograms of your x variable and the y variable using reasonable intervals for each set. (There will be two histograms. Note that the histogram has no gap) Comment on the shape of the distribution (such as the shape and right-skewed or left- skewed).
3. Analyze whether the x and y distributions satisfy the empirical rule (Yes or No, explain why). Show details such like the range of within 1 standard deviation, within 2 standard deviation and within 3 standard deviation and the corresponding true percentage falling in these ranges.
4. Identify and list all outliers in each distribution (Both X and Y) using appropriate methodology and explain why they are outliers. If you have more than 10 outliers in either distribution (X or Y) in your dataset, you can just list out the top 10 outliers.
5. Calculate the mean, median, and mode. Finish the following table for the five number summary (Minimum, Q1, median, Q3, maximum) and the z-scores of each.
Wheel Toyota Corolla S 4dr 15030 102 Vehicle Name Retail Price (Considered as Y) Base (X) Toyota Corolla LE 4dr 15295 102 Chevrolet Aveo 4dr 11690 86 Toyota Echo 2dr manual 10760 93 Chevrolet Aveo LS 4dr hatch 12585 98 Toyota Echo 2dr auto 11560 93 Chevrolet Cavalier 2dr 14610 104 Toyota Echo 4dr 11290 93 Chevrolet Cavalier 4dr 14810 104 Buick Century Custom 4dr 22180 109 Chevrolet Cavalier LS 2dr 16385 104 Chevrolet Impala 4dr 21900 111 Dodge Neon SE 4dr 13670 105 Chevrolet Malibu 4dr 18995 106 Dodge Neon SXT 4dr 15040 105 Chevrolet Malibu LS 4dr 20370 106 Ford Focus ZX3 2dr hatch 13270 103 Chevrolet Monte Carlo LS 2dr 21825 111 Ford Focus LX 4dr 13730 103 Chrysler PT Cruiser 4dr 17985 103 Ford Focus SE 4dr 15460 103 Chrysler PT Cruiser Limited 4dr 22000 103 Ford Focus ZX5 5dr 15580 103 Chrysler Sebring 4dr 19090 108 Honda Civic DX 2dr 13270 103 Chrysler Sebring Touring 4dr 21840 108 Honda Civic HX 2dr 14170 103 Dodge Intrepid SE 4dr 22035 113 Honda Civic LX 4dr 15850 103 Dodge Stratus SXT 4dr 18820 108 Hyundai Accent 2dr hatch 10539 96 Dodge Stratus SE 4dr 20220 108 Hyundai Accent GL 4dr 11839 96 Ford Focus SVT 2dr 19135 103 Hyundai Accent GT 2dr hatch 11939 96 Ford Taurus LX 4dr 20320 109 Hyundai Elantra GLS 4dr 13839 103 Ford Taurus SES Duratec 4dr 22735 109 Hyundai Elantra GT 4dr 15389 103 Honda Accord LX 2dr 19860 105 Hyundai Elantra GT 4dr hatch 15389 103 Honda Accord EX 2dr 22260 105 Kia Optima LX 4dr 16040 106 Honda Civic EX 4dr 17750 103 Kia Rio 4dr manual 10280 95 Honda Civic Si 2dr hatch 19490 101 Kia Rio 4dr auto 11155 95 Honda Civic Hybrid 4dr manual (gas/electric) 20140 103 Kia Spectra 4dr 12360 101 Honda Insight 2dr (gas/electric) 19110 95 Kia Spectra GS 4dr hatch 13580 101 Hyundai Sonata GLS 4d 19339 106 Kia Spectra GSX 4dr hatch 14630 101 Hyundai Sonata LX 4dr 20339 106 Mini Cooper 16999 97 Kia Optima LX V6 4dr 18435 106 Nissan Sentra 1.8 4dr 12740 100 Mazda6 i 4dr 19270 105 Nissan Sentra 1.8 $ 4dr 14740 100 Mercury Sable GS 4dr 21595 109 Pontiac Sunfire 1SA 2dr 15495 104 Mini Cooper S 19999 97 Saturn lon1 4dr 10995 103 Nissan Altima $ 4dr 19240 110 Saturn lon2 4dr 14300 103 Nissan Sentra SE-R 4dr 17640 100 Saturn lon3 4dr 15825 103 Oldsmobile Alero GX 2dr 18825 107 Saturn lon2 quad coupe 2dr 14850 103 Pontiac Grand Am GT 2dr 22450 107 Saturn lon3 quad coupe 2dr 16350 103 Pontiac Grand Prix GT1 4dr 22395 111 Scion xA 4dr hatch 12965 93 Pontiac Sunfire 1SC 2dr 17735 104 Suzuki Aeno S 4dr 12884 98 Saturn L300-2 4dr 21410 107 Suzuki Aerio LX 4dr 14500 98 Subaru Impreza 2.5 RS 4dr 19945 99 Suzuki Forenza S 4dr 12269 102 Subaru Legacy L 4dr 20445 104 Suzuki Forenza EX 4dr 15568 102 Suzuki Verona LX 4dr 17262 106 Toyota Corolla CE 4dr 14085 102 Toyota Camry LE 4dr 19560 107Toyota Camry LE V6 4dr 22775 107 Nissan Maxima SL 4dr 29440 111 Toyota Camry Solara SE 2dr 19635 107 Oldsmobile Alero GLS 2dr 23675 107 Toyota Camry Solara SE V6 2dr 21965 107 Pontiac Grand Prix GT2 4dr 24295 111 Toyota Prius 4dr (gas/electric) 20510 106 Subaru Legacy GT 4dr 25645 104 Volkswagen Golf GLS 4dr 18715 99 Subaru Outback Limited Sedan 4dr 27145 104 Volkswagen GTI 1.8T 2dr hatch 19825 99 Subaru Outback H6 4dr 29345 104 Volkswagen Jetta GLS TDI 4dr 21055 99 Toyota Avalon XL 4dr 26560 107 Volkswagen New Beetle GLS 1.8T 2dr 21055 99 Toyota Camry XLE V6 4dr 25920 107 Acura RSX Type S 2dr 23820 101 Toyota Camry Solara SLE V6 2dr 26510 107 Acura TSX 4dr 26990 105 Volkswagen Jetta GLI VR6 4dr 23785 99 Audi A4 1.8T 4dr 25940 104 Volkswagen New Beetle GLS convertible 2dr 23215 99 BMW 325i 4dr 28495 107 Volkswagen Passat GLS 4dr 23955 106 Buick Lesabre Custom 4dr 26470 112 Volvo $40 4dr 25135 101 Buick Regal LS 4dr 24895 109 Acura TL 4dr 33195 108 Buick Regal GS 4dr 28345 109 Audi A41.8T convertible 2dr 35940 105 Chevrolet Impala LS 4dr 25000 111 Audi A4 3.0 4dr 31840 104 Chevrolet Impala SS 4dr 27995 111 Audi A4 3.0 Quattro 4dr manual 33430 104 Chevrolet Malibu LT 4dr 23495 106 Audi A4 3.0 Quattro 4dr auto 34480 104 Chevrolet Monte Carlo SS 2dr 24225 111 di A6 3.0 4dr 36640 109 Chrysler 300M 4dr 29865 113 Audi A6 3.0 Quattro 4dr 39640 109 Chrysler Concorde LX 4dr 24130 113 BMW 325Ci 2dr 30795 107 Chrysler Concorde LXi 4dr 26860 113 BMW 325Ci convertible 2dr 37995 107 Chrysler PT Cruiser GT 4dr 25955 103 BMW 325xi 4dr 30245 107 Chrysler Sebring convertible 2dr 25215 106 BMW 330i 4dr 35495 107 Dodge Intrepid ES 4dr 24885 113 BMW 330Ci 2dr 36995 107 Ford Crown Victoria 4dr 24345 115 BMW 330xi 4dr 37245 107 Ford Crown Victoria LX 4dr 27370 115 BMW 525i 4dr 39995 114 Honda Accord LX V6 4dr 23760 108 Buick Lesabre Limited 4dr 32245 112 Honda Accord EX V6 2dr 26960 105 Buick Park Avenue 4dr 35545 114 Hyundai XG350 4dr 24589 108 Cadillac CTS VVT 4dr 30835 113 Hyundai XG350 L 4dr 26189 108 Chrysler 300M Special Edition 4dr 33295 113 Infiniti G35 4dr 28495 112 Chrysler Sebring Limited convertible 2dr 30950 106 Infiniti G35 Sport Coupe 2dr 29795 112 Ford Crown Victoria LX Sport 4dr 30315 115 Jaguar X-Type 2.5 4dr 29995 107 Infiniti G35 4dr 32445 112 Mercedes-Benz C230 Sport 2dr 26060 107 Infiniti 135 4dr 31145 108 Mercedes-Benz C320 Sport 2dr 28370 107 Jaguar X-Type 3.0 4dr 33995 107 Mercury Grand Marquis GS 4dr 24695 115 Lexus ES 330 4dr 32350 107 Mercury Grand Marquis LS Premium 4dr 29595 115 Lexus IS 300 4dr manual 31045 105 Mercury Sable LS Premium 4dr 23895 109 Lexus IS 300 4dr auto 32415 105 Mitsubishi Diamante LS 4dr 29282 107 Lincoln LS V6 Luxury 4dr 32495 115 Mitsubishi Galant GTS 4dr 25700 108 Lincoln LS V6 Premium 4dr 36895 115 Nissan Altima SE 4dr 23290 110 Mercedes-Benz C240 4dr 32280 107 Nissan Maxima SE 4dr 27490 111 Mercedes-Benz C240 4dr 33480 107Mercedes-Benz C320 Sport 4dr 35920 107 Lexus GS 430 4dr 48450 110 Mercedes-Benz C320 4dr 37630 107 Lexus LS 430 4dr 55750 115 30895 115 Lincoln LS V8 Sport 4dr 40095 115 Mercury Grand Marquis LS Ultimate 4dr Mercury Marauder 4dr 34495 115 Lincoln LS V8 Ultimate 4dr 43495 115 Saab 9-3 Arc Sport 4dr 30860 105 Lincoln Town Car Signature 4dr 41815 118 Saab 9-3 Aero 4dr 33360 105 Lincoln Town Car Ultimate 4dr 44925 118 Saab 9-5 Arc 4dr 35105 106 Lincoln Town Car Ultimate L 4dr 50470 124 Saab 9-5 Aero 4dr 39465 106 Mercedes-Benz C32 AMG 4dr 52120 107 Subaru Outback H-6 VDC 4dr 31545 104 Mercedes-benz CL500 2dr 94820 114 Toyota Avalon XLS 4dr 30920 107 Mercedes-Benz CL600 2dr 128420 114 Volkswagen Passat GLX V6 4MOTION 4dr 33180 106 Mercedes-benz CLK320 coupe 2dr (convertible) 45707 107 Volkswagen Passat W8 4MOTION 4dr 39235 106 Mercedes-benz CLK500 coppe 2dr (convertible) 52800 107 Volvo S60 2.5 4dr 31745 107 Mercedes-Benz E320 4dr 48170 112 Volvo S60 T5 4dr 34845 107 Mercedes-Benz E500 4dr 57270 112 37560 107 Mercedes-benz 5430 4dr 74320 Volvo $60 R 4dr 122 Volvo S80 2.9 4dr 37730 110 Mercedes-Benz $500 4dr 86970 122 Volvo S80 2.5T 4dr 37885 110 Saab 9-3 Arc convertible 2dr 40670 105 43755 43175 105 Acura 3.5 RL 4dr 115 Saab 9-3 Aero convertible 2dr Acura 3.5 RL w/Navigation 4dr 46100 115 Volvo C70 LPT convertible 2dr 40565 105 Audi A4 3.0 convertible 2dr 42490 105 Volvo C70 HPT convertible 2dr 42565 105 Audi A4 3.0 Quattro convertible 2dr 44240 105 Volvo $80 T6 4dr 45210 110 Audi A6 2.7 Turbo Quattro 4dr 42840 109 Audi A6 4.2 Quattro 4dr 49690 109 Audi A8 L Quattro 4dr 69190 121 Audi $4 Quattro 4dr 48040 104 BMW 330Ci convertible 2dr 44295 107 BMW 530i 4dr 44995 114 BMW 545iA 4dr 54995 114 BMW 745i 4dr 69195 118 BMW 745Li 4dr 73195 123 Buick Park Avenue Ultra 4dr 40720 114 Cadillac Deville 4dr 45445 115 Cadillac Deville DTS 4dr 50595 115 Cadillac Seville SLS 4dr 47955 112 Infiniti M45 4dr 42845 110 Infiniti Q45 Luxury 4dr 52545 113 Jaguar S-Type 3.0 4dr 43895 115 Jaguar S-Type 4.2 4dr 49995 115 Jaguar S-Type R 4dr 63120 115 Jaguar Vanden Plas 4dr 68995 119 Jaguar XJ8 4dr 59995 119 Jaguar XJR 4dr 74995 119 Lexus GS 300 4dr 41010 110\f
