Data CustomerDateClinic NameAppointID Scenario: We send out appointment reminder calls to our customers for their upcoming appointments with our cliniics. Since patients can have multiple...

1 answer below »
Please confirm if what I did is correct for my attached assignment.
Scenario: We send out appointment reminder calls to our customers for their upcoming appointments with our cliniics. Since patients can have multiple appointments with the same or different clinics, we want to send only one reminder call for all appointments occuring on the same day.









Question from Manager: S/He wants to know the percentage of reminder calls that are for multiple appointments.



Data CustomerDateClinic NameAppointIDScenario: We send out appointment reminder calls to our customers for their upcoming appointments with our cliniics. Since patients can have multiple appointments with the same or different clinics, we want to send only one reminder call for all appointments occuring on the same day. Abby2/1/15A1001 Abby2/1/15A1002Question from Manager: S/He wants to know the percentage of reminder calls that are for multiple appointments. Abby2/1/15B1003 Brian2/1/15B1004 Brian2/1/15C1005 Brian2/1/15B1014 Cathy2/1/15C1006 Abby2/2/15D1007 Brian2/2/15D1008 Brian2/2/15D1009 Cathy2/2/15A1010 David2/3/15A1015 Brian2/4/15B1013 David2/4/15B1011 David2/4/15C1012 David2/4/15B1016 Analysis Row LabelsCount of AppointIDCustomerDateCount of Unique Appointments Abby4No. of multiple appointments11 2/1/153Abby2/1/153 2/2/1512/2/151No. of single appointments5 Brian6 2/1/153Brian2/1/153 2/2/1522/2/152Probability of multiple appointments0.687568.75% 2/4/1512/4/151Probability of single appointments0.312531.25% Cathy2 2/1/151Cathy2/1/151 2/2/1512/2/151 David4 2/3/151David2/3/151 2/4/1532/4/153 Grand Total16Total16 APPOINTMENTS 2/1/152/2/152/1/152/2/152/4/152/1/152/2/152/3/152/4/15AbbyBrianCathyDavid313211113 ANALYSIS Scenario: We send out appointment reminder calls to our customers for their upcoming appointments with our clinics. Since patients can have multiple appointments with the same or different clinics, we want to send only one reminder call for all appointments occurring on the same day. Customer Date Clinic Name Appointment ID Abby 2/1/2015 A 1001 Abby 2/1/2015 A 1002 Abby 2/1/2015 B 1003 Brian 2/1/2015 B 1004 Brian 2/1/2015 C 1005 Brian 2/1/2015 B 1014 Cathy 2/1/2015 C 1006 Abby 2/2/2015 D 1007 Brian 2/2/2015 D 1008 Brian 2/2/2015 D 1009 Cathy 2/2/2015 A 1010 David 2/3/2015 A 1015 Brian 2/4/2015 B 1013 David 2/4/2015 B 1011 David 2/4/2015 C 1012 David 2/4/2015 B 1016 We can see from the given table that from February 1st to 4th appointment details given for customer in same or different clinic. It has been decided that since patients can have multiple appointments with the same or different clinics, we want to send only one reminder call for all appointments occurring on the same day. So, we need to find how many multiple appointments & single appointments. Using pivot table, we can organize the table to get better visualization of customer with appointments in same or different clinics on same date. Row Labels Count of Appointments Abby 4 2/1/2015 3 2/2/2015 1 Brian 6 2/1/2015 3 2/2/2015 2 2/4/2015 1 Cathy 2 2/1/2015 1 2/2/2015 1 David 4 2/3/2015 1 2/4/2015 3 Grand Total 16 Customer Date Count of Unique Appointments   Abby 2/1/2015 3 2/2/2015 1     Brian 2/1/2015 3 2/2/2015 2 2/4/2015 1     Cathy 2/1/2015 1 2/2/2015 1     David 2/3/2015 1 2/4/2015 3   Total 16 No. of multiple appointments: 11 No. of single appointments: 5 Total number of appointments = 16 Probability of multiple appointments = 11/16 = 0.6875 = 68.75% Probability of single appointments = 5/16 = 0.3125 = 31.25% GRAPH APPOINTMENTS 2/1/20152/2/20152/1/20152/2/20152/4/20152/1/20152/2/20152/3/20152/4/2015AbbyBrianCathyDavid313211113 APPOINTMENTS Probability of multiple appointmentsProbability of single appointments0.68750.3125
Answered Same DayMar 06, 2022

Answer To: Data CustomerDateClinic NameAppointID Scenario: We send out appointment reminder calls to our...

Prince answered on Mar 07 2022
104 Votes
Data
    Customer    Date    Clinic Name    AppointID        Scenario: We send out appointment reminder calls to our
customers for their upcoming appointments with our cliniics. Since patients can have multiple appointments with the same or different clinics, we want to send only one reminder call for all appointments occuring on the same day.
    Abby    2/1/15    A    1001
    Abby    2/1/15    A    1002        Question from Manager: S/He wants to know the percentage of reminder calls that are for multiple...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here