Question
6.6 You notice that southern states tend to have higher coronavirus hospitalizations per million. Make a variable called South that is equal to 1 in
6.6
You notice that southern states tend to have higher coronavirus hospitalizations per million.
Make a variable called "South" that is equal to 1 in Alabama, Arkansas, Florida, Georgia, Kentucky, Louisiana, Mississippi, Missouri, North Carolina, South Carolina, Tennessee, Texas and Virginia; and is equal to 0 in every other state.
Now run a multiple regression with coronavirus hospitalizations per million people as the dependent variable, and all three of your other variables as independent variables.
Holding vaccinations per 1000 people and population density constant, how much higher are hospitalizations per million people in the southern states relative to other states on average?
Round your answer to the nearest whole number.
State Hospitalizations per million Vaccinations per 1000 Population Density Alabama 100.639263 165.2914332 96.9221 Alaska 44.95900556 306.9187822 1.2863 Arizona 130.5144383 207.9908176 64.955 Arkansas 110.2336658 211.3676247 58.403 California 107.4429091 189.5271383 256.3727 Colorado 55.76914721 190.6155237 56.4011 Connecticut 120.1208955 229.3593431 735.8689 Delaware 105.809878 181.5087064 504.3073 Florida 150.3661281 192.0937062 410.1256 Georgia 187.0332494 174.5912536 186.6719 Hawaii 19.11251395 235.7471967 219.9419 Idaho 82.13975148 183.028175 22.0969 Illinois 90.1286462 181.2461798 228.0243 Indiana 97.25212346 193.9234027 188.281 lowa 52.51821706 180.8328006 56.9284 Kansas 80.74610778 169.4173601 35.5968 Kentucky 124.0084877 182.5384937 113.9566 Louisiana 114.5272179 186.6401848 107.5175 Maine 49.78488471 195.9325006 43.6336 Maryland 134.4705575 184.3948069 626.6731 Massachusetts 95.31867757 205.2246962 894.4355 Michigan 86.2117969 203.3182781 177.6655 Minnesota 39.29362 194.0585591 71.5922 Mississippi 140.1684698 173.5727237 63.7056 Missouri 154.7995144 168.8449363 89.7453 Montana 57.97053441 203.4259666 7.4668 Nebraska 70.16393778 186.5628377 25.4161 Nevada 127.0839053 185.7523972 28.5993 New Hampshire 49.58993499 185.1958 153.1605 New Jersey 200.5242725 196.0679786 1215.1991 New Mexico 80.60515873 278.6243704 17.285 North Carolina 111.1020856 201.9419401 218.2702 North Dakota 30.19470332 231.0170495 11.0393 Ohio 69.80093285 180.1016438 287.5038 Oklahoma 87.48815686 218.3883923 57.6547 Oregon 36.73488272 195.5400132 44.8086 Pennsylvania 123.7824742 178.0716578 286.5449 Rhode Island 133.5023732 186.0748503 1021.4323 South Carolina 111.1304112 186.1476614 173.3174 South Dakota 79.73183526 234.5666298 11.9116 Tennessee 123.3766761 146.9152351 167.2748 Texas 160.1843358 149.8316639 112.8204 Utah 64.592496 178.1991186 39.943 Vermont 49.35826297 210.0385154 68.1416 Virginia 130.6483835 202.821124 218.4403 Washington 55.27699739 183.2402965 117.3272 West Virginia 100.6709522 233.5672949 73.9691 Wisconsin 42.55134443 208.4961193 108.0497 Wyoming 37.03540408 232.6987346 5.84Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started