You have been recently hired as the quality manager for an urgent care clinic and will spend the next two
weeks’ reviewing all the patient records in the practice dataset. The information includes the identification
number assigned to each patient, followed by patient age and gender. After a visit, each patient is mailed a
survey to gather satisfaction scores. The results are represented in the opinion column. A score of 1 is very
poor, 2 is poor, 3 is neutral, 4 is good, and 5 is very good. The clinic administrator has provided the payment
type and the charges billed for the visit in the charge’s column. The patient’s admission blood pressure data
come from his/her EHR.
A snapshot of the data set is attached:
Create a response using the template resource below that responds to the following questions posed to you by
the clinic administrator. Bear in mind that your answers will be used to set performance goals and strategic
objectives for the clinic so a recommendations section that addresses this is expected.
- What type of data is found in each column (e.g. categorical [nominal]; interval [continuous])?
- Which numerical summary measures would you use to summarize the data in each column (e.g. mean,
median, mode, range, standard deviation)? - What type of graphical methods would you use to represent the data in each column (e.g. bar chart, run
chart)?
Sample Solution