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. 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?StrataPrevious MICHFShockClinicianPrevious MI RateCHF RateShock RateProbabilityLength of Stay111 Smith0.250.1510.03754.52101Smith0.250.850.70.1487553100Smith0.250.850.30.0637544011Smith0.750.70.850.4462535010Smith0.750.70.150.0787556001Smith0.750.30.250.0562537000Smith0.750.30.750.1687548111Jones0.850.650.30.1657579110Jones0.850.650.70.38675510101Jones0.850.350.30.08925411100Jones0.850.350.70.20825312011Jones0.150.70.450.04725413010Jones0.150.70.550.05775514001Jones0.150.30.650.02925315000Jones0.150.30.350.015752 PreviousIIN25CHFCHFDr. Smith'sPracticePatterns15O70BP<9070BP-9085BP-90250O004.5 days5 days4 days3 days4 days2 days4 daysPreviousMI85CHFCHFDr. Jone'sPracticePatterns.BP<9065BP<90,7030BP-9045BP<90650O10007 days5 days4 days3 days4 days5 days3 days2 days

Strata Previous MI CHF Shock Clinician Previous MI Rate CHF Rate Shock Rate Probability Length of…

Answered: QL, Python, or Excel to analyze the…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

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. 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?

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

Previous
IIN
25
CHF
CHF
Dr. Smith's
Practice
Patterns
15
O
70
BP<90
70
BP-90
85
BP-90
25
0
O
0
0
4.5 days
5 days
4 days
3 days
4 days
2 days
4 days
Previous
MI
85
CHF
CHF
Dr. Jone's
Practice
Patterns.
BP<90
65
BP<90
,70
30
BP-90
45
BP<90
65
0
O
10
0
0
7 days
5 days
4 days
3 days
4 days
5 days
3 days
2 days

Expert Solution

Step 1

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.1488	5
3	1	0	0	Smith	0.25	0.85	0.3	0.0638	4
4	0	1	1	Smith	0.75	0.7	0.85	0.4463	3
5	0	1	0	Smith	0.75	0.7	0.15	0.0788	5
6	0	0	1	Smith	0.75	0.3	0.25	0.0563	3
7	0	0	0	Smith	0.75	0.3	0.75	0.1688	4
8	1	1	1	Jones	0.85	0.65	0.3	0.1658	7
9	1	1	0	Jones	0.85	0.65	0.7	0.3868	5
10	1	0	1	Jones	0.85	0.35	0.3	0.0893	4
11	1	0	0	Jones	0.85	0.35	0.7	0.2083	3
12	0	1	1	Jones	0.15	0.7	0.45	0.0473	4
13	0	1	0	Jones	0.15	0.7	0.55	0.0578	5
14	0	0	1	Jones	0.15	0.3	0.65	0.0293	3
15	0	0	0	Jones	0.15	0.3	0.35	0.0158	2