1. Suppose you, as a manager in a health insurance company, is choosing a cardiologic group for contract. One of the selection criteria is mortality rates. So you request the following mortality data from two competing cardiologic groups (Table 1) Table 1. Mortality Rates at Two Cardiac Groups Group 1 Group 2 Month Mortality Month Mortality Month (%) Mortality Month (%) Mortality (%%) 1 0.7 16 (/%) 3.2 5.8 16 3.3 0.9 17 3.3 2 3.7 17 3 3.5 1.1 18 3.5 3 4.2 18 4.8 1.8 19 4.0 4 2.0 19 3.5 2.1 20 4.0 4.5 20 6 1.7 2.3 21 4.5 6 5.2 21 7 4.0 2.6 22 4.3 7 4.4 22 3.8 8 2.8 23 4.4 8 4.2 23 9 4.6 2.8 24 4.6 9 3.0 24 10 4.2 3.0 25 5.1 10 4.9 25 11 4.1 3.3 26 5.0 11 3.1 26 12 2.8 3.4 27 5.1 12 4.1 27 13 5.6 3.3 28 5.5 13 4.9 28 3.4 14 3.5 29 5.6 14 2.8 29 15 3.4 3.3 30 5.9 15 4.4 30 1.0 a) Use Excel to: (1) construct histograms of mortality rates for both groups, including means and standard deviations and (2) create running charts of mortality rates for both groups. Show outputs (30 points). b) Which group do you choose for the contract? Elaborate on which tool, namely, histograms or running records, is more helpful in the selection (10 points).2. Several ER physicians complained that tum-around times for lab tests were \"out of control"= and were constandy getting worse. In order to test their theory= the following tumaround times in minutes were collected {Table 2). Use Excel to construct appropriate control charts (attach outputs} (20 points)