Quantitative Analysis for Healthcare Managers

P1 w2

Quantitative Analysis for Healthcare Managers

The purpose of this week’s assignment is to assess your understanding of the concept of sampling and how the knowledge of this concept can be applied in a healthcare services setting.

For this assignment, you will review two scenarios in a fictitious healthcare setting, and then provide your best response to each scenario.

Scenario 1: As a healthcare administrator of a popular healthcare facility in your community, you have been receiving news of unsubstantiated claims of poor customer service in your facility. To make matters worse, a news agency recently carried a news report that highlighted patient dissatisfaction with the quality of service they receive in your facility. As a result of this news, the board of directors and other key stakeholders in your organization met to discuss the matter. Based on the discussion, it was recommended that your healthcare facility conduct a survey of patients in your facility to learn more about the alleged claims of dissatisfaction. The board of directors is also interested in investing millions of dollars to improve any gaps by the proposed survey.

As the administrator of this healthcare facility, what type of sampling methods will you use to assess patient satisfaction from the more than two million patients that visit your facility on a yearly basis? Please give a clear rationale for the sampling methods chosen for this effort.

Scenario 2: As a healthcare administrator, you recently received a complaint from one of your operational managers that suggests there may be a wide range of dissatisfaction among surgeons working in your facility about the work conditions. As a result of this complaint, you decided you wanted to learn more about the challenges surgeons (21 in number) may be facing so you can do the right thing to improve their condition of service.

Based on this information, what sampling method will best help you to assess the working conditions of surgeons in your facility? Please give a clear rationale for the sampling methods chosen for this effort.

For both scenarios, consider addressing the following Points:

· Population

· Population unit

· Sampling methodology

· Sampling size

· Types of interviews (if any?)

· Strengths and weaknesses of sampling methodology?

Length: 1-3 pages, not including title and reference pages

Resources:  Include a minimum of 3 scholarly resources.

P2 w2

For this assignment, you will be required to use Microsoft Excel to generate a random sample.

Random sample generation: In a clinic that falls under the healthcare organization that you manage, there are about 1,500 patients who visit this clinic on a monthly basis. Based on the sample size identified during consultation with the statistician that supports your organization, you concluded that surveying 30 patients will give you the insight you need from the entire patient population.

Using Microsoft Excel, create a list of numbers from 1 to 1,500. This list will be your patient population. From this list, generate a random sample of 30 patients. To demonstrate your competency for this task, you will submit an Excel file showing both the list (1,500 patient population) and random sample (30 patients) generated. In addition, you will provide a narrative explaining the steps and the MS Excel functions you used to complete this task and how you may use this skill set in your current or future career. Also, explain a situation when a simple random sample- and a situation when a stratified random sample- will be appropriate.

Don’t forget to review the simulation on Creating a Random Data Sample in Microsoft Excel before completing this assignment.

Tip: One way to generate a “list” in Excel is to first type numbers 1 and 2 in cells A1 and A2, respectively. Afterward, highlight cells A1 and A2 before dragging the fill handle all the way down to the desired number.

Length: 1 Excel document and 1- 2 paragraph narrative, not including title and reference pages

Resources:  Include a minimum of 2 scholarly resources.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *