12. Carry out the benefit-cost analysis of the CDC recommended funding presented in section 7 following exactly the procedure described therin. You will have to use EXCEL extensively to carry out this part of the project. What I need from you are: (i) reproduction of tables 4 and 5: (ii) an analysis of the results.

TABLE 4 Total Costs and Benefits under Various Levels of Control Funding (Fixed Effects Model Additional Average Pack Medical Cost Medicaid Cost Total Cost Funding in a Predicted Per-Capita Packs Reduction in a Avoided Productivity Cost Avoided Avoided State in 2008 Reduction in a State in State in 2008 (Million Avoided (Million (Million (Million Million Dollar 2008 Million Dollar) Dollar) Dollar) Dollars) 0.19 1.4 7 6.8 2.1 15.9 10 1.9 14 68.8 66.8 21.1 157 20 3.75 27.5 135 132 42 309 50 8.97 65.1 324 314 99 737 59.832 10.57 76.5 382 371 117 869TABLE 5 Summary of Aggregate Benefits in a State and the Benefit-Cost Ratios Total Cost Avoided (Million Dollars) Benefit-Cost Ratios Additional Pooled Fixed Random Pooled Fixed Random Funding in Model Effects Effects Model Effects Effects 2008 (Million Dollar) Tax-based specification 1 19.7 15.9 15.6 19.7 159 15.6 10 184 157 154 194 15.7 154 20 380 309 303 19 154 15.1 50 898 737 724 179 147 145 59.832 1,055 869 853 17.6 145 143 Price-based specification 1 20.2 17.1 16.9 202 17.2 16.9 10 199 169 167 19.9 169 16.7 20 389 333 329 19.5 166 16.4 50 919 792 783 184 158 15.7 59.832 1,079 932 22 18 15.6 15.4