Question

Use Excel or other statistics application program for the following two problems.

1. Physician burnout is a serious problem and you have the impression that morale among the physicians at your facility is at a low point. You administer a survey to get some quantitative data, as well as some suggestions for improvement. One of the most common suggestions is that hiring physician extenders (PAs, scribes, or other extenders) would improve things. Your supervisor gives you permission to hire some physician extenders, but wants to know if the investment achieves significant results. You decide to administer a second survey six months following the hiring of physician extenders and will do a t-test to see if there’s a significant change in the survey results compared to the results from the survey prior to the hiring.

Here is the data, from the two surveys:

Physician number Survey #1 average score (out of 10) Survey #2 average score (out of 10)

01 7.2 7.5

02 6.5 6.7

03 5.5 4.8

04 5.5 6.4

05 6.8 7.4

06 8.0 9.0

07 8.3 7.8

08 4.3 5.5

09 7.1 8.0

10 6.6 7.1

11 4.5 5.0

12 7.9 7.4

13 4.6 5.3

14 6.5 6.0

15 5.8 6.5

This is an example of using a paired samples (repeated samples) t-test. In Excel, the “type” parameter for the paired samples t-test is ‘1’. Since we don’t know if the new hiring will improve or worsen the survey results (you never know … the new hires could make things more difficult), this will be a two-tailed t-test. The “tails” parameter in Excel is ‘2’.

Note: The result that Excel displays when you run the t-test is the p-value. You don’t have to do anything else. It may just be a single value that Excel displays, or it may appear in a table of values and labeled ‘P (T<=t) two tail’. If Excel displays a table of values it also will include the t-statistic and the t-critical value. You don’t have to go to a table of critical values to find it.

a. Using Excel, determine whether there has been a significant change in the survey results. Copy and paste your Excel data and result. (Just copy and paste the portion of the Excel page that has your work on it; do not copy and paste the entire Excel page … they’re huge!) (10)

b. What is your conclusion about the effect of hiring physician extenders? (5)

A B С D E Physician number Survey Survey #1 #2 average average score (out score (out of 10) of 10) 1 2. 7.2 7.5 1 2 3 4 3 6.5 5.5 5.5 6.7 4.8 6.4 7.4 un 4 6 6 8 7 8 9 5 6 7 8 8 8 دنیا 7 8 9 3 10 9 1 5.5 8 7.1 8 11 1 6 10 11 12 U 4.3 7.1 6.6 4.5 7.9 4.6 6.5 5.8 13 12 1 7.4 4 الزرا 15 13 141 15 6 16 6.5 17

Answer 1

Answer a.

Null Hypothesis, Ho: There is no significant difference in the mean survey result score i.e.
D= =0

Alternative Hypothesis, Ha: There is significant difference in the mean survey result score i.e.
0 +al

T-Test:

t-Test: Paired Two Sample for Means 1 Physician No. Survey 1 Score Survey 2 Score 7.2 7.5 2 6.5 6.7 3 5.5 4.8 4 5.5 6.4 5 6.8 7.4 6 8 9 7 8.3 7.8 8 4.3 5.5 9 7.1 8 Survey 2 Score Survey 1 Score 6.693333333 6.34 1.46352381 1.639714286 15 15 0.87718221 0 Mean Variance Observations Pearson Correlation Hypothesized Mean Difference df t Stat P(T<=t) one-tail t Critical one-tail P(T<=t) two-tail t Critical two-tail 14 10 6.6 4.5 11 7.1 5 7.4 2.203964717 0.022383147 1.761310136 0.044766293 2.144786688 12 7.9 13 4.6 5.3 14 6.5 6 15 5.8 6.5

Here, two tailed test - statistics, t = 2.204 and two - tailed p-value = 0.0448

Answer b.

Conclusion: Since p-value = 0.0448 < 0.05 so we Reject the Null Hypothesis at 5% level of significance and conclude that There is significant difference in the mean survey result score i.e.
0 +al

We were unable to transcribe this image

We were unable to transcribe this image

t-Test: Paired Two Sample for Means 1 Physician No. Survey 1 Score Survey 2 Score 7.2 7.5 2 6.5 6.7 3 5.5 4.8 4 5.5 6.4 5 6.8 7.4 6 8 9 7 8.3 7.8 8 4.3 5.5 9 7.1 8 Survey 2 Score Survey 1 Score 6.693333333 6.34 1.46352381 1.639714286 15 15 0.87718221 0 Mean Variance Observations Pearson Correlation Hypothesized Mean Difference df t Stat P(T<=t) one-tail t Critical one-tail P(T<=t) two-tail t Critical two-tail 14 10 6.6 4.5 11 7.1 5 7.4 2.203964717 0.022383147 1.761310136 0.044766293 2.144786688 12 7.9 13 4.6 5.3 14 6.5 6 15 5.8 6.5

We were unable to transcribe this image