Question 1: Are the longer wait times correlated to the increase in Medicaid patients and does the increase in Medicaid patients increase the cost of ER medicine?

The multiple regression model will demonstrate the relationship between emergency visits (X) and the amount of wait time in the emergency room (Y). Our second variable will be Medicaid patients (Y) and our third variable is the cost of ER medicine (Y).

Q1 1028 558 1586 2014 Q2 840 989 1829 Blue Cross Commercial PPO/Managed Care Medicare HMO Client/HMO Other Gov't N/A ERROR Medicare VIP-Other Self Pay Workers Comp TOTAL 399 142 181 596 74 88 130 1623 1 828 51 5699 438 121 186 562 102 113 86 1444 4 843 46 5774 5753 460 126 205 612 91 134 143 1559 9 760 52 6067 Medicaid by ER Level ESI 1 ESI 2 ESI 3 ESI 4 ESI 5 Q1 1 42 545 796 171 1555 Q2 4 79 656 873 197 1809 Q3 2 110 712 942 142 1908 Q4 0 128 702 950 114 1894 Q1 1 131 694 873 85 1784 Q2 2 134 720 955 48 1859 Total 10 624 4029 5389 757 10809 Q1 230 3.83 Q2 196 3.27 Q3 229 Q4 231 3.85 Q1 233 3.88 Q2 216 3.60 Total 1335 ED Visits By Payor Medicaid Medicaid HMO TOTAL ER Throughput (mins) Arrival/Departure Q3 592 1340 1932 449 98 180 509 134 137 97 1374 7 789 47 3.82 Q4 544 1372 1916 2015 Q1 517 1296 1813 Q2 470 1424 1894 Total 3991 6979 10970 455 94 176 713 129 133 97 1613 5 639 86 5953 500 92 208 663 130 153 121 1409 23 757 55 6005 2701 673 1136 3655 660 758 674 9022 49 4616 337 35251 Resuscitation Emergent Urgent Less Urgent Nonurgent