# Health Care Management

Health Care Management

5.4 End-of-Chapter Practice Problems

1. Suppose that a hospital administrator wanted to know if the average length of

stay (LOS) of women after childbirth was different for women who were

privately-insured commercially and women who were under Medicaid. The

administrator decides to take a random sample of these two types of women

who had a childbirth in the past 6 months and to separate the sample into women

who were privately-insured commercially and women who were under Medic-

aid. You want to test your Excel skills on a small sample of data, and the

hypothetical data appear in Fig. 5.18.

(a) State the null hypothesis and the research hypothesis on an Excel

(b) Find the standard error of the difference between the means using Excel

(c) Find the critical t value using Appendix E, and enter it on your spreadsheet.

(d) Perform a t-test using Excel. What is the value of t that you obtain?

Use three decimal places for all figures in the formula section of your spreadsheet.

Fig. 5.18 Worksheet Data for Chap. 5: Practice Problem #1

112 5 Two-Group t-Test of the Difference of the Means for Independent Groups

(f) State your conclusion in plain English on your spreadsheet.

(g) Save the file as: LOS5

2. Suppose that a healthcare administrator wants to compare the average time

required to complete an initial visit between two clinics at different sites in a

multi-institutional organization to see if there is a significant time difference.

You want to practice your skills on a small sample of data using the hypothetical

data given in Fig. 5.19:

(a) State the null hypothesis and the research hypothesis on an Excel

(b) Find the standard error of the difference between the means using Excel

(c) Find the critical t value using Appendix E, and enter it on your spreadsheet.

(d) Perform a t-test using Excel. What is the value of t that you obtain?

(f) State your conclusion in plain English on your spreadsheet.

(g) Save the file as: VISIT3

3. Suppose that the Chair of a Master’s program in Health Administration wants to determine if there is a difference in GPAs between Male students and Female

students who have completed all of the required core courses in the program.

Suppose, further, that the Chair has obtained this data from the Registrar and has

promised to keep the information confidential. You have been asked to analyze

the data using your Excel skills. Assume that you have been working on this

Fig. 5.19 Worksheet Data for Chap. 5: Practice

Problem #2

5.4 End-of-Chapter Practice Problems 113

analysis, and you have determined that the 47 Males in the program have an

average GPA of 3.15 with a standard deviation of 0.42, while the 56 Females in

the program have an average GPA of 3.45 with a standard deviation of 0.37. You

now want to analyze the these data.

(a) State the null hypothesis and research hypothesis on a separate sheet of

paper.

(b) Find the standard error of the difference between the means using ExceL

(c) Find the critical t value using Appendix E, and enter it on your spreadsheet.

(d) Perform a t-test using Excel. What is the value of t that you obtain?

(e) Use three decimals for all figures that require a formula.

(g) State your conclusion in plain English on your spreadsheet.

(h) Save the file as: HSM3

References

Bowers D. Medical statistics from scratch: an introduction for health professionals. 2nd

ed. Hoboken: John Wiley & Sons; 2008.

Keller G. Statistics for management and economics. 8th ed. Mason: South-Western Cengage

Learning; 2009.

Wheater C, Cook P. Using statistics to understand the environment. New York: Routledge; 2000.

114 5 Two-Group t-Test of the Difference of the Means for Independent Groups