Question 1: In the following question, use SQL, Python, or Excel to analyze the data. Assume that we want to compare two clinicians, Smith and Jones, who see different types of patients at different rates and different length of stay. The data for each clinician is provided in the two decision trees in Figure 1.

• Download data, or copy paste data from belowData

Strata	Previous MI	CHF	Shock	Clinician	Previous MI Rate	CHF Rate	Shock Rate	Probability	Length of Stay
1	1	1		Smith	0.25	0.15	1	0.0375	4.5
2	1	0	1	Smith	0.25	0.85	0.7	0.14875	5
3	1	0	0	Smith	0.25	0.85	0.3	0.06375	4
4	0	1	1	Smith	0.75	0.7	0.85	0.44625	3
5	0	1	0	Smith	0.75	0.7	0.15	0.07875	5
6	0	0	1	Smith	0.75	0.3	0.25	0.05625	3
7	0	0	0	Smith	0.75	0.3	0.75	0.16875	4
8	1	1	1	Jones	0.85	0.65	0.3	0.16575	7
9	1	1	0	Jones	0.85	0.65	0.7	0.38675	5
10	1	0	1	Jones	0.85	0.35	0.3	0.08925	4
11	1	0	0	Jones	0.85	0.35	0.7	0.20825	3
12	0	1	1	Jones	0.15	0.7	0.45	0.04725	4
13	0	1	0	Jones	0.15	0.7	0.55	0.05775	5
14	0	0	1	Jones	0.15	0.3	0.65	0.02925	3
15	0	0	0	Jones	0.15	0.3	0.35	0.01575	2

Figure 1: Practice Patterns of Dr. Jones and Smith

• What is the expected length of stay for each of the clinicians?
• What is the expected length of stay for Dr. Smith if he were to take care of patients of Dr. Jones?
• What is the expected length of stay for Dr. Jones if he were to take of patients of Dr. Smith?