"Dap Project Pdf" is all the instructions for the project."Project Pdf" is the project already started by my teammates, I have to do questions 5 & 8 which is found in "Dap Project Pdf"
Results: The boxplot of the Payment corresponding to the JOB type is given below Figure 1: Side by Side boxplot of Jobtype vs Pay The descriptive statistics is Statistics Variable JOBTYPE N N* Mean SE Mean StDev Minimum Q1 Median Q3 Maximum PAY CLERICAL 22 0 57.77 3.12 14.64 29.00 51.00 57.00 70.50 86.00 MANAGERIAL 23 0 61.09 2.60 12.48 40.00 51.00 62.00 67.00 91.00 SUPERVISORY 17 0 76.00 4.49 18.49 40.00 63.00 83.00 90.50 96.00 TECHNICAL 40 0 60.13 2.52 15.93 23.00 51.00 54.50 73.50 92.00 Table 1 : Descriptive statistics of Jobtype vs Pay The boxplot of the Payment corresponding to Education is given below Figure 2: Side by Side boxplot of Education vs Pay The descriptive statistic is given below Statistics Variable EDUC N N* Mean SE Mean StDev Minimum Q1 Median Q3 Maximum PAY BAMA 39 0 78.36 1.60 10.00 60.00 70.00 78.00 88.00 96.00 COLLEGE 40 0 55.20 1.22 7.74 40.00 51.00 54.00 59.75 76.00 HSDIP 23 0 48.22 2.94 14.12 23.00 37.00 48.00 54.00 90.00 Table 2 : Descriptive statistics of Education vs Pay The boxplot of the payment correspomdimg to locations is given below Figure 3: Side by Side boxplot of Location vs Pay The descriptive statistics is given by Statistics Variable LOCATION N N* Mean SE Mean StDev Minimum Q1 Median Q3 Maximum PAY Loc_A 44 0 67.91 2.39 15.88 38.00 52.50 67.00 82.75 94.00 Loc_B 32 0 58.03 2.90 16.38 29.00 47.25 54.00 69.50 96.00 Loc_C 26 0 58.77 2.96 15.10 23.00 51.25 61.50 66.50 92.00 Table 3 : Descriptive statistics of Location vs Pay For 4th) Rows: Row Variables Columns: Worksheet columns BAMA College HSDIP All CLERICAL 6 7 9 22 8.580 8.580 4.840 0.7758 0.2910 3.5755 MANAGERIAL 9 11 3 23 8.970 8.970 5.060 0.0001 0.4594 0.8387 SUPERVISORY 12 3 2 16 6.240 6.240 3.520 5.3169 2.8810 0.6564 TECHNICAL 12 19 8 39 15.210 15.210 8.580 0.6775 0.9444 0.0392 All 39 39 22 101 Cell Contents Count Expected count Contribution to Chi-square Table 4 : Table for the Expected count for JOB TYPE vs The level of Education Table 5: The summary statistics for Chi square for the JOB TYPE vs The level of Education Rows: Row Columns: Worksheet columns LOC_A LOC_B LOC_C All CLERICAL 9 11 2 22 9.584 6.970 5.446 0.0356 2.3297 2.1801 MANAGERIAL 9 8 6 23 10.020 7.287 5.693 0.1038 0.0697 0.0165 SUPERVISORY 13 2 2 17 7.406 5.386 4.208 4.2255 2.1288 1.1585 TECHNICAL 13 11 15 39 16.990 12.356 9.653 0.9371 0.1489 2.9612 All 44 32 25 101 Cell Contents Count Expected count Contribution to Chi-square Table 6 : Table for the Expected count for JOB TYPE vs LOCATION Chi-Square Test Chi-Square DF P-Value Pearson 16.295 6 0.012 Likelihood Ratio 16.485 6 0.011 1 cell(s) with expected counts less than 5. Table 7: The summary statistics for Chi square for the JOB TYPE vs LOCATION Rows: Row Columns: Worksheet columns LOC_A LOC_B LOC_C All BAMA 23 8 8 39 16.82 12.24 9.94 2.2676 1.4661 0.3790 COLLEGE 13 17 10 40 17.25 12.55 10.20 1.0492 1.5787 0.0038 HSDIP 8 7 8 23 9.92 7.22 5.86 0.3722 0.0064 0.7791 All 44 32 26 102 Cell Contents Count Expected count Contribution to Chi-square Table 8: Table for the Expected count for EDUCATION vs LOCATION Chi-Square Test Chi-Square DF P-Value Pearson 7.902 4 0.095 Likelihood Ratio 7.786 4 0.100 Table 9: The summary statistics for Chi square for the EDUCATION vs LOCATION Discussion: The side by side boxplot of the Payment corresponding to Job type in Figure 1 shows that the payment is higher for the Supervisory Jobtype and lower for the Technical Job type . Hence the level of satisfaction is higher in the Supervisory Job type as compare to the Technical Job type. It is confirmed by the descriptive statistics in Table 1. The side by side boxplot of the Payment corresponding to Education in Figure 2 shows that the payment is higher for the BAMA Education and lower for the HISDIP Education . Hence the level of satisfaction is higher in the BAMA Eduaction type as compare to the Other Eduaction Type and is confirmend by the Table 2. Also, The side by side boxplot of the Payment corresponding to Location shows that the payment is higher on the Location B and lower for the Location C as shown in Figure 3. Hence the level of satisfaction is higher on Location B as comapre to other location which is confirmed by the Table 3. For Table 4, The null and alternative hypothesis are Ho: The type of employe’s job and level of employee’s attained eductaion are indepndent of each other. Ha: The type of employe’s job and level of employee’s attained eductaion are depndent on each other. From the table 5 the result of chi square , The value of chi square is 14.787 and p value is 0.022 which is less than 0.05 so we will reject the null hypothesis and conclude that the type of employe’s job and level of employee’s attained eductaion are not indepndent of each other. For Table 6, The null and alternative hypothesis are Ho: The type of employe’s job and employee’s work location are indepndent of each other. Ha: The type of employe’s job and employee’s work location are depndent on each other. From the table 7 the result of chi square , The value of chi square is 16.295 and p value is 0.012 which is less than 0.05 so we will reject the null hypothesis and conclude that The type of employe’s job and level of employee’s work location are not indepndent of each other. For Table 8, The null and alternative hypothesis are Ho: The type of employe’s level of eduaction and employee’s work location are indepndent of each other. Ha: The type of employe’s level of eduaction and employee’s work location are depndent on each other. From the table 9 the result of chi square , The value of chi square is 7.902 and p value is 0.095 which is greater than 0.05 so we will not reject the null hypothesis and conclude that The type of employe’s level of eduaction and employee’s work location are indepndent of each other. Conclusion : From the above results and discussion , we will conclude that the type of employe’s level of eduaction and employee’s work location are indepndent of each other while the type of employe’s job and employee’s work location are depndent on each other and also the type of employe’s job and level of employee’s attained eductaion are depndent on each other. The payment is higher for the Supervisory Jobtype and lower for the Technical Job type hence the employess will prefer the Supervisory post for their level of satisfaction regarding the money. On the same hand the payment is higher on the Location B and lower for the Location C hence they will prefer to do job on location B as compared to location B and C. COMM 215: Business Statistics Section EC Winter 2022 _____________________________________________________________________________________ Data Analysis Project (8%) Topic: Employee Satisfaction at NASEE Inc. Data file: DAP_EmployeeSatisfaction.xlsx Report uploading Deadline: April 9, 2022, before 24:00 _____________________________________________________________________________________ Description Nasee Inc. runs stores with operations in several major locations. Recently, there have been several instances of work slowdown and walk out by protesting employees unhappy with management’s response to their demands. Concerned about the issues and the current degree of employee satisfaction, management has initiated a study based on a sample of its employees from the three major work locations: Loc_A, Loc_B, and Loc_C. As part of this study, employees in the sample were asked to indicate their degree of satisfaction in their work (WORK), their pay (PAY), and their opportunities for promotions (PROMO). Each of the three aspects of job satisfaction was measured on a scale from 0 to 100, with larger values indicating higher degrees of satisfaction. The data collected also show the following characteristics of employees: employee ID; job type (JOBTYPE: Managerial, Supervisory, Clerical and Technical), level of attained education (EDUC: HSDIP=High School Diploma, COLLEGE level, BAMA=Bachelors or Master’s Degree). The goal of the study is to identify factors that influence employee satisfaction and to develop an appropriate model to explain the issues. For recent studies on ‘Employee Job Satisfaction and Engagement’, you may refer to the link below and some of the references cited in this report. https://www.shrm.org/hr-today/trends-and-forecasting/research-and-surveys/Documents/2016-Employee-Job-Satisfaction-and-Engagement Report.pdf Managerial Report Use appropriate (applicable) methods of descriptive statistics, including tables and plots, to summarize the data (depending on the data type - quantitative continuous or discrete