3. Develop and discuss in the context of the problem the 95% confidence interval estimates for absentees from work (ABSENT) for

   1. all employees;

   2. employees from each job complexity categories;

   3. employees from each supervisor satisfaction categories.

Description An organization is interested in conducting a study of the factors that help explain absenteeism among its production employees. After reviewing the literature on absenteeism and interviewing several employees and production supervisors, a researcher in charge of the project defined the variables, and for a random sample of 77 employees, data were collected. The dependent variable is absenteeism (ABSENT). The other variables are considered possible explanatory variables. The data set is saved as absenteeism.xls. The goal of the study is to identify factors that influence absenteeism and to develop an appropriate model to explain it. The following hyperlinks give some reports on issues of absenteeism in the workplace. https://mitrefinch.com/blog/absenteeism-definition/ https://mitrefinch.com/blog/9-underlying-causes-employee-absenteeism-workplace/ https://www.mercer.ca/en/our-thinking/how-much-are-you-losing-to-absenteeism.html http://www.investopedia.com/articles/personal-finance/070513/causes-and-costs-absenteeism.asp Managing Absenteeism In a Multi-Generation Workforce Column Label Description A ABSENT Number of distinct occasions worker is absent (absentees for one or more days) B AbsentCAT Absence Category: leONE if zero or one absence; TWO if 2 absences; 3to6 if 3 to 6 absences Jobindex Complexity of job Index (0 to 100%) D JobCat Complexity of job Category: LOW if Index70 E BASEPAY Base hourly pay rate in $ SENIORITY Number of complete years with the company G SeniorCat Seniority Category (Below5Yr, 5to10Yr, Overl0Yr) H SATISFY Supervisor satisfaction (0 = Dissatisfied, 1= Satisfied) I DEPEND Number of Dependents J DependCat Dependents Category (None, lor2, 3to5) F G 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 A ABSENT 0 1 0 2 0 1 1 1 2 1 3 2 1 3 2 0 4 6 3 2 2 4 2 0 3 3 3 0 2 3 1 4 2 1 3 2 4 4 4 B ABSENTCAT leONE leONE leONE TWO leONE leONE leONE leONE TWO leONE 3T06 TWO leONE 3T06 TWO leONE 3 3TOR 3 TOG TWO TWO 3 TWO leONE 3 3T06 leONE TWO 3T06 leONE 3 TWO leONE 3T06 TWO 3T06 3 3T06 Jobindex 45 76 56 76 70 69 56 56 43 76 30 50 10 69 67 69 70 13 16 52 52 3 6 67 10 89 21 34 12 70 69 13 30 43 8 69 30 23 16 D JobCat STANDARD HIGH STANDARD HIGH STANDARD STANDARD STANDARD STANDARD STANDARD HIGH LOW STANDARD LOW STANDARD STANDARD STANDARD STANDARD LOW LOW STANDARD STANDARD LOW LOW STANDARD LOW HIGH LOW STANDARD LOW STANDARD STANDARD LOW LOW STANDARD LOW STANDARD LOW LOW LOW E BASEPAY 21.66 23.74 21.08 23.74 23.92 22.31 21.78 20.70 22.99 21.63 21.02 22.88 20.80 2248 23.61 2244 23 34 22.17 23 67 2339 22.87 22.04 21 38 2442 20.66 25.51 20.83 22.27 24.47 2271 22.39 21.77 22.28 21.19 22.40 23.03 20.84 20.81 22.57 SENIORITY 3 10 9 7 14 9 3 1 9 1 1 9 1 4 3 4 8 1 31 5 16 2 4 G 1 18 SeniorCat Below5Y Sto 10 Sto 1041 Sto 101 Over1OY! 5to10Y1 Below5Y1 Below5Y1 5to1071 Below5Y! Below5Y1 5to1071 Below5Y! Below5Y1 Below5Y Below5Y1 5t01071 Below5Y Below5Y 5to1071 Over1OY Below5Y1 Below5YT Sto10Y BelowSYr Over1OY! Below5Yr Below5YT Sto1071 Below5Y1 Over 10Y Below5Y1 Over 10Y Below5Y1 Below5Y1 Below5Y1 Below5Y1 Below5Y1 Below5Y1 SATISFY 1 1 0 1 1 1 1 1 0 0 0 1 1 0 1 0 0 0 1 0 0 0 0 1 0 1 0 1 1 0 1 0 1 0 0 0 1 0 1 DEPEND 2 1 5 2 2 0 1 0 0 1 1 0 1 0 1 1 1 2 2 2 1 0 2 1 0 0 1 1 2 2 2 1 5 DependCat 10r2 1or2 3to5 1012 1012 NONE 1012 NONE NONE 1012 1012 NONE 1012 NONE 1012 1012 1012 1 or 2 1012 1012 1or2 NONE 1 02 1 or2 NONE NONE 1012 1012 Tor2 1012 1012 1012 3to5 1012 NONE 1012 1012 1012 1012 CONNE 11 13 1 2 2 1 1 1 NNNNO 2 2 2 2 B 2 2 2 41 42 43 44 45 46 47 48 NONOLONNN 4 1 A 3 2 6 3 1 2 1 1 3 2 0 0 1 3 6 3 2 2 4 3 0 0 1 1 1 2 3 2 2 2 2 1 0 1 4 3 2 3 3T06 TWO 3T06 3T06 leONE TWO leONE leONE 3T06 TWO leONE leONE leONE 3T06 3T06 3T06 TWO TWO 3T06 3T06 leONE leONE leONE leONE leONE TWO 3T06 TWO TWO TWO TWO leONE leONE leONE 3T06 3T06 TWO 3T06 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 11 16 50 50 69 10 43 12 76 56 6 8 45 43 23 1 82 1 1 70 76 82 50 70 81 70 1 8 23 21 82 67 81 43 6 13 52 52 D LOW LOW STANDARD STANDARD STANDARD LOW STANDARD LOW HIGH STANDARD LOW LOW STANDARD STANDARD LOW LOW HIGH LOW LOW STANDARD HIGH HIGH STANDARD STANDARD HIGH STANDARD LOW LOW LOW LOW HIGH STANDARD HIGH STANDARD LOW LOW STANDARD STANDARD E 21.60 21.89 22.24 21.61 24.79 21.53 22.86 21.93 23.20 21.22 21.88 22.73 21.37 21 84 20.64 23.18 23.58 21.94 21.84 23.80 23.00 25.47 22.21 24.56 22.60 23.61 23.35 21.51 21 27 21.67 2454 2482 23.00 23.50 21.58 23.44 23.24 21.26 F 1 1 2 2 4 2 26 1 5 2 8 3 2 5 1 7 1 1 1 4 6 7 9 8 5 9 2 1 2 12 G Below5Y1 Below5Y1 Below5Y1 Below5Y1 Below5Y1 Below5Y Over1OYt Below5Y1 5to10YT Below5Y 5to1OY Below5Y1 Below5Y1 5to10Y Below5Y 5to1OY Below5Y! Below5Y Below5Y1 Below5Y1 5to10Y 5to10Y 5to1OYt 5to1OYt 5to1091 5to1OY Below5Y1 Below5Y1 Below5Y1 Over107 5to1OYt Over1OYT Over1OYt 5to1OY Below5Y1 5to10Y 5to1OY Below5Y1 H 0 0 0 0 1 0 1 0 0 0 0 1 1 0 0 1 1 0 1 1 1 1 0 1 1 1 1 1 1 1 0 2 2 4 4 3 3 1 1 1 D 3 2 J 1012 1012 1012 NONE 3to5 1012 1012 NONE 1012 1012 3to5 3to5 3to5 3t05 1012 10r2 1012 NONE 3to5 1012 NONE NONE 1012 1012 1012 3to5 3to5 10r2 3105 3t05 3to5 3to5 10r2 NONE 1012 3to5 1012 1012 OO 2 1 1 3 2 3 0Mwo 1 1 1 5 3 28 18 - 4 | 1 0 0 0 0 1 4 1 1 1 Description An organization is interested in conducting a study of the factors that help explain absenteeism among its production employees. After reviewing the literature on absenteeism and interviewing several employees and production supervisors, a researcher in charge of the project defined the variables, and for a random sample of 77 employees, data were collected. The dependent variable is absenteeism (ABSENT). The other variables are considered possible explanatory variables. The data set is saved as absenteeism.xls. The goal of the study is to identify factors that influence absenteeism and to develop an appropriate model to explain it. The following hyperlinks give some reports on issues of absenteeism in the workplace. https://mitrefinch.com/blog/absenteeism-definition/ https://mitrefinch.com/blog/9-underlying-causes-employee-absenteeism-workplace/ https://www.mercer.ca/en/our-thinking/how-much-are-you-losing-to-absenteeism.html http://www.investopedia.com/articles/personal-finance/070513/causes-and-costs-absenteeism.asp Managing Absenteeism In a Multi-Generation Workforce Column Label Description A ABSENT Number of distinct occasions worker is absent (absentees for one or more days) B AbsentCAT Absence Category: leONE if zero or one absence; TWO if 2 absences; 3to6 if 3 to 6 absences Jobindex Complexity of job Index (0 to 100%) D JobCat Complexity of job Category: LOW if Index70 E BASEPAY Base hourly pay rate in $ SENIORITY Number of complete years with the company G SeniorCat Seniority Category (Below5Yr, 5to10Yr, Overl0Yr) H SATISFY Supervisor satisfaction (0 = Dissatisfied, 1= Satisfied) I DEPEND Number of Dependents J DependCat Dependents Category (None, lor2, 3to5) F G 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 A ABSENT 0 1 0 2 0 1 1 1 2 1 3 2 1 3 2 0 4 6 3 2 2 4 2 0 3 3 3 0 2 3 1 4 2 1 3 2 4 4 4 B ABSENTCAT leONE leONE leONE TWO leONE leONE leONE leONE TWO leONE 3T06 TWO leONE 3T06 TWO leONE 3 3TOR 3 TOG TWO TWO 3 TWO leONE 3 3T06 leONE TWO 3T06 leONE 3 TWO leONE 3T06 TWO 3T06 3 3T06 Jobindex 45 76 56 76 70 69 56 56 43 76 30 50 10 69 67 69 70 13 16 52 52 3 6 67 10 89 21 34 12 70 69 13 30 43 8 69 30 23 16 D JobCat STANDARD HIGH STANDARD HIGH STANDARD STANDARD STANDARD STANDARD STANDARD HIGH LOW STANDARD LOW STANDARD STANDARD STANDARD STANDARD LOW LOW STANDARD STANDARD LOW LOW STANDARD LOW HIGH LOW STANDARD LOW STANDARD STANDARD LOW LOW STANDARD LOW STANDARD LOW LOW LOW E BASEPAY 21.66 23.74 21.08 23.74 23.92 22.31 21.78 20.70 22.99 21.63 21.02 22.88 20.80 2248 23.61 2244 23 34 22.17 23 67 2339 22.87 22.04 21 38 2442 20.66 25.51 20.83 22.27 24.47 2271 22.39 21.77 22.28 21.19 22.40 23.03 20.84 20.81 22.57 SENIORITY 3 10 9 7 14 9 3 1 9 1 1 9 1 4 3 4 8 1 31 5 16 2 4 G 1 18 SeniorCat Below5Y Sto 10 Sto 1041 Sto 101 Over1OY! 5to10Y1 Below5Y1 Below5Y1 5to1071 Below5Y! Below5Y1 5to1071 Below5Y! Below5Y1 Below5Y Below5Y1 5t01071 Below5Y Below5Y 5to1071 Over1OY Below5Y1 Below5YT Sto10Y BelowSYr Over1OY! Below5Yr Below5YT Sto1071 Below5Y1 Over 10Y Below5Y1 Over 10Y Below5Y1 Below5Y1 Below5Y1 Below5Y1 Below5Y1 Below5Y1 SATISFY 1 1 0 1 1 1 1 1 0 0 0 1 1 0 1 0 0 0 1 0 0 0 0 1 0 1 0 1 1 0 1 0 1 0 0 0 1 0 1 DEPEND 2 1 5 2 2 0 1 0 0 1 1 0 1 0 1 1 1 2 2 2 1 0 2 1 0 0 1 1 2 2 2 1 5 DependCat 10r2 1or2 3to5 1012 1012 NONE 1012 NONE NONE 1012 1012 NONE 1012 NONE 1012 1012 1012 1 or 2 1012 1012 1or2 NONE 1 02 1 or2 NONE NONE 1012 1012 Tor2 1012 1012 1012 3to5 1012 NONE 1012 1012 1012 1012 CONNE 11 13 1 2 2 1 1 1 NNNNO 2 2 2 2 B 2 2 2 41 42 43 44 45 46 47 48 NONOLONNN 4 1 A 3 2 6 3 1 2 1 1 3 2 0 0 1 3 6 3 2 2 4 3 0 0 1 1 1 2 3 2 2 2 2 1 0 1 4 3 2 3 3T06 TWO 3T06 3T06 leONE TWO leONE leONE 3T06 TWO leONE leONE leONE 3T06 3T06 3T06 TWO TWO 3T06 3T06 leONE leONE leONE leONE leONE TWO 3T06 TWO TWO TWO TWO leONE leONE leONE 3T06 3T06 TWO 3T06 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 11 16 50 50 69 10 43 12 76 56 6 8 45 43 23 1 82 1 1 70 76 82 50 70 81 70 1 8 23 21 82 67 81 43 6 13 52 52 D LOW LOW STANDARD STANDARD STANDARD LOW STANDARD LOW HIGH STANDARD LOW LOW STANDARD STANDARD LOW LOW HIGH LOW LOW STANDARD HIGH HIGH STANDARD STANDARD HIGH STANDARD LOW LOW LOW LOW HIGH STANDARD HIGH STANDARD LOW LOW STANDARD STANDARD E 21.60 21.89 22.24 21.61 24.79 21.53 22.86 21.93 23.20 21.22 21.88 22.73 21.37 21 84 20.64 23.18 23.58 21.94 21.84 23.80 23.00 25.47 22.21 24.56 22.60 23.61 23.35 21.51 21 27 21.67 2454 2482 23.00 23.50 21.58 23.44 23.24 21.26 F 1 1 2 2 4 2 26 1 5 2 8 3 2 5 1 7 1 1 1 4 6 7 9 8 5 9 2 1 2 12 G Below5Y1 Below5Y1 Below5Y1 Below5Y1 Below5Y1 Below5Y Over1OYt Below5Y1 5to10YT Below5Y 5to1OY Below5Y1 Below5Y1 5to10Y Below5Y 5to1OY Below5Y! Below5Y Below5Y1 Below5Y1 5to10Y 5to10Y 5to1OYt 5to1OYt 5to1091 5to1OY Below5Y1 Below5Y1 Below5Y1 Over107 5to1OYt Over1OYT Over1OYt 5to1OY Below5Y1 5to10Y 5to1OY Below5Y1 H 0 0 0 0 1 0 1 0 0 0 0 1 1 0 0 1 1 0 1 1 1 1 0 1 1 1 1 1 1 1 0 2 2 4 4 3 3 1 1 1 D 3 2 J 1012 1012 1012 NONE 3to5 1012 1012 NONE 1012 1012 3to5 3to5 3to5 3t05 1012 10r2 1012 NONE 3to5 1012 NONE NONE 1012 1012 1012 3to5 3to5 10r2 3105 3t05 3to5 3to5 10r2 NONE 1012 3to5 1012 1012 OO 2 1 1 3 2 3 0Mwo 1 1 1 5 3 28 18 - 4 | 1 0 0 0 0 1 4 1 1 1