Please help me solve this assignment. I'm so confused about it. These are my files, but I don't know why I cannot send the file to you.

WPC 300 Car Manufacturer Homework Assignment A team charged with designing a new car in an automobile manufacturing company is concerned about the gasoline mileage that can be achieved. With the growing pressure from the government, the team is worried that the car's mileage will result in violation of Corporate Average Fuel Economy (CAFE] regulations for vehicle efficiency, generating bad publicity and fines. Because of the anticipated weight of the car, the mileage attained in city driving is of particular concern. The design team has a good idea of the characteristics of the car, right down to the type of leather to be used for the seats. However, the team does not know how these characteristics will affect the mileage. You are hired to help the team. Your goal is two folds. First, you need to learn which characteristics of the design are likely to affect city mileage. The engineers want a model that they can rely on to predict the associated mileage for a car when designed. You have access to the data file: CarsData.jmp. The data variables in the file are summarized in the following table. Manufacturer The Name of the Automobile Company Model The model of the car Vehicle Category The category of vehicle: small, midsize, compact, large, van, sporty Maximum Price Maximum price of the vehicle in thousand dollars Minimum Price Minimum price of the vehicle in thousand dollars Midrange Price Midrange price of the vehicle in thousand dollars City Mileage (MPG) Mileage in City (in Miles per Gallon) Number of Cylinders The number of cylinders the car engine has Engine size Size of the engine in liters Maximum Horsepower Maximum horsepower of the car RPM at Max Horsepower Revolutions per minute at maximum horsepower Fuel tank capacity Maximum gallons of gas the tank can hold Passenger capacity Number of passenger seats the car has Length The length of the car in inches Width The width of the car in inches Wheel base The distance between the front and rear axles of the car U-turn space The space in feet driver would need to do a U-turn Rear seat rooms Rooms in the back seat in inches Luggage capacity Amount of luggage the car can fit in cubic ft. Weight Weight of the car in pound Case question: 1. Explore all 17 numeric data variables in the file. Show the descriptive distribution of each variable. Do you see any outliers in the data? [10 points] 2. In order to develop a model, you want to know the relationships between the data variables. Create a scatter plot matrix by using all 18 numeric variables and explain what you learn fromWPC 300 Car Manufacturer the correlation matrix. Which two variables have highest correlation and which two variables have lowest correlation? [10 + 2.5 + 2.5 points] 3. Use the least square method to develop a linear model to predict the city mileage of a car given all other attributes of a car in the data file. Show screenshot from JMP. [10 points] a. Remove the insignificant parameters from the model one by one by checking the log(worth) of each parameter and removing the least important parameter first from the model. b. Keep doing it until you are left with parameters that are significant (p-value less than 5%). Show the screenshot from JMP analysis. [15 points] c. What is the R' of your final model? Explain the meaning of the obtained R. [10 points] d. Based on the model, what is the most and least important variables in predicting the city mileage of a car? [10 points] e. Did you find any multicollinerity effect in the model? Show parameter estimate tables obtained from the model with information on VIF to support your answer. [10 points] f. Show "Residual by Predicted" plot and explain what you see in the scattered distribution. [10 points] E. Write down the equation of the model and explain how a manager would determine the expected city mileage of a newly designed car. [10 points]CarsData.jmp CarsData.jmp Vehicle Minimum Price Midrange Price Maximum Price City Mileage Maximum Manufacturer Category ($1000) ($1000) ($1000) (liters) Horsepower 1 Acura Integra Small 12.9 15.9 18.8 25 1.8 140 2 Acura 29.2 33.9 38.7 18 3.2 200 3 Audi 90 Compact 25.9 29.1 32.3 20 2.8 172 4 Audi 100 Midsize 30.8 44.6 19 2.8 172 5 BMW 535i Midsize 23.7 30 22 3.5 208 Century Midsize 14.2 17.3 22 2.2 110 Columns (20/1) Large 19.9 20.8 21.7 19 3.8 170 L. Manufacturers 8 Buick Roadmaster 22.6 24.9 16 5.7 180 9 Buick Riviera 26.3 26.3 26.3 19 3.8 170 L Vehicle Category Minimum Price ($1000) 10 Cadillac DeVille Large 33 34.7 36.3 16 4.9 200 Midrange Price ($1000) 11 Cadillac Seville Midsize 37.5 10.1 42.7 16 4.6 295 Maximum Price ($1000) 12 Chevrolet Cavalier Compact 8.5 13.4 18.3 25 2.2 110 City Mileage (MPG) 13 Chevrolet Corsica Compact 11.4 11.4 25 2.2 110 Engine Size (liters) 14 Chevrolet Sporty 13.4 16.8 19 3.4 160 Maximum Horsepower 15 Chevrolet Lumina Midsize 13.4 21 2.2 110 RPM at Max Horsepower Engine Revs...(highest gear) Lumina APV 14.7 16.3 18 18 3.8 170 Fuel Tank Capacity 17 Chevrolet Astro Van 14.7 16.6 18.6 15 4.3 165 Passenger Capacity Large 18 19.6 17 170 Length (inches) 19 Chevrolet Corvette Sporty 34.6 38 41.5 17 5.7 Wheel Base (inches) Width (inches) 20 Chrysler Concorde Large 18.4 18.4 18.4 20 3.3 153 U-Turn Space (feet) 21 Chrysler LeBaron Compact 14.5 15.8 23 141 Rear Seat Room (inches) 22 Chrysler Imperial Large 29.5 29.5 29.5 20 3.3 147 Luggage Capacity (cu. ft.) 23 Dodge Colt Small 7.9 9.2 10.6 29 1.5 92 Weight (pounds) 24 Dodge Shadow Small 8.4 11.3 14.2 23 2.2 93 25 Dodge Spirit Compact 11.9 13.3 22 2.5 100 26 Dodge Van 13.6 19 24.4 17 142 27 Dodge Midsize 14.8 15.6 16.4 21 2.5 28 Dodge Sporty 18.5 25.8 33.1 18 3 300 29 Eagle Summit Small 7.9 12.2 29 1.5 92 Rows 30 Eagle Vision Large 17.5 19.3 21.2 20 3.5 214 All rows 31 Ford 6.9 7.4 7.9 31 1.3 63 Excluded 32 Ford Escort Small 8.4 11.9 23 1.8 127 33 Ford Tempo Compact 10.4 11.3 12.2 22 2.3 96CarsData.jmp Vehicle Minimum Price Midrange Price Maximum Price Maximum Notes Robin H. Lock, "1993 Ne City Mileage Manufacturer Model ($1000) ($1000) ($1000) (MPG) liters) Horsepower 29 Eagle Small 7.9 12.2 29 1.5 92 30 Eagle Vision 17.5 21.2 20 3.5 214 31 Ford Festiva Small 6.9 7.4 7.9 31 1.3 63 32 Ford Escort Small 8.4 10.1 11.9 23 1.8 127 33 Ford Compact 10.4 11.3 22 2.3 96 34 Ford Mustang 10.8 21 22 2.3 105 Columns (20/1) 35 Ford Probe Sporty 12.8 14 15.2 24 2 115 36 Ford Aerostar Van 14.5 19.9 25.3 15 145 Model 37 Ford Taurus Midsize 20.2 24.8 21 140 Vehicle Category Minimum Price ($1000) 38 Ford Crown ... 20.9 18 190 Midrange Price ($1000) 39 Geo Metro Small 6.7 8.4 10 46 55 Maximum Price ($1000) 40 Geo Sporty 11.5 12.5 13.5 30 1.6 90 City Mileage (MPG) 41 Honda Prelude Sporty 17 19.8 22.7 24 2.3 160 Engine Size (liters) 42 Honda Small 8.4 12.1 15.8 42 1.5 102 Maximum Horsepower RPM at Max Horsepower 43 Honda Accord Compact 13.8 17.5 21.2 24 2.2 140 Engine Revs...(highest gear) 44 Hyundai Excel Smal 6.8 9.2 29 1.5 81 Fuel Tank Capacity 45 Hyundai Elantra 10 11 22 1.8 124 Passenger Capacity 46 Hyundai Scoupe Sporty 9.1 10 26 1.5 92 Length (inches) 47 Hyundai Midsize 13.9 15.3 20 128 Wheel Base (inches) Width (inches) 245 Midsize 45.4 47.9 50.4 17 4.5 278 U-Turn Space (feet) 49 Lexus ES300 Midsize 27.5 28 28.4 18 185 Rear Seat Room (inches) 50 Lexus Midsize 35.2 35.6 18 225 Luggage Capacity (cu. ft.) 51 Lincoln Continental Midsize 33.3 34.3 35.3 17 3.8 160 Weight (pounds) 52 Lincoln Town Car Large 34.4 36.1 37.8 18 4.6 210 53 Mazda Small 7.4 8.3 9.1 29 1.6 82 54 Mazda Protege Small 10.9 11.6 12.3 28 1.8 103 55 Mazda Compact 18.7 26 2.5 164 56 Mazda MPV 16.6 19.1 21.7 18 155 57 Mazda RX-7 Sporty 32.5 32.5 32.5 17 1.3 255 Rows 58 Mercedes-... 190E Compact 29 31.9 34.9 20 2.3 130 All rows 59 Mercedes-... 300E Midsize 61.9 80 19 3.2 217 Excluded 60 Mercury Capri Sporty 13.3 14.1 15 23 1.6 100 lidden 61 Mercury Cougar Midsize 14.9 14.9 19 3.8 140CarsData.jmp Vehicle Minimum Price Midrange Price Maximum Price City Mileage Engine Size Maximum Notes Robin H. Lock, "1993 Ne Manufacturer Model Category ($1000) ($1000) ($1000) (MPG) (liters) Horsepower 61 Mercury Cougar Midsize 14.9 14.9 19 3.8 140 62 Mitsubishi Small 7.7 10.3 12.9 29 1.5 92 63 Mitsubishi Diamante Midsize 26.1 29.9 18 202 64 Nissan Sentra Small 8.7 11.8 29 1.6 110 65 Nissan Altima 13 15.7 18.3 24 2.4 150 66 Nissan Quest Van 16.7 21.5 17 151 Columns (20/1) 67 Nissan Midsize 21 21.5 22 21 it Manufacturer 68 Oldsmobile Achieva Compact 13 13.5 14 24 2.3 ib Model 69 Oldsmobile Cutlass Ciera Midsize 16.3 18.4 23 2.2 110 L Vehicle Category Minimum Price ($1000) 70 Oldsmobile Silhouette Van 19.5 19.5 19.5 18 3.8 170 Midrange Price ($1000) 71 Oldsmobile Eighty-Eight 19.5 20.7 21.9 19 3.8 170 Maximum Price ($1000) 72 Plymouth Laser Sporty 11.4 14.4 23 1.8 92 City Mileage (MPG) 73 Pontiac LeMans Small 8.2 9.9 31 1.6 74 Engine Size (liters) 74 Pontiac Sunbird Compact 9.4 12.8 23 110 Maximum Horsepower RPM at Max Horsepower 75 Pontiac Firebird Sporty 14 17.7 21.4 19 3.4 Engine Revs...(highest gear) 76 Pontiac Grand Prix Midsize 15.4 18.5 21.6 19 3.4 200 Fuel Tank Capacity 77 Pontiac Bonneville Large 24.4 29.4 19 3.8 170 Passenger Capacity 78 Saab 900 Compact 20.3 28.7 20 2.1 Length (inches) 79 Saturn SL 9.2 11.1 28 1.9 85 Wheel Base (inches) 80 Subaru Justy Small 7.3 8.4 9.5 33 73 Width (inches 1.2 U-Turn Space (feet) 10.5 10.9 11.3 25 1.8 90 Rear Seat Room (inches) 82 Subaru Legacy Compact 16.3 19.5 23 2.2 130 Luggage Capacity (cu. ft.) 83 Suzuki Swift Small 7.3 8.6 10 39 1.3 70 Weight (pounds) 84 Toyota Tercel Small 7.8 9.8 11.8 32 1.5 82 85 Toyota Celica Sporty 14.2 18.4 22.6 25 2.2 135 86 Toyota Camry Midsize 15.2 18.2 21.2 22 2.2 87 Toyota Previa Van 18.9 22.7 26.6 18 2.4 138 88 Volkswagen Small 8.7 9.1 9.5 25 1.8 81 89 Volkswagen Eurovan Van 16.6 19.7 22.7 17 2.5 Rows 90 Volkswagen Passat Compact 17.6 20 22.4 21 93 91 Volkswagen 22.9 23.7 18 2.8 178 92 Volvo 240 Compact 21.8 22.7 23.5 21 2.3 114 93 Volvo 850 Midsize 24.8 26.7 28.5 20 2.4 168