The health data is related to death rate based on; doctor availability, hospital availability, annual per capita income, and population density people per square mile. Please fine the related dataset Health Data in order to answer to following questions.

a. Develop a scatter diagram with the doctor availability as the independent variable.

b. What does the scatter diagram developed in part (a) indicate about the relationship c. between the two variables? d. Develop a scatter diagram with the hospital availability as the independent variable. Explain the relationship. e. Determine the estimated regression equation that can be used to predict the death rate using the hospital availability as the independent variable. f. Determine the estimated regression equation that can be used to predict the death rate using both and the doctor availability.

g. Determine the estimated regression equation that can be used to predict the death rate using the doctor availability, the hospital availability, and the population density people per square mile.

h. Predict the death rate by considering the doctor availability of 75, and the hospital availability of 850.

B death rate per doctor availability per hospital availability per annual per capita income in 1000 residents 100,000 100,000 residents thousands of dollars E population density people per square mile 1 2 3 78 68 70 96 109 144 113 97 4 284 433 739 1792 477 5 6 11 74 111 7 8 77 168 362 671 636 329 206 124 152 162 150 9 10 82 11 12 89 149 60 13 634 631 257 284 603 14 15 16 96 83 ||| ||| 134 292 108 111 182 129 158 186 177 127 130 686 17 18 19 20 21 179 80 22 345 1357 544 205 1264 688 354 1632 348 370 648 23 24 25 8 9.300000191 7.5 8.899999619 10.19999981 8.300000191 8.800000191 8.800000191 10.69999981 11.69999981 8.5 8.300000191 8.199999809 7.900000095 10.30000019 7.400000095 9.600000381 9.300000191 10.60000038 9.699999809 11.60000038 8.100000381 9.800000191 7.400000095 9.399999619 11.19999981 9.100000381 10.5 11.89999962 8.399999619 5 9.800000191 9.800000191 10.80000019 10.10000038 10.89999962 9.199999809 8.300000191 7.300000191 9.399999619 9.399999619 9.800000191 3.599999905 8.399999619 10.80000019 10.10000038 9 10 11.30000019 11.30000019 26 27 145 112 131 80 130 140 154 118 94 119 153 116 97 176 75 134 161 111 114 142 9.100000381 8.699999809 7.199999809 8.899999619 8.300000191 10.89999962 10 9.100000381 8.699999809 7.599999905 10.80000019 9.5 8.800000191 9.5 8.699999809 11.19999981 9.699999809 9.600000381 9.100000381 9.199999809 8.300000191 8.399999619 9.399999619 9.800000191 10.39999962 9.899999619 9.199999809 10.30000019 8.899999619 9.600000381 10.30000019 10.39999962 9.699999809 9.600000381 10.69999981 10.30000019 10.69999981 9.600000381 10.5 7.699999809 10.19999981 9.899999619 8.399999619 10.39999962 9.199999809 13 8.800000191 9.199999809 7.800000191 8.199999809 103 101 117 88 78 102 95 366 540 28 29 30 31 680 345 525 32 33 80 92 126 108 77 60 34 35 870 669 452 430 822 36 37 38 71 86 93 238 78 196 125 82 39 40 41 42 43 44 190 867 969 499 925 353 288 106 162 95 91 125 129 84 45 46 47 52 110 69 57 106 40 50 183 119 180 82 71 118 121 48 49 50 718 540 668 347 345 463 728 35 86 51 52 B death rate per doctor availability per hospital availability per annual per capita income in 1000 residents 100,000 100,000 residents thousands of dollars E population density people per square mile 1 2 3 78 68 70 96 109 144 113 97 4 284 433 739 1792 477 5 6 11 74 111 7 8 77 168 362 671 636 329 206 124 152 162 150 9 10 82 11 12 89 149 60 13 634 631 257 284 603 14 15 16 96 83 ||| ||| 134 292 108 111 182 129 158 186 177 127 130 686 17 18 19 20 21 179 80 22 345 1357 544 205 1264 688 354 1632 348 370 648 23 24 25 8 9.300000191 7.5 8.899999619 10.19999981 8.300000191 8.800000191 8.800000191 10.69999981 11.69999981 8.5 8.300000191 8.199999809 7.900000095 10.30000019 7.400000095 9.600000381 9.300000191 10.60000038 9.699999809 11.60000038 8.100000381 9.800000191 7.400000095 9.399999619 11.19999981 9.100000381 10.5 11.89999962 8.399999619 5 9.800000191 9.800000191 10.80000019 10.10000038 10.89999962 9.199999809 8.300000191 7.300000191 9.399999619 9.399999619 9.800000191 3.599999905 8.399999619 10.80000019 10.10000038 9 10 11.30000019 11.30000019 26 27 145 112 131 80 130 140 154 118 94 119 153 116 97 176 75 134 161 111 114 142 9.100000381 8.699999809 7.199999809 8.899999619 8.300000191 10.89999962 10 9.100000381 8.699999809 7.599999905 10.80000019 9.5 8.800000191 9.5 8.699999809 11.19999981 9.699999809 9.600000381 9.100000381 9.199999809 8.300000191 8.399999619 9.399999619 9.800000191 10.39999962 9.899999619 9.199999809 10.30000019 8.899999619 9.600000381 10.30000019 10.39999962 9.699999809 9.600000381 10.69999981 10.30000019 10.69999981 9.600000381 10.5 7.699999809 10.19999981 9.899999619 8.399999619 10.39999962 9.199999809 13 8.800000191 9.199999809 7.800000191 8.199999809 103 101 117 88 78 102 95 366 540 28 29 30 31 680 345 525 32 33 80 92 126 108 77 60 34 35 870 669 452 430 822 36 37 38 71 86 93 238 78 196 125 82 39 40 41 42 43 44 190 867 969 499 925 353 288 106 162 95 91 125 129 84 45 46 47 52 110 69 57 106 40 50 183 119 180 82 71 118 121 48 49 50 718 540 668 347 345 463 728 35 86 51 52