Question: 1) Finding Patients Distribution by Age 2) Finding Patients Distribution by Appointments Missed 3) Get the frequency and bin 4) Get a Historgram Patient Identifier
1) Finding Patients Distribution by Age
2) Finding Patients Distribution by Appointments Missed
3) Get the frequency and bin
4) Get a Historgram
| Patient Identifier | Age | Medication Compliance Rating | Number of Appointments | % of Missed Appointments | Number Appointments Missed | |||
| 1 | 35 | 1 | 24 | 50% | 12 | |||
| 2 | 42 | 2 | 24 | 30% | 7 | |||
| 3 | 49 | 2 | 24 | 33% | 8 | |||
| 4 | 56 | 3 | 24 | 5% | 1 | |||
| 5 | 63 | 3 | 24 | 5% | 1 | |||
| 6 | 70 | 4 | 24 | 10% | 2 | |||
| 7 | 67 | 4 | 24 | 7% | 2 | |||
| 8 | 64 | 4 | 24 | 5% | 1 | |||
| 9 | 61 | 4 | 24 | 3% | 1 | |||
| 10 | 58 | 4 | 24 | 15% | 4 | |||
| 11 | 55 | 3 | 24 | 5% | 1 | |||
| 12 | 52 | 3 | 24 | 18% | 4 | |||
| 13 | 49 | 2 | 24 | 30% | 7 | |||
| 14 | 46 | 2 | 24 | 33% | 8 | |||
| 15 | 43 | 2 | 24 | 30% | 7 | |||
| 16 | 40 | 2 | 24 | 33% | 8 | |||
| 17 | 37 | 1 | 24 | 50% | 12 | |||
| 18 | 34 | 1 | 24 | 55% | 13 | |||
| 19 | 31 | 1 | 24 | 50% | 12 | |||
| 20 | 28 | 1 | 24 | 55% | 13 | |||
| 21 | 25 | 1 | 24 | 55% | 13 | |||
| 22 | 22 | 1 | 24 | 55% | 13 | |||
| 23 | 29 | 1 | 24 | 55% | 13 | |||
| 24 | 36 | 2 | 24 | 55% | 13 | |||
| 25 | 43 | 2 | 24 | 30% | 7 | |||
| 26 | 50 | 3 | 24 | 33% | 8 | |||
| 27 | 47 | 3 | 24 | 30% | 7 | |||
| 28 | 44 | 3 | 24 | 33% | 8 | |||
| 29 | 41 | 3 | 24 | 28% | 7 | |||
| 30 | 38 | 3 | 24 | 55% | 13 | |||
| 31 | 35 | 3 | 24 | 55% | 13 | |||
| 32 | 32 | 2 | 24 | 55% | 13 | |||
| 33 | 29 | 1 | 24 | 55% | 13 | |||
| 34 | 26 | 2 | 24 | 55% | 13 | |||
| 35 | 33 | 3 | 24 | 55% | 13 | |||
| 36 | 40 | 3 | 24 | 30% | 7 | |||
| 37 | 47 | 3 | 24 | 33% | 8 | |||
| 38 | 54 | 4 | 24 | 25% | 6 | |||
| 39 | 51 | 5 | 24 | 25% | 6 | |||
| 40 | 48 | 3 | 24 | 32% | 8 | |||
| 41 | 45 | 3 | 24 | 37% | 9 | |||
| 42 | 42 | 3 | 24 | 33% | 8 | |||
| 43 | 39 | 3 | 24 | 55% | 13 | |||
| 44 | 36 | 2 | 24 | 55% | 13 | |||
| 45 | 33 | 2 | 24 | 55% | 13 | |||
| 46 | 30 | 2 | 24 | 55% | 13 | |||
| 47 | 37 | 3 | 24 | 55% | 13 | |||
| 48 | 44 | 4 | 24 | 32% | 8 | |||
| 49 | 51 | 4 | 24 | 37% | 9 | |||
| 50 | 58 | 4 | 24 | 33% | 8 | |||
| 51 | 55 | 5 | 24 | 12% | 3 | |||
| 52 | 52 | 4 | 24 | 10% | 2 | |||
| 53 | 49 | 3 | 24 | 32% | 8 | |||
| 54 | 46 | 5 | 24 | 37% | 9 | |||
| 55 | 43 | 4 | 24 | 33% | 8 | |||
| 56 | 40 | 4 | 24 | 32% | 8 | |||
| 57 | 37 | 3 | 24 | 37% | 9 | |||
| 58 | 34 | 2 | 24 | 43% | 10 | |||
| Data Notes: | Very High | High | Average | Low | Very Low | |||
| Medication Compliance Ratings | 5 | 4 | 3 | 2 | 1 | |||
| Missed Appointments | Total number of missed apointments for first three months | |||||||
| Note - All cients are scheduled for 1 appointment each week |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
