Hello this is a practice problem to help me prepare for an upcoming analytics exam, I am a bit confused and this is all the information I had been provided with. Could someone give some guidance on how to do this or if something looks missing can you let me know what to ask my professor for? I am quite anxious and overwhelmed.

In this problem we focus on a vehicle table to help select the best fit model to predict a vehicle's city mileage among the four regression models provided below:

Model 1: use weight as the independent variable.

Model 2: use weight and maximum horsepower as the independent variables.

Model 3: use vehicle category as the independent variable.

Model 4: use vehicle category, weight, and maximum horsepower as the independent variables.

Answer the following questions below with the help of the JMP vehicle table provided at the bottom:

Model 1:

1. What is the RSquare for Model 1? 2. What is the Adjusted RSquare for Model 1? 3. Model 1 predicts the city mileage for a vehicle that weights 3040 lbs to be ____.

Model 2: 4. What is the RSquare for Model 2? 5. What is the Adjusted RSquare for Model 2? 6. Model 2 predicts the city mileage for a vehicle that weights 3040 lbs and has maximum horsepower of 140 to be ____.

Model 3: 7. What is The RSquare for Model 3?

8. What is the Adjusted RSquare for Model 3? 9. Model 3 predicts the city mileage for a compact vehicle to be _____.

Model 4: 10. What is the RSquare for Model 4? 11. What is the Adjusted RSquare for Model 4? 12. Model 4 predicts the city mileage for a large vehicle that weighs 3000 lbs and has a maximum horsepower of 160 to be?

T/F a. Model 4 is the best fit model (T/F) b. Model3 is the worst fit model (T/F) c. Adjusted RSquare always increases with additional independent variables (T/F) d. Adding maximum horsepower as an independent variable in Model2 explains the variations in city mileage better than that of Model1 (T/F)

vehicle (1).jmp ... vehicle (1).jmp A Notes car data on manufacturer, model, Manufacturer Model Vehicle Category City Mileage (MPG) Maximum Horsepower Weight (pounds) 140 2705 1 Acura Integra Small 25 3560 2 Acura Legend Midsize 18 200 Compact 20 172 3375 3 Audi 90 19 172 3405 4 Aud 100 Midsize 208 3640 5 BMW 535 Midsize 22 2880 6 Buick Century Midsize 22 110 170 3470 7 Buick LeSabre Large 19 4105 8 Buick Roadmaster Large 16 180 19 170 3495 Columns (6/0) 9 Buick Riviera Midsize 200 3620 10 Cadillac DeVille Large 16 Midsize 16 295 3935 Manufacturers 11 Cadillac Seville Compact 25 110 2490 Models 12 Chevrolet Cavalier Vehicle Category 110 2785 13 Chevrolet Corsica Compact 25 City Mileage (MPG) 160 3240 Maximum Horsepower 14 Chevrolet Camaro Sporty 19 Midsize 21 110 3195 Weight (pounds) 15 Chevrolet Lumina 170 3715 16 Chevrolet Lumina APV Van 18 165 4025 17 Chevrolet Astro Van 15 17 170 3910 18 Chevrolet Caprice Large 300 3380 19 Chevrolet Corvette Sporty 17 20 Chrysler Concorde Large 20 153 3515 23 141 3085 21 Chrysler LeBaron Compact 147 3570 22 Chrysler Imperial Large 20 2270 23 Dodge Colt Small 29 92 93 2670 24 Dodge Shadow Small 23 Compact 22 100 2970 25 Dodge Spirit 3705 Caravan Van 17 142 26 Dodge 308 27 Dodge Dynasty Midsize 21 100 Sporty 18 300 3805 28 Dodge Stealth 2295 29 Eagle Summit Small 29 92 214 3490 30 Eagle Vision Large 20 31 63 1845 31 Ford Festiva Small 32 Ford Escort Small 23 127 2530 96 2690 33 Ford Tempo Compact 22 22 105 285 34 Ford Mustang Sporty Sporty 24 115 2710 35 Ford Probe 15 145 3735 Rows 36 Ford Aerostar Van 140 3325 All rows 37 Ford Taurus Midsize 21 Selected 3950 38 Ford Crown Victoria Large 18 190 Excluded oooo 1695 39 Geo Metro Small 46 55 Hidden 30 90 2475 Labeled 40 Sportyvehicle (1).jmp ... vehicle (1).jmp A Manufacturer Model Vehicle Category City Mileage (MPG) Maximum Horsepower Weight (pounds) Notes car data on manufacturer, model, 2865 41 Honda Prelude Sporty 24 160 42 102 2350 42 Honda Civic Small 24 140 3040 43 Honda Accord Compact 29 81 44 Hyundai Exce Small 2345 124 2620 45 Hyundai Elantra Small 22 Sporty 26 92 2285 46 Hyundai Scoupe Sonata Midsize 20 128 2885 47 Hyundai Midsize 17 278 4000 48 Infiniti Q45 185 3510 Columns (6/0) 49 Lexus ES300 Midsize 18 SC300 Midsize 18 225 3515 50 Lexus 160 51 Lincoln Continental Midsize 17 3695 Manufacturers 18 210 4055 Models 52 Lincoln Town Car Large Vehicle Category 53 Mazda Small 29 82 2325 323 City Mileage (MPG) Small 28 103 2440 Protege Maximum Horsepower 54 Mazda 626 Compact 26 164 2970 Weight (pounds) 55 Mazda 18 155 3735 56 Mazda MPV Van 2895 57 Mazda RX-7 Sporty 17 255 130 2920 58 Mercedes-Benz 190E Compact 20 3525 59 Mercedes-Benz 300E Midsize 19 217 23 100 2450 60 Mercury Capri Sporty 140 61 Mercury Midsize 19 3610 Cougar Small 29 92 2295 62 Mitsubishi Mirage 3730 63 Mitsubishi Diamante Midsize 18 202 Sentra Small 29 110 2545 64 Nissan 150 305 65 Nissan Altima Compact 24 17 151 4100 66 Nissan Quest Van 67 Nissan Maxima Midsize 21 160 320 Compact 24 155 2910 68 Oldsmobile Achieva Cutlass Ciera Midsize 23 110 2890 69 Oldsmobile Van 18 170 3715 70 Oldsmobile Silhouette Large 19 170 3470 71 Oldsmobile Eighty-Eight Laser Sporty 23 92 2640 72 Plymouth Small 31 74 2350 73 Pontiac LeMans 74 Pontiac Sunbird Compact 23 110 2575 160 75 Pontiac Firebird Sporty 19 3240 200 3450 Rows 76 Pontiac Grand Prix Midsize 19 19 170 3495 All rows 77 Pontiac Bonneville Large Selected 140 2775 78 Saab 900 Compact 20 Excluded oooo Small 28 85 2495 Hidden 79 Saturn SL 33 73 2045 Labeled 80 Justy81 Subaru Loyale Small 25 90 2490 82 Subaru Legacy Compact 23 130 3085 83 Suzuki Swift Small 39 70 1965 84 Toyota Tercel Small 32 82 2055 85 Toyota Celica Sporty 25 135 2950 86 Toyota Camry Midsize 22 130 3030 87 Toyota Previa Van 18 138 3785 88 Volkswagen Fox Small 25 81 2240 89 Volkswagen Eurovan Van 17 109 3960 90 Volkswagen Passat Compact 21 134 2985 Rows 91 Volkswagen Corrado Sporty 18 178 2810 All rows 93 Selected 92 Volvo 240 Compact 21 114 2985 Excluded 93 Volvo 850 Midsize 20 168 3245 oooo Hidden Labeled