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 below Data length Previous Previous CHF |Shock of Strat MI CHF Shock Clinician MI Rate Rate Rate Probability Stay 1 1 Smith 0.25 0.15 0.0375 1 0 1 Smith 0.25 0.85 0.7 0.14875 3 1 0 0 Smith 0.25 0.85 0.06375 0 1 1 Smith 0.75 0.7 0.85 0.44625 5 0 1 0 Smith 0.75 0.7 D.15 0.07875 0 0 1 Smith 0.75 0.3 0.25 0.05625 7 0 0 Smith 0.75 0.3 0.75 0.16875 1 1 1 lone 0.85 0.65 0.3 0.16575 1 1 0 Jones 0.85 0.65 0.7 0.38675 10 1 0 1 Jones 0.85 0.35 0.3 0.08925 1 1 1 0 0 Jones 0.85 0.35 0.7 0.20825 12 1 1 Jones 0.15 0.7 0.45 0.04725 1 Jones 0.15 0.7 0.55 0.05775 14 0 0 1 Jones 0.15 0.3 0.65 0.02925 0 0 Jones 0.15 0.3 0.35 0.01575 7 days 4 5 days CHE 5 days 5 days 4 days Previcess Previous AN 4 days 3 days 3 des 4 days dBY5 5 days 2 days Or. Smith's 3 days 135 Dr Jone's Practice 65 Practice Patterns Patterns 2 days 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