question a in the following question analyze the data assume that we have followed two clinicians smith and jones and constructed the decision trees in figure 1 1
Question A: In the following question analyze the data.Assume that we have followed two clinicians, Smith and Jones, and constructed the decision trees in Figure 1.
Use the followingdata
Figure 1:Practice Patterns of Dr. Jones and Smith
1.What is the expected length of stay for each of the clinicians?
2.What is the expected length of stay for Dr. Smith if he were to take care of patients of Dr. Jones?
3.What is the expected length of stay for Dr. Jones if he were to take of patients of Dr. Smith?
Question B: The following data report length of stay (LOS) for 10 patients of Dr. Jones and 10 patients of Dr. Smith. What is the expected outcome (average outcome) for Dr. Smith? What is the expected outcomes if Dr. Jones if he was seeing Dr. Smith’s patients? To answer this question, replace each outcome of Dr. Jones with average outcome of same type of patient seen by Dr. Smith. Is Dr. Smith more efficient than Dr. Jones?
|
Dr. Smith |
||||
|
Patient |
Previous MI |
CHF |
Shock |
LOS |
|
1 |
1 |
1 |
0 |
4 |
|
2 |
1 |
1 |
0 |
5 |
|
3 |
1 |
0 |
0 |
4 |
|
4 |
1 |
0 |
1 |
5 |
|
5 |
1 |
0 |
1 |
4 |
|
6 |
1 |
0 |
1 |
4 |
|
7 |
1 |
0 |
1 |
5 |
|
8 |
0 |
0 |
0 |
2 |
|
9 |
0 |
0 |
0 |
2 |
|
10 |
0 |
0 |
0 |
1 |
|
Dr. Jones |
||||
|
Patient |
Previous MI |
CHF |
Shock |
LOS |
|
1 |
1 |
1 |
0 |
5 |
|
2 |
1 |
1 |
0 |
5 |
|
3 |
1 |
1 |
0 |
5 |
|
4 |
1 |
1 |
1 |
5 |
|
5 |
1 |
0 |
1 |
5 |
|
6 |
1 |
0 |
1 |
5 |
|
7 |
1 |
0 |
1 |
5 |
|
8 |
1 |
0 |
0 |
4 |
|
9 |
0 |
0 |
0 |
2 |
|
10 |
0 |
0 |
0 |
2 |
Question C: In data presented in question B, what is the expected outcome if Dr. Smith sees patients of Dr. Jones?Note that Dr. Smith does not see any patient like patient 4 of Dr. Jones.We need to estimate a synthetic control for this patient.To do so, filter the data for patients of Dr. Smith (this is already done since the data of Dr. Smith is presented separately).Regress length of stay on previous MI, CHF, and Shock.You learned about regression in the first part of this course. Evaluate the regression equation at values corresponding to the condition of patient 8 of Dr. Jones.Use the regression prediction of length of stay to create a synthetic patient for Dr. Smith and calculate the expected outcome for Dr. Smith seeing patients of Dr. Jones.
Instructions
In order to complete this assignment, you must submit an Excel file with each question answered in a separate sheet.Copy both the question prompts and your answers to the file.All calculations should be done by formulas and not as fixed values.
