The datafile named Stroke will be used for this project. Use HwyMPG…

QuestionAnswered step-by-stepThe datafile named Stroke will be used for this project. Use HwyMPG…The datafile named Stroke will be used for this project. Use HwyMPG as the dependent variable. Start with a simple linear regression equation using one of the other variables as an independent variable. Test the model and report your findings with regards to whether the model can be established and how good it is in terms of fit.Add other variables to the model one by one until you get the best model. Then report your findings:What are your steps? Report what you do in each step. For example, in step 2, you have added another variable to the model. In another step, you have recoded a variable, etc.Report the comparisons of the key indicators from the model test results that are used to show whether adding a new variable to the model is good or not. Use a table to present these comparisons.What is your conclusion after doing the comparisons?STROKE DATARisk Age Blood Pressure Smoker12 57 152 No24 67 163 No13 58 155 No56 86 177 Yes28 59 196 No51 76 189 Yes18 56 155 Yes31 78 120 No37 80 135 Yes15 78 98 No22 71 152 No36 70 173 Yes15 67 135 Yes48 77 209 Yes15 60 199 No36 82 119 Yes8 66 166 No34 80 125 Yes3 62 117 No37 59 207 Yes FUEL DATA Car Class Displacement Fuel Type Hwy MPG1 Compact 3.1 P 252 Compact 3.1 P 253 Compact 3 P 254 Compact 3 P 255 Compact 3 P 256 Compact 3 P 257 Compact 2.4 P 258 Compact 3.5 P 259 Compact 3 P 2510 Compact 2.4 P 2411 Compact 2.8 P 2412 Compact 2.5 P 2413 Compact 3 P 2414 Compact 2.5 P 2415 Compact 2.4 R 2416 Compact 5.3 P 2417 Compact 6 P 2418 Compact 3.5 R 2419 Compact 3.5 R 2420 Compact 3.5 R 2421 Compact 3.5 R 2422 Compact 3.5 R 2423 Compact 3.8 R 2424 Compact 3.5 R 2425 Compact 3.5 P 2426 Compact 5.3 P 2427 Compact 4.6 P 2428 Compact 3.5 P 2429 Compact 4.2 P 2430 Compact 4.6 P 2431 Compact 4.6 P 2432 Compact 4.6 P 2433 Compact 3.5 P 2434 Compact 3.6 P 2435 Compact 3.2 P 2436 Compact 3.2 P 2437 Compact 3.5 R 2438 Compact 2.4 R 2439 Compact 3.5 R 2440 Compact 3.5 R 2441 Compact 3.2 P 2342 Compact 4.2 P 2343 Compact 4.8 P 2344 Compact 4.8 P 2345 Compact 3.5 P 2346 Compact 4.6 R 2347 Compact 4.6 R 2348 Compact 5.7 R 2349 Compact 5.7 R 2350 Compact 4.6 R 2351 Compact 4.6 R 2352 Compact 4.2 P 2353 Compact 4.2 P 2354 Compact 4.8 P 2355 Compact 3.5 P 2356 Compact 3 P 2357 Compact 4.4 P 2358 Compact 3 P 2259 Compact 3.9 R 2260 Compact 3.5 P 2261 Compact 4.2 P 2262 Compact 4.2 P 2263 Compact 4.6 R 2264 Compact 4.6 R 2265 Compact 3.5 R 2266 Compact 5.7 R 2267 Compact 5.7 R 2268 Compact 3.5 R 2269 Compact 4.8 P 2270 Compact 3 P 2271 Compact 4.2 P 2272 Compact 5 P 2273 Compact 3.5 P 2274 Compact 5.5 P 2275 Compact 4.2 P 2176 Compact 5.5 P 2177 Compact 5.5 P 2178 Compact 4.5 P 2179 Compact 5.5 P 2180 Compact 4.6 P 2181 Compact 4.2 P 2082 Compact 4.2 P 2083 Compact 6 P 2084 Compact 4.5 P 2085 Compact 5.5 P 2086 Compact 6 P 1987 Compact 5.2 P 1988 Compact 5.2 P 1989 Compact 4.4 P 1990 Compact 5.5 P 1991 Compact 6.2 P 1992 Compact 6.2 P 1893 Compact 6.2 P 1894 Compact 6.1 P 1895 Compact 6.1 P 1896 Compact 4.6 R 1897 Compact 4.6 R 1898 Compact 6.1 P 1899 Compact 5.5 P 17100 Compact 5.5 P 17101 Compact 6.2 P 17102 Compact 6 P 17103 Compact 5.5 P 17104 Compact 5 P 17105 Compact 5 P 17106 Compact 5.5 P 16107 Compact 6 P 16108 Compact 5.5 P 16109 Compact 6 P 16110 Compact 5.7 P 16111 Compact 5.7 P 15112 Midsize 1.8 R 37113 Midsize 2 R 35114 Midsize 1.6 R 35115 Midsize 1.8 R 35116 Midsize 1.6 R 34117 Midsize 2.4 R 34118 Midsize 2 R 33119 Midsize 1.6 R 33120 Midsize 2 R 33121 Midsize 2 R 33122 Midsize 1.8 R 33123 Midsize 2.5 R 33124 Midsize 2 R 33125 Midsize 1.6 R 32126 Midsize 1.6 R 32127 Midsize 1.6 R 32128 Midsize 2 R 32129 Midsize 2.4 R 32130 Midsize 2 R 32131 Midsize 1.8 R 32132 Midsize 2.5 R 32133 Midsize 2.4 R 32134 Midsize 2 P 31135 Midsize 2.4 R 31136 Midsize 2 R 31137 Midsize 2 R 31138 Midsize 2.4 R 31139 Midsize 2.4 R 31140 Midsize 2.4 R 31141 Midsize 2.4 R 31142 Midsize 2.4 R 31143 Midsize 2.2 R 31144 Midsize 2.4 R 31145 Midsize 2.4 R 31146 Midsize 2.5 R 31147 Midsize 1.8 R 31148 Midsize 2 R 31149 Midsize 2.4 R 31150 Midsize 2.4 R 31151 Midsize 2 P 30152 Midsize 2.4 R 30153 Midsize 2.4 R 30154 Midsize 2 R 30155 Midsize 2.4 R 30156 Midsize 2.4 R 30157 Midsize 2.4 R 30158 Midsize 2.4 R 30159 Midsize 2 R 30160 Midsize 2.5 R 30161 Midsize 2.4 R 30162 Midsize 2 P 29163 Midsize 2 P 29164 Midsize 2 P 29165 Midsize 2 P 29166 Midsize 2 P 29167 Midsize 2.3 R 29168 Midsize 2.3 R 29169 Midsize 2 R 29170 Midsize 2 R 29171 Midsize 3.5 R 29172 Midsize 2.5 R 29173 Midsize 2.5 R 29174 Midsize 2.5 R 29175 Midsize 2.5 R 29176 Midsize 3.5 R 29177 Midsize 3.5 R 29178 Midsize 3.5 R 29179 Midsize 2.5 P 29180 Midsize 2 P 29181 Midsize 3.5 R 29182 Midsize 1.8 R 29183 Midsize 2.4 R 29184 Midsize 2.3 R 29185 Midsize 2.3 R 29186 Midsize 2.3 R 29187 Midsize 3.5 R 29188 Midsize 2.4 P 28189 Midsize 2.4 P 28190 Midsize 2 P 28191 Midsize 3 P 28192 Midsize 3 P 28193 Midsize 2.5 P 28194 Midsize 2.5 P 28195 Midsize 2.4 P 28196 Midsize 2.4 P 28197 Midsize 2.4 P 28198 Midsize 2.4 P 28199 Midsize 3.5 R 28200 Midsize 2 R 28201 Midsize 2 R 28202 Midsize 2 R 28203 Midsize 2 R 28204 Midsize 3.9 R 28205 Midsize 3.5 R 28206 Midsize 3.3 R 28207 Midsize 3.5 R 28208 Midsize 3.5 R 28209 Midsize 3 P 28210 Midsize 2.3 P 28211 Midsize 2 P 28212 Midsize 3.8 R 28213 Midsize 3.5 R 28214 Midsize 2.3 R 28215 Midsize 2.7 R 28216 Midsize 2.3 R 28217 Midsize 3.5 R 28218 Midsize 2.3 R 28219 Midsize 3.8 R 28220 Midsize 3.5 R 28221 Midsize 2 P 27222 Midsize 3.1 P 27223 Midsize 2.5 P 27224 Midsize 2.5 P 27225 Midsize 2.5 P 27226 Midsize 2.5 P 27227 Midsize 2.5 R 27228 Midsize 2.5 R 27229 Midsize 2.5 R 27230 Midsize 2.5 R 27231 Midsize 3.3 R 27232 Midsize 3.5 P 27233 Midsize 3.1 P 27234 Midsize 3 P 27235 Midsize 3.5 P 27236 Midsize 3.5 P 27237 Midsize 3.5 P 27238 Midsize 2.7 R 27239 Midsize 2.7 R 27240 Midsize 2.7 R 27241 Midsize 2 R 27242 Midsize 2.7 R 27243 Midsize 2.4 R 27244 Midsize 3 R 26245 Midsize 3 R 26246 Midsize 3.6 R 26247 Large 3 P 26248 Large 3 P 26249 Large 3 P 26250 Large 2 P 26251 Large 2.8 P 26252 Large 2.5 P 26253 Large 2.5 P 26254 Large 2.5 P 26255 Large 2.4 P 26256 Large 2.4 P 26257 Large 2.4 R 26258 Large 3.5 R 26259 Large 3.6 R 26260 Large 3.3 R 26261 Large 2.7 R 26262 Large 2.7 R 26263 Large 3.8 R 26264 Large 3.3 R 26265 Large 3.2 P 26266 Large 3.5 P 26267 Large 3 P 26268 Large 3 P 26269 Large 3 P 26270 Large 2.3 P 26271 Large 3.5 P 26272 Large 2.3 P 26273 Large 3.6 P 26274 Large 3.6 R 26275 Large 3.6 R 26276 Large 3.6 R 26277 Large 3.6 R 26278 Large 3.6 R 26279 Large 3.6 R 26280 Large 3.5 R 26281 Large 3.5 R 26282 Large 3 P 25283 Large 3.5 P 25284 Large 2.5 P 25285 Large 2.5 P 25286 Large 2.5 P 25287 Large 2.5 P 25288 Large 3.5 R 25289 Large 4.2 P 25290 Large 4.2 P 25291 Large 4.2 P 25292 Large 3.8 R 25293 Large 3.1 P 25294 Large 3 P 25295 Large 3 P 25296 Large 3 P 25297 Large 3 P 25298 Large 3.5 P 25299 Large 3.5 P 25300 Large 3.8 P 25301 Large 3.5 P 25302 Large 5.3 P 25303 Large 3.6 R 25304 Large 3.6 R 25305 Large 3.6 R 25306 Large 3.6 R 25307 Large 2.4 R 25308 Large 3 R 25309 Large 3 R 25310 Large 3 R 25311 Large 3 R 25USE EXCELEngineering & TechnologyComputer ScienceBUS 345Share Question