Problem: As a healthcare manager one of your responsibilities is to provide for the education and development of your employees. In order to identify the preferred education delivery methods of your employees to more effectively plan potential learning initiatives you decide to conduct a survey to prioritize your approaches. Locate the results of your survey in the Excel spreadsheet labeled exercise 1.2a found in the Course Documents section. Identify the type of variable this data represents (categorical or quantitative) and create the appropriate graph to display this data. How would you prioritize the delivery methods when developing your education plan?

b) Refer to the Excel spreadsheet labeled exercise 1.2b found in the Course Documents section. The data is measuring wait times in an emergency room. Identify the type of variable this data represents (categorical or quantitative) and then create the appropriate graph of the data using Excel.

c) Refer to the Excel spreadsheet labeled exercise 1.2c found in the Course Documents section. The data is measuring medical record availability (in percentages) for a busy urban community clinic. Using Excel, create a grouped frequency distribution and display the distribution on a histogram. Describe the shape of the distribution.

d) Using the medical record availability data from exercise (c) provide a numerical description of the distribution using summary statistics obtained from the data analysis function in Excel (refer to the reference located in the Course Documents section for assistance with installing and using the data analysis function). What number represents the center of the distribution? What number would you use to describe the spread or variability in the distribution?

e) Exercise 3.48 on Page 88

Price: $13.72

Solution: The downloadable solution consists of 8 pages, 572 words and 7 charts.
Deliverable: Word Document