An analysis of the service and operational efficiency of a private hospital in Bandar Sunway. Your team has been called in to analyse the data to provide information that would assist the Hospital administrator to make decisions to provide better service and experience for patients. Your team is required to prepare a report and present to the Hospital Board at a date and time which would be made available by the hospital administrator. You have been given the report below plus an excel file containing the data that was collected. INTRODUCTION Attached is the data collected from patients who sought medical treatment in a private hospital. The hospital administrator in order to improve the service provided to patients as well as operational efficiency, conducted a survey. He gave questioners to 80 randomly selected patients. The data collected was organised in an excel file that is provided with this assignment. The hospital administrator is interested on how patients feel about the service provided by the hospital. This is measured by the satisfaction score of 0 to 100 where 100 implies excellent service. Some background information such as age, education level gender, marital status and race was also obtained. The administrator was also concerned about the parking facilities provided. There was plans to expand the hospital and hence parking constraints. Therefore, the hospital was also interested in the transportation used to arrive at the hospital. This would help to justify additional expense to expand current parking facilities. Another issue of concern was the waiting time. Patients complained about the long waiting times. Data was collected on the waiting times to see the Nurse, GP or the specialist. In the opinion of the Hospital Administrator the waiting time to see the nurse should not be more than 15 minutes, whereas to see the doctor should be about 30 minutes. The average time to see the specialist was about an hour (Hypotheses testing should be done to determine if operational efficiency meets the expectations of the administrator. The administrator is also interested to know whether gender, educational level, marital status and race influences the outcome of your study. A TWO sample hypotheses test can be done ) 1. Introduction (10%) (5 paragraph) [Provide a brief description of the dataset with respect to the objective(s), identified response variable and chosen explanatory variables in this section.) Subject AGE GENDER ARRIVE MARRIED stafftype 001 M 88888 9P 9P SP Satisfaction 84.7 82.8 68.2. 700 81.4 877 68.7 89.2 88.7 85.6 73.6 79.4 869 87.6 ss 5 ss : 5 F F F M F M M F M F F RACE 1 M M M 1 1 M 1 1 M 1 1 79.1 9 OTH 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 033 034 035 036 037 038 039 040 041 042 043 29 21 21 23 29 47 45 21 46 28 28 34 20 35 33 27 36 34 26 44 34 53 45 22 22 42 39 48 39 28 21 22 33 45 31 65 28 49 29 36 23 29 28 EDU undergraduate preu preu olevel undergraduate undergraduate undergraduate olevel postgraduate undergraduate undergraduate undergraduate preu preu preu preu preu undergraduate undergraduate undergraduate undergraduate undergraduate undergraduate olevel olevel olevel olevel postgraduate postgraduate postgraduate preu preu postgraduate postgraduate postgraduate postgraduate postgraduate preu preu preu preu preu undergraduate 81.0 89.0 81.0 86.3 870 86.8 84.8 85.4 85.4 84.6 86.1 86.1 72.0 83.5 86.0 74.0 865 74.5 86.7 84.5 84.1 67.8 88.7 58.6 78.4 88 0 68.9 94.1 BUS CAR CAR CAR CAR CAR CAR BUS CAR CAR CAR CAR BUS WALK CAR CAR CAR CAR CAR CAR CAR CAR CAR CAR BUS BUS CAR CAR CAR CAR CAR CAR BUS CAR CAR WALK CAR CAR CAR CAR CAR CAR BUS F F M M F M F F F M F M M F M F 1 1 0 0 1 1 0 1 1 0 0 1 0 1 1 1 1 0 1 1 0 0 1 1 1 1 1 0 1 1 0 0 0 1 1 0 0 1 0 1 0 0 0 25-20-00-0 TEMP 101.5 98.6 982 100.0 101.0 990 99.8 99.5 97.1 98.1 1010 99.0 97.8 99.5 101.8 100.2 97.1 1004 97.8 992 982 99.7 99.8 97.4 986 99 2 988 99.7 983 100.0 101.9 98.5 97.0 97.7 97.9 101.8 1013 98.6 974 99.3 100.4 98.5 98.9 CONSULTMINUTES 17 67 23 59 80 13 55 12 69 64 31 60 33 59 23 25 15 36 68 76 42 105 54 35 41 78 57 89 72 82 74 81 16 19 11 47 46 51 78 51 61 21 55 nurse nurse 9P sp 9P nurse SP 9P gp 9P nurse 9P 9P sp sp 9P nurse nurse sp nurse 9P nurse sp 9P sp gp 9p 9P gp nurse nurse sp gp sp 9P 9P gp 9P 2m2 abenhagants 1 1 M 2 : ss : M F M M F M 33-3--3-303-33 M M OTH F M sp M M M s ss : 5 CAR CAR CAR CAR CAR CAR CAR CAR CAR CAR 0 1 0 1 0 1 M sp 1 M 1 M 1 M 1 M M M M M C M BUS 2EE20-22 gp nurse 31 18 40 54 24 18 22 19 24 26 25 48 21 34 30 26 42 43 29 20 24 34 43 43 41 32 33 47 45 19 19 ns 044 045 046 047 048 049 050 051 052 053 054 055 056 057 058 059 060 061 062 063 064 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079 78.9 85.4 675 88.9 65.0 89.9 85.6 89.6 715 76.0 85.9 844 67.8 85.1 752 65.0 85.9 87.0 77.4 73.8 65.5 70.4 850 61.7 86.9 78.6 666 81.2 72.0 780 80.0 883 86.0 86.0 75.0 83.6 undergraduate preu postgraduate postgraduate preu preu preu preu preu undergraduate undergraduate undergraduate olevel olevel olevel olevel olevel olevel preu olevel undergraduate undergraduate undergraduate undergraduate undergraduate undergraduate postgraduate postgraduate postgraduate alevel olevel preu undergraduate preu preu preu M F M M F M F F F M F M M F M F 9P sp M M 1 1 1 0 0 0 1 0 0 0 0 0 1 1 1 0 1 1 1 0 0 1 0 1 1 0 1 CAR CAR CAR CAR CAR CAR BUS CAR CAR CAR CAR BUS CAR CAR CAR CAR CAR CAR CAR BUS CAR CAR CAR CAR CAR 97.1 101.5 100.6 99.3 976 98.9 1015 99.3 973 98.0 99 7 98.4 101.4 970 99.1 973 101.0 98.7 101.7 98.6 100.5 101.7 1013 99.1 993 99.5 97.9 99.5 973 99.7 100.0 99.0 101.6 99.7 100.8 99.4 140 69 10 71 18 99 120 90 27 46 58 66 54 103 25 122 44 25 118 102 21 11 74 34 20 18 10 19 27 50 72 60 13 87 51 44 OTH SES sp nurse 5 55 : F M F M M 3--33--3333-- nurse 1 M F 28 23 19 21 OOO sp 9P 0 OTH An analysis of the service and operational efficiency of a private hospital in Bandar Sunway. Your team has been called in to analyse the data to provide information that would assist the Hospital administrator to make decisions to provide better service and experience for patients. Your team is required to prepare a report and present to the Hospital Board at a date and time which would be made available by the hospital administrator. You have been given the report below plus an excel file containing the data that was collected. INTRODUCTION Attached is the data collected from patients who sought medical treatment in a private hospital. The hospital administrator in order to improve the service provided to patients as well as operational efficiency, conducted a survey. He gave questioners to 80 randomly selected patients. The data collected was organised in an excel file that is provided with this assignment. The hospital administrator is interested on how patients feel about the service provided by the hospital. This is measured by the satisfaction score of 0 to 100 where 100 implies excellent service. Some background information such as age, education level gender, marital status and race was also obtained. The administrator was also concerned about the parking facilities provided. There was plans to expand the hospital and hence parking constraints. Therefore, the hospital was also interested in the transportation used to arrive at the hospital. This would help to justify additional expense to expand current parking facilities. Another issue of concern was the waiting time. Patients complained about the long waiting times. Data was collected on the waiting times to see the Nurse, GP or the specialist. In the opinion of the Hospital Administrator the waiting time to see the nurse should not be more than 15 minutes, whereas to see the doctor should be about 30 minutes. The average time to see the specialist was about an hour (Hypotheses testing should be done to determine if operational efficiency meets the expectations of the administrator. The administrator is also interested to know whether gender, educational level, marital status and race influences the outcome of your study. A TWO sample hypotheses test can be done ) 1. Introduction (10%) (5 paragraph) [Provide a brief description of the dataset with respect to the objective(s), identified response variable and chosen explanatory variables in this section.) Subject AGE GENDER ARRIVE MARRIED stafftype 001 M 88888 9P 9P SP Satisfaction 84.7 82.8 68.2. 700 81.4 877 68.7 89.2 88.7 85.6 73.6 79.4 869 87.6 ss 5 ss : 5 F F F M F M M F M F F RACE 1 M M M 1 1 M 1 1 M 1 1 79.1 9 OTH 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 033 034 035 036 037 038 039 040 041 042 043 29 21 21 23 29 47 45 21 46 28 28 34 20 35 33 27 36 34 26 44 34 53 45 22 22 42 39 48 39 28 21 22 33 45 31 65 28 49 29 36 23 29 28 EDU undergraduate preu preu olevel undergraduate undergraduate undergraduate olevel postgraduate undergraduate undergraduate undergraduate preu preu preu preu preu undergraduate undergraduate undergraduate undergraduate undergraduate undergraduate olevel olevel olevel olevel postgraduate postgraduate postgraduate preu preu postgraduate postgraduate postgraduate postgraduate postgraduate preu preu preu preu preu undergraduate 81.0 89.0 81.0 86.3 870 86.8 84.8 85.4 85.4 84.6 86.1 86.1 72.0 83.5 86.0 74.0 865 74.5 86.7 84.5 84.1 67.8 88.7 58.6 78.4 88 0 68.9 94.1 BUS CAR CAR CAR CAR CAR CAR BUS CAR CAR CAR CAR BUS WALK CAR CAR CAR CAR CAR CAR CAR CAR CAR CAR BUS BUS CAR CAR CAR CAR CAR CAR BUS CAR CAR WALK CAR CAR CAR CAR CAR CAR BUS F F M M F M F F F M F M M F M F 1 1 0 0 1 1 0 1 1 0 0 1 0 1 1 1 1 0 1 1 0 0 1 1 1 1 1 0 1 1 0 0 0 1 1 0 0 1 0 1 0 0 0 25-20-00-0 TEMP 101.5 98.6 982 100.0 101.0 990 99.8 99.5 97.1 98.1 1010 99.0 97.8 99.5 101.8 100.2 97.1 1004 97.8 992 982 99.7 99.8 97.4 986 99 2 988 99.7 983 100.0 101.9 98.5 97.0 97.7 97.9 101.8 1013 98.6 974 99.3 100.4 98.5 98.9 CONSULTMINUTES 17 67 23 59 80 13 55 12 69 64 31 60 33 59 23 25 15 36 68 76 42 105 54 35 41 78 57 89 72 82 74 81 16 19 11 47 46 51 78 51 61 21 55 nurse nurse 9P sp 9P nurse SP 9P gp 9P nurse 9P 9P sp sp 9P nurse nurse sp nurse 9P nurse sp 9P sp gp 9p 9P gp nurse nurse sp gp sp 9P 9P gp 9P 2m2 abenhagants 1 1 M 2 : ss : M F M M F M 33-3--3-303-33 M M OTH F M sp M M M s ss : 5 CAR CAR CAR CAR CAR CAR CAR CAR CAR CAR 0 1 0 1 0 1 M sp 1 M 1 M 1 M 1 M M M M M C M BUS 2EE20-22 gp nurse 31 18 40 54 24 18 22 19 24 26 25 48 21 34 30 26 42 43 29 20 24 34 43 43 41 32 33 47 45 19 19 ns 044 045 046 047 048 049 050 051 052 053 054 055 056 057 058 059 060 061 062 063 064 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079 78.9 85.4 675 88.9 65.0 89.9 85.6 89.6 715 76.0 85.9 844 67.8 85.1 752 65.0 85.9 87.0 77.4 73.8 65.5 70.4 850 61.7 86.9 78.6 666 81.2 72.0 780 80.0 883 86.0 86.0 75.0 83.6 undergraduate preu postgraduate postgraduate preu preu preu preu preu undergraduate undergraduate undergraduate olevel olevel olevel olevel olevel olevel preu olevel undergraduate undergraduate undergraduate undergraduate undergraduate undergraduate postgraduate postgraduate postgraduate alevel olevel preu undergraduate preu preu preu M F M M F M F F F M F M M F M F 9P sp M M 1 1 1 0 0 0 1 0 0 0 0 0 1 1 1 0 1 1 1 0 0 1 0 1 1 0 1 CAR CAR CAR CAR CAR CAR BUS CAR CAR CAR CAR BUS CAR CAR CAR CAR CAR CAR CAR BUS CAR CAR CAR CAR CAR 97.1 101.5 100.6 99.3 976 98.9 1015 99.3 973 98.0 99 7 98.4 101.4 970 99.1 973 101.0 98.7 101.7 98.6 100.5 101.7 1013 99.1 993 99.5 97.9 99.5 973 99.7 100.0 99.0 101.6 99.7 100.8 99.4 140 69 10 71 18 99 120 90 27 46 58 66 54 103 25 122 44 25 118 102 21 11 74 34 20 18 10 19 27 50 72 60 13 87 51 44 OTH SES sp nurse 5 55 : F M F M M 3--33--3333-- nurse 1 M F 28 23 19 21 OOO sp 9P 0 OTH