PLEASE!!!

respond back with 2 hours prior max please.

Question 7.

Question 8.

Question 9.

Question 10.

Question 11.

AutoSave Off 12 Linear Regression Project 1 Public Transportation Data - Excel Search File Home Insert Page Layout Formulas Data Review View Help X Cut Calibri 11 2 Wrap Text General In Copy AA = A Paste BIU Merge & Center $ % & Format Painter Clipboard Conditional Format as Formatting Table Styles Font Alignment 5 Number V24 F G A 8 D F 1 State Total EARNINGS # Take Public transportation to Work Estimate Total population Percent bachelor's degree or higher 2 Alabama 2041239 7234 4874747 25.5 3 Alaska 351170 5827 739795 28.8 4 Arizona 3085938 55495 7016270 29.4 5 Arkansas 1281618 3788 3004279 23.4 6 Colorado 2886640 92878 5607154 41.2 7 Connecticut 1777540 83460 3588184 38.7 8 Delaware 430766 9598 961939 31.5 9 District of Columbia 375380 122643 693972 57.3 10 Georgia 4782201 102295 10429379 30.9 11 Hawaii 703870 43263 1427538 32.9 12 Idaho 773880 4859 1716943 26.8 13 illinois 6127845 588347 12802023 34.4 14 Indiana 3125799 29104 6666818 26.8 15 lowa 1597375 13667 3145711 28.9 16 Kansas 1430796 6101 2913123 33.7 17 Kentucky 1948441 20508 4454189 24 18 Louisiana 2003357 21422 4684333 23.8 19 Maine 657950 3819 1335907 32.1 20 Maryland 3061096 259404 6052177 39.7 21 Massachusetts 3525476 366993 6859819 22 Michigan 4560003 58769 9962311 29.1 23 Minnesota 2908313 106880 5576606 36.1 24 Mississippi 1214800 3718 2984100 21.9 25 Missouri 2881331 36897 6113532 29.1 26 Montana 508488 3997 1050493 323 27 Nebraska 998440 6867 1920076 31.7 28 Nevada 1402285 43262 2998039 24.9 29. New Hampshire 712654 5162 1342795 36.9 Data 30 New Jersey 31 New Mexico 32 North Carolina 33 North Dakota 34 Ohio 35 Oklahoma 36 Oregon 37 Pennsylvania 38 Puerto Rico 39 Rhode Island 40 South Carolina 41 South Dakota 42 Tennessee 43 Utah 44 Vermont 45 Virginia 46 Washington 47 West Virginia 48. Wisconsin 49. Wyoming Data 4408674 866256 4779298 405139 5475631 1744188 1952784 6055758 978691 522191 2259936 436325 3078781 1486478 318995 4194901 3565727 711923 2938545 279085 521066 9231 46327 2137 79760 5737 87100 323271 17286 11452 11198 2956 19744 34465 4782 175257 233203 6552 51446 1651 9005614 2088070 10273419 755393 11658609 3930864 4142776 12805537 3337177 1059639 5024369 869666 6715984 3101833 623657 8420020 7405743 1815857 5795483 579315 39.7 27.1 31.3 30.7 28 25.5 33.7 31.4 33.5 28 28.1 27.3 34.6 38.3 38.7 35.5 20.2 30.4 27.6 25,7 Question 7 (1 point) 4Listen Using only the R^2 to choose a model, which independent variable would you use to predict how many people take public transportation to work? Total Earnings in the Past 12 Months % Bachelor's Degree or Higher Total Population none of the above Question 8 (1 point) Listen Let's use the model for its intended purpose - to make predictions. Using the % with a Bachelor's Degree or Higher as the independent variable, what should you expect the average number that take public transportation to work to be with a 28.7 % with a Bachelor's Degree or Higher? Enter your response to one decimal place. For example, if your answer is 85.23794, enter 85.2 Your Answer: Answer Question 9 (1 point) Listen Let's use the model for its intended purpose - to make predictions. Using the Total Population Estimate as the independent variable, what should you expect the average number that take public transportation to work to be with a Total Population Estimate of 2105000? Enter your response to one decimal place. For example, if your answer is 85.23794, enter 85.2 Your Answer: Answer Question 10 (1 point) Listen Let's use the model for its intended purpose - to make predictions. Using the Earnings in the Past 12 months as the independent variable, what should you expect the average number that take public transportation to work to be with if Earnings in the Past 12 months were 3105000 ? Enter your response to one decimal place. For example, if your answer is 85.23794, enter 85.2 Your Answer: Answer Question 11 (1 point) Listen Let's use the model for its intended purpose - to make predictions. Using the % with a Bachelor's Degree or Higher as the independent variable, what should you expect the average number that take public transportation to work to be with a 43.5% with a Bachelor's Degree or Higher? Enter your response to one decimal place. For example, if your answer is 85.23794, enter 85.2 Your