Minitab express homework about Regression Modelling

Anonymous
timer Asked: Nov 5th, 2016

Question description

I need help for a Minitab homework, I attached my project and the instructions for my projects on Regression Modelling.

Make/Model Acura MDX Acura RDX Acura RL Acura TL Audi A3 Audi A6 Audi A8 Audi Q7 Audi S4 BMW 3 Series sedan 328i 6-cyl BMW 5 Series BMW 6 Series BMW 7 Series BMW X3 BMW X5 BMW Z4 Buick Enclave Buick LaCrosse Buick Lucerne Cadillac DTS Cadillac Escalade Cadillac SRX Cadillac STS Cadillac XLR Chevrolet Aveo hatchback 1LT 4-cyl Chevrolet Cobalt sedan LT 4-cyl Chevrolet Corvette convertible Base V8 MT Chevrolet Equinox Chevrolet HHR Chevrolet Impala Chevrolet Suburban Chevrolet Tahoe LT V8 Chevrolet TrailBlazer Chevrolet Uplander Chrysler 300 C V8 Chrysler Pacifica Chrysler PT Cruiser Chrysler Sebring sedan Touring 4-cyl Chrysler Town & Country Dodge Caliber SXT 4-cyl CVT Dodge Charger SXT V6 Dodge Durango Dodge Grand Caravan Dodge Magnum Dodge Nitro Dodge Viper MPG 17 18 18 23 25 21 17 15 20 24 22 19 18 19 17 26 15 18 19 17 13 16 18 17 27 23 21 18 23 20 14 14 15 18 16 16 20 23 17 22 17 12 16 19 16 15 Length (in) CargoWidth (in) WheelBase (in) 191 79 108 181 74 104 194 73 110 195 74 109 169 77 102 194 71 112 204 75 121 200 78 118 181 72 104 178 72 109 191 73 114 190 73 109 204 75 123 180 73 110 191 76 116 161 70 98 201 78 119 198 73 111 203 74 116 208 75 116 203 79 116 195 73 116 196 73 116 178 72 106 154 66 98 180 68 103 175 73 106 189 71 113 176 69 104 200 73 111 222 79 130 202 79 116 192 75 113 205 72 121 197 74 120 199 79 116 169 67 103 191 73 109 203 77 121 174 69 104 200 75 120 201 76 119 203 77 121 198 74 120 179 73 109 176 75 99 Ford Edge Ford Escape Ford Expedition Ford Explorer XLT V6 Ford Fusion SEL V6 Ford Mustang coupe GT Premium V8 MT Ford Taurus X Honda Civic sedan EX 4-cyl Honda CR-V Honda Element Honda Fit Sport 4-cyl MT Honda Odyssey Honda Pilot Honda S2000 Hummer H3 Hyundai Accent GLS 4-cyl Hyundai Azera Hyundai Elantra GLS 4-cyl Hyundai Santa Fe Hyundai Sonata GLS 4-cyl Hyundai Tucson Hyundai Veracruz Infiniti G sedan Journey V6 Infiniti M M35 V6 Jaguar S-Type Jaguar XJ Jaguar XK Jeep Commander Jeep Compass Jeep Grand Cherokee Jeep Patriot Jeep Wrangler Kia Amanti Kia Optima EX V6 Kia Rio sedan LX 4-cyl Kia Rondo Kia Sedona Kia Sorento Kia Spectra EX 4-cyl Kia Sportage Land Rover LR3 Lexus ES Lexus GS 300 V6 Lexus GX Lexus IS Lexus LS Lexus RX 350 V6 16 19 13 15 20 20 16 31 21 21 34 19 17 25 14 28 19 27 18 23 18 17 19 19 19 19 19 13 22 14 20 15 18 23 28 21 17 15 28 18 13 23 20 15 24 21 19 186 175 221 193 190 188 200 177 178 170 162 201 191 162 187 169 193 177 184 189 170 191 187 193 192 200 189 189 173 186 174 173 197 186 167 179 202 181 176 170 191 191 190 188 180 203 186 76 70 79 74 72 74 75 69 72 72 67 77 79 69 75 67 73 70 74 72 71 77 70 71 72 73 82 75 69 73 69 74 73 71 67 72 78 73 68 71 75 72 72 74 71 74 73 111 103 131 114 107 107 113 106 103 101 98 118 109 95 112 98 109 104 106 107 104 110 112 114 115 119 108 110 104 109 104 116 110 107 98 106 119 107 103 104 114 109 112 110 108 122 107 Lexus SC Lincoln MKX Lincoln MKZ Lincoln Navigator Lincoln Town Car Lotus Elise Mazda CX-7 Mazda CX-9 Mazda MX-5 Miata Mazda RX-8 Mazda Mazda3 sedan i 4-cyl MT Mazda Mazda5 Mazda Mazda6 Mercedes-Benz CLS Mercedes-Benz E-Class sedan E350 V6 Mercedes-Benz GL-Class Mercedes-Benz M-Class Mercedes-Benz S-Class Mercedes-Benz SL Mercedes-Benz SLK Mercury Grand Marquis Mercury Milan Base 4-cyl Mini Cooper Mitsubishi Eclipse hatchback GS 4-cyl MT Mitsubishi Endeavor Mitsubishi Galant ES 4-cyl Mitsubishi Outlander XLS V6 Nissan 350Z Nissan Altima sedan 2.5 S 4-cyl CVT Nissan Armada Nissan Maxima Nissan Murano Nissan Pathfinder Nissan Quest Nissan Sentra 2.0 S 4-cyl CVT Nissan Versa hatchback 1.8 S 4-cyl MT Nissan Xterra Pontiac G6 sedan GT V6 Pontiac Grand Prix Pontiac Solstice Pontiac Vibe Porsche 911 Porsche Boxster Saab 9-3 sedan 2.0T 4-cyl Saab 9-5 Saturn Aura XE 4-cyl Saturn Outlook 21 16 20 13 17 29 18 16 27 18 30 23 23 18 21 15 16 17 17 21 16 23 30 23 17 23 19 20 25 13 21 19 15 18 26 29 17 22 20 23 27 20 22 23 21 20 16 179 187 191 208 215 149 184 200 157 174 178 182 187 194 190 200 189 205 179 161 212 191 146 180 190 190 183 169 190 208 191 189 188 204 180 169 179 189 198 157 173 176 172 182 190 190 201 72 76 72 79 78 68 74 76 68 70 69 69 70 74 72 76 75 73 72 70 78 72 66 72 74 72 71 72 71 79 73 74 73 78 71 67 73 71 72 71 70 71 70 68 71 70 78 103 111 107 119 118 91 108 113 92 106 104 108 105 112 112 121 115 125 101 96 115 107 97 101 108 108 105 104 109 123 109 111 112 124 106 102 106 112 111 95 102 93 95 105 106 112 119 Saturn Sky Saturn Vue Scion tC Scion xB Subaru Forester 2.5X 4-cyl Subaru Legacy Subaru Outback wagon 2.5i 4-cyl Subaru Tribeca Suzuki Forenza Suzuki Grand Vitara Suzuki SX4 Sport 4-cyl Suzuki XL-7 Toyota 4Runner Toyota Avalon Toyota Camry LE 4-cyl Toyota Camry Solara Toyota Corolla Base 4-cyl MT Toyota FJ Cruiser Toyota Highlander Limited V6 Toyota Prius Base 4-cyl CVT Toyota RAV4 Base 4-cyl Toyota Sienna XLE AWD V6 Toyota Yaris hatchback Base 4-cyl Volkswagen GTI Volkswagen Jetta 2.5 5-cyl Volkswagen Passat Volvo S40 Volvo S60 Volvo S80 Volvo V50 Volvo XC90 24 17 26 23 22 18 21 16 27 18 22 17 16 22 24 21 29 17 18 44 23 18 34 25 24 24 23 22 20 20 16 161 180 174 167 177 186 189 192 177 177 163 197 189 197 189 193 178 184 188 175 181 201 151 166 179 188 176 180 191 178 189 71 73 69 69 68 68 70 74 68 71 69 72 74 73 72 72 67 75 75 68 72 77 67 69 69 72 70 71 73 70 75 95 107 106 102 99 105 105 108 102 104 98 112 110 111 109 107 102 106 110 106 105 119 97 102 102 107 104 107 112 104 113 CargoVol(cuft) HP 36 30 13 13 20 16 18 37 13 11 14 13 18 33 36 2 44 16 17 19 47 37 14 4 7 14 11 37 30 19 61 51 39 51 16 36 32 13 62 20 16 45 62 30 40 6 300 240 300 270 200 255 330 350 340 215 300 360 325 260 260 225 275 200 197 275 403 255 255 320 103 145 400 185 172 242 320 320 291 240 340 253 180 173 251 172 340 335 197 250 210 510 Accto60(sec) Breakfr60(ft) TrngCirc(ft) OriginCODE 8 139 40 0 7,4 145 41 0 6,9 148 43 0 6,7 138 42 0 7,3 149 35 0 7,7 144 40 0 7,6 140 41 0 8,2 146 40 0 5,3 140 38 0 7,4 142 37 0 5,8 149 39 0 5,6 133 40 0 6,9 154 42 0 7,9 140 39 0 8,6 142 42 0 6 126 33 0 8,9 153 43 1 9 160 40 1 9,2 175 44 1 7,6 180 46 1 7,5 181 42 1 8,3 152 42 1 7,1 146 40 1 6,4 145 41 1 11,2 146 35 1 8,8 152 37 1 5 145 42 1 9,1 153 43 1 9,2 159 41 1 7,8 155 41 1 9,1 165 45 1 9 168 42 1 9,1 159 39 1 8,8 153 43 1 6,4 139 41 1 8,6 146 42 1 8,1 165 41 1 10,2 156 40 1 8,8 172 42 1 10,3 157 39 1 6 134 41 1 7,6 167 43 1 10,3 182 42 1 8,8 166 41 1 9,1 167 39 1 4,2 130 43 1 Origin Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe US US US US US US US US US US US US US US US US US US US US US US US US US US US US US US 36 38 73 48 16 13 38 13 26 47 24 67 48 5 38 12 17 14 38 16 31 42 14 13 14 17 10 39 27 33 30 35 16 15 9 33 65 32 12 31 52 15 13 40 13 18 33 265 200 300 210 221 300 263 140 166 166 109 255 255 240 220 110 263 138 242 162 173 260 306 275 294 294 300 330 172 235 172 205 200 162 110 182 244 192 138 173 300 272 245 235 204 380 270 8,3 10,5 9,1 9,7 8 5,5 8,5 8,6 10,6 10,4 9,9 8,6 8,2 5,8 11,5 12,5 7,1 10,4 8,5 10,5 10,1 8,6 2,2 6,9 6,3 7,1 7 7,3 10,1 8,8 10,8 10,7 9,1 9,2 12,8 9,6 9 9,5 9,5 11,3 9,1 6,4 7,4 8 7,7 6,2 7,3 159 215 166 163 143 144 152 136 139 162 144 144 157 134 170 153 144 152 139 133 143 154 132 141 142 143 138 160 163 159 168 172 160 142 150 163 152 155 153 172 145 140 147 136 134 153 141 39 40 45 38 42 39 42 39 39 36 36 40 40 36 37 36 41 37 39 39 39 41 38 39 40 41 38 41 38 40 38 43 41 39 35 39 43 39 37 38 39 39 38 41 35 40 40 1 1 1 1 1 1 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 US US US US US US US Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe US Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe US US US US US Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe US Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe 8 37 16 57 21 4 28 38 5 8 11 39 15 16 16 46 41 16 10 10 21 16 6 16 40 13 34 4 16 59 14 31 48 60 13 18 46 14 16 4 24 5 9 15 16 16 49 288 265 263 300 239 190 244 263 170 238 148 157 160 302 268 335 268 382 382 268 239 160 172 162 215 160 220 287 175 317 255 245 270 235 140 122 261 169 200 177 126 355 240 210 260 224 275 6,5 8,2 6,9 8,8 8,7 4,6 9,1 3,2 6,7 6,7 8,6 10,3 9,6 6,1 6,5 7,4 7,8 6 5,3 6,2 8 9,5 7,2 9,3 8,2 9,1 8,3 6,2 8,1 7,2 6,8 8 8 8,4 9,6 9,5 7,7 9,4 8,3 7,2 10,7 4,4 6,5 8 7,2 8,1 8,8 144 162 135 167 154 132 140 161 138 130 140 154 145 133 152 154 143 154 132 130 151 144 154 149 147 148 142 130 142 140 150 146 172 153 164 187 158 156 169 148 150 127 123 136 139 160 162 38 41 42 42 42 37 41 40 33 38 36 37 41 38 38 42 38 40 36 34 42 40 37 42 41 43 38 37 39 44 44 40 43 45 38 37 40 42 41 36 38 37 37 37 40 42 42 0 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 0 0 1 1 1 1 Asia or Europe US US US US Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe US US Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe US US US US Asia or Europe Asia or Europe US US US US 4 28 13 34 32 11 31 36 12 25 16 37 45 14 15 14 14 34 38 16 39 71 9 15 16 14 14 14 15 28 38 260 257 160 158 173 250 168 256 126 185 143 252 239 280 158 225 130 239 270 110 166 266 106 200 150 200 168 208 235 218 311 6,2 8,2 8,8 9,4 10 3,1 11,8 8,6 9,5 9,5 12,2 7,7 8,2 6,7 9,6 7,5 9,8 8 8 10,5 9,8 7,7 9,3 6,7 9,4 7,7 9,4 7,9 8,6 8,5 7,6 156 162 147 148 142 151 158 162 157 147 150 147 146 155 151 138 151 157 151 152 139 147 186 141 146 145 148 145 158 153 138 37 42 37 37 38 38 38 40 36 38 37 44 40 41 38 39 38 44 42 37 37 39 34 36 36 38 37 42 39 36 42 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 US US Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe Asia or Europe US US US US US Type Auto 4 Door SUV 4 Door SUV Sedan Sedan 4 Door Hatchback Sedan Sedan 4 Door SUV Sedan Wagon Sedan Coupe Sedan 4 Door SUV 4 Door SUV Coupe 4 Door SUV Sedan Sedan Sedan 4 Door SUV 4 Door SUV Sedan Coupe Sedan Sedan Coupe 4 Door SUV 4 Door SUV Sedan 4 Door SUV 4 Door SUV 4 Door SUV Minivan Sedan 4 Door SUV Sedan Sedan Minivan 4 Door Hatchback Sedan 4 Door SUV Minivan Wagon 4 Door SUV Coupe Transmission Auto 5 Auto 5 Auto 5 Auto 5 Seq 6 Auto 6 Auto 6 Auto 6 Man 6 Auto 6 Auto 6 Auto 6 Auto 6 Auto 6 Auto 6 Man 6 Auto 6 Auto 4 Auto 4 Auto 4 Auto 6 Auto 5 Auto 5 Auto 5 Man 5 Auto 4 Man 6 Auto 5 Auto 4 Auto 4 Auto 4 Auto 4 Auto 4 Auto 4 Auto 5 Auto 6 Auto 4 Auto 4 Auto 6 CVT Auto 5 Auto 5 Auto 6 Auto 4 Auto 4 Man 6 4 Door SUV 4 Door SUV 4 Door SUV 4 Door SUV Sedan Coupe Sedan Sedan 4 Door SUV 4 Door SUV 4 Door Hatchback Minivan 4 Door SUV Coupe 4 Door SUV Sedan Sedan Sedan 4 Door SUV Sedan 4 Door SUV 4 Door SUV Sedan Sedan Sedan Sedan Coupe 4 Door SUV 4 Door SUV 4 Door SUV 4 Door SUV 4 Door SUV Sedan Sedan Sedan Wagon Minivan 4 Door SUV Sedan 4 Door SUV 4 Door SUV Sedan Sedan 4 Door SUV Sedan Sedan 4 Door SUV Auto 6 Auto 4 Auto 6 Auto 5 Auto 6 Man 5 Auto 6 Man 5 Auto 5 Auto 5 Man 5 Auto 5 Auto 5 Man 6 Auto 4 Auto 4 Auto 5 Auto 4 Auto 5 Auto 4 Auto 4 Auto 6 Auto 5 Auto 5 Auto 6 Auto 6 Auto 6 Auto 5 CVT Auto 5 CVT Auto 4 Auto 5 Auto 5 Auto 4 Auto 5 Auto 5 Auto 4 Man 5 Auto 4 Auto 6 Auto 6 Auto 6 Auto 5 Auto 6 Auto 8 Auto 5 Coupe 4 Door SUV Sedan 4 Door SUV Sedan Coupe 4 Door SUV 4 Door SUV Coupe Coupe Sedan Wagon Sedan Sedan Sedan 4 Door SUV 4 Door SUV Sedan Coupe Coupe Sedan Sedan Coupe Coupe 4 Door SUV Sedan 4 Door SUV Coupe Sedan 4 Door SUV Sedan 4 Door SUV 4 Door SUV Minivan Sedan Sedan 4 Door SUV Sedan Sedan Coupe Wagon Coupe Coupe Sedan Sedan Sedan 4 Door SUV Auto 6 Auto 6 Auto 6 Auto 6 Auto 4 Man 6 Auto 6 Auto 6 Man 6 Man 6 Man 5 Auto 4 Auto 4 Auto 7 Auto 7 Auto 7 Auto 7 Auto 7 Auto 7 Man 6 Auto 4 Auto 5 Man 6 Man 5 Auto 4 Auto 4 Auto 6 Man 6 CVT Auto 5 CVT CVT Auto 5 Auto 5 CVT Man 6 Auto 5 Auto 4 Auto 4 Man 5 Auto 4 Man 6 Man 5 Auto 5 Auto 5 Auto 4 Auto 6 Coupe 4 Door SUV Coupe Wagon 4 Door SUV Sedan Wagon 4 Door SUV 4 Door Hatchback 4 Door SUV 4 Door Hatchback 4 Door SUV 4 Door SUV Sedan Sedan Coupe Sedan 4 Door SUV 4 Door SUV 4 Door Hatchback 4 Door SUV Minivan Sedan 4 Door Hatchback Sedan Wagon Sedan Sedan Sedan Wagon 4 Door SUV Man 5 Auto 6 Man 5 Auto 4 Auto 4 Auto 5 Auto 4 Auto 5 Man 5 Auto 5 Auto 4 Auto 5 Auto 4 Auto 5 Auto 5 Auto 5 Auto 4 Auto 5 Auto 5 CVT Auto 4 Auto 5 Man 5 Man 6 Auto 6 Auto 6 Auto 5 Auto 5 Auto 6 Auto 5 Auto 6 Automobile features taken from a sample of 171 car models Source Berenson, Levine, Krehbiel Basic Business Statistics: Concepts and Applications (12 ed.), Pearson Variables Make/Model MPG Miles Per Gallon Length CargoWidth Cargo storage width in inches WheelBase Wheel base distance in inches CargoVol Volume of trunk space in cubic inches feet HP Horsepower Accto60 Time in seconds to accelerate to 60 miles per hour Breakfr60 Distance in feet to stop vehicle when applying the breaks at 60 miles per hour TrngCirc Distance in feet to turn the vehicle 360 degrees Origin 1=US 0=Asia or Europe TypeAuto Type of automobile Transmission Type of transmission Frequency Distribution for MPG bins Midpts. Frequency Percentage 9,9 -0 0,0% 13,9 12 7 4,1% 17,9 16 47 27,5% 21,9 20 61 35,7% 25,9 24 36 21,1% 29,9 28 14 8,2% 33,9 32 3 1,8% 37,9 36 2 1,2% 41,9 40 0 0,0% 45,9 44 1 0,6% Total 171 100,0% Percentage Polygon 45% 40% 35% 30% 25% 20% 15% 10% 5% 0% -- 12 16 20 24 28 32 36 40 Asia or Europe US 40 44
Projects on Regression Model Building To develop your project report (to be submitted for grade in hard copy) follow the steps below. 1. Create an introductory “scenario” of justtwo to three sentences that describes the data file for your project and why you (the ?????? Corporation/Group) are building a regression model to predict Y based on the set of possible independent variables X 1 , X 2, ..., X k 2. As you learned in class in Week 2, firstdevelop a simple linear regression model using one of the above predictors of Y . A. Cut and paste into your report the scatterplot and theMinitab Expressprintout for this simple linear regression model. B. Write the sample regression equation. C. Interpret the meaning of the Y intercept and slope for your fitted model. D. Interpret the meaning of the coefficient of determination r 2 . E. Interpret the meaning of the standard error of the estimate S YX . F. Obtain the residual plots andcut and paste them into the report. Brieflycomment on the appropriateness of your fitted model. (1) If the assumptions are met and the fitted model is appropriate continue to Step 2G. (2) If the linearity or normality assumptions are problematic state this but continue to Step 2G with caution. You do not need to check the assumption of independence in your project – that assumption is met. (3) If the equality of variance assumption appears to be seriously violatedcontact me. G. Comment on the statistical significance of your fitted model. (Note: Every team should have a fitted model that is statistically significant so contact me immediately if this is not so). H. Select a value for your independent variable in its relevant range: (1) Predict Yˆ . (2) Determine the 95% confidence interval estimate of the average value of Y for all occasions when the independent variable has the particular value you selected. (3) Determine the 95% prediction interval estimate of Y for an individual occasion when the independent variable has the particular value you selected. 3. As you learned in class in Weeks3and 4, you will be using the set of potentially meaningful numerical independent variables and one selected “two-category” dummy variable in your study to develop a “best” multiple regression model for predicting your numerical dependent variable Y . Follow the “9-step modeling process” described in the Powerpoints at the end of Module 4. A. Startwith a visual assessment of the possible relationships of your numerical dependent variable Y with each potential predictor variable by developing their respective scatter plots and paste these into your report. B. Then fit a preliminary multiple regression model using these potential numerical predictor variables and, at most, one categorical dummy variable. C. Then review Slides 6 through 16 of the Module 4 Powerpointsand assess collinearity until you are satisfied that you have a final set of possible predictors that are “independent,” i.e., not unduly correlated with each other. D. Use both stepwise regression approaches and best subsets regression approaches to fit a multiple regression model with this set of potentially meaningful numerical independent variables(and, if appropriate, the one selected categorical dummy variable). (1) Based on the stepwise modeling criterion determine which numerical independent variable or variables should be included in your regression model. (2) Based on the forward selection modeling criterion determine which numerical independent variable or variables should be included in your regression model. (3) Based on the backward elimination modeling criterion determine which numerical independent variable or variables should be included in your regression model. (4) Based on the adjusted r 2 criterion determine which numerical independent variable or variables should be included in your regression model. (5) Based on Minitab’s “predicted” r 2 criterion determine which numerical independent variable or variables should be included in your regression model. (6) Based on the smallest S YX criterion determine which numerical independent variable or variables should be included in your regression model. (7) Based on Mallows’ C p criterion determine which numerical independent variable or E. F. G. H. I. variables should be included in your regression model. Comment on the consistency of your findings in Step 3D (1)-(7). Cut and paste the Minitab Express printouts from Step 3D into your report. Based on Step 3D (along with the principle of parsimony if necessary) select a “best” multiple regression model. Using the predictor variables from your selected “best”multiple regression model, rerun the multiple regression model in order to assess its assumptions. Look at the set of residual plots, cut and pasted them into the report, and briefly comment on the appropriateness of your fitted model. (1) If the assumptions are met and the fitted model is appropriate continue to Step 3J. (2) If the linearity or normality assumptions are problematic state this but continue to Step 3J with caution. You do not need to check the assumption of independence in your project – that assumption is met. (3) If the equality of variance assumption is violated either transform the dependent variable Y to log Y or transform particular independent variables (discuss this with me) and rerun the multiple regression model as in Step 3H. J. Assess the significance of the overall fitted model. K. Assess the contribution of each predictor variable. 4. Write the sample multiple regression equation for the “final best” model you have developed. A. Interpret the meaning of the Y intercept and interpret the meaning of all the slopes for your fitted model (but do this in whatever units you used for Y to build the model). B. Interpret the meaning of the coefficient of multiple determination r 2 . C. Very briefly comment on how much r 2 has changed from the simple regression model in Step 2D to the “final” multiple regression model in Step 4B. D. Interpret the meaning of the standard error of the estimate S YX (in the units you used to build the model). E. Select one value for each of your independent variables in their respective relevant ranges: (1) Predict Yˆ . (If you used log Y take the antilog so you are back in units of Y). (2) Determine the 95% confidence interval estimate of the average value of Y for all occasions when the independent variables have the particular values you selected. (If your lower and upper boundaries are in units of log Y convert back to Y by taking the antilogs). (3) Determine the 95% prediction interval estimate of Y for an individual occasion when the independent variables have the particular values you selected. (If your lower and upper boundaries are in units of log Y convert back to Y by taking the antilogs). F. For your “final best” model, as per Module 1, prepare a brief descriptive analysis highlighting the key measures of central tendency, variation, and shape for your dependent variable Y and for each of the predictor variables. Show the individual histograms and boxplots for these variables. If a dummy variable was included as a predictor in your “final best” model show its summary table and bar chart. Specific instructions for the written team project report follows. Writing the Report Each team report has a title page followed by an Introduction section describing the study “scenario” and mentioning the possible predictor variables and the dependent variable. A section on the Simple Linear Regression Model is then followed by a section on the “final best” Multiple Regression Model. The final section of the report is a Discussion section assessing the gains (if any) by using the “best” multiple regression model in lieu of the simple linear regression model. All discussedMinitabExpress printouts should be “cut and pasted” into the report. These should be placed either in the body of the report or in an Appendix to the report. If the latter approach is taken, be sure to number and reference these printouts when discussing them in the body of the report.

Tutor Answer

(Top Tutor) Studypool Tutor
School: UCLA
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors