Compute the average patient to provider ratio and evaluate the results in terms of health care quality.

Order Instructions

In your role as a data analyst, you have been asked to analyze a data set and make recommendations to the board of directors. Using statistics and graphical representations to model health care measures, metrics, and indicators use this worksheet. In your worksheet, include a discussion of what the data reveals and how it can be used to make performance improvements.

Instructions:

Compute the average patient to provider ratio and evaluate the results in terms of health care quality.

Compute the percentage of board-certified providers and evaluate the results in terms of health care quality.

Compute the percentage of patients who received preventive services and evaluate the results in terms of health care quality. What recommendations would you make to the board of directors?

Compute the surgical mortality rate and evaluate the results in terms of health care quality. What recommendations would you make to the board of directors?

Use a line graph to display the surgical mortality rate by month and discuss the results in terms of trend. What recommendations would you make to the board of directors?

Use a bar chart to display the average number of patients by month. Which months have the greatest number of patients? Which months have the least number of patients? If these patients are school-aged children, what could explain these differences?