STAT130 Spring 2024 Introduction Case Study Employees Satisfaction Survey in the Commercial Sector To study the Satisfaction on the salary and working environment for the employees in the commercial Sector in UAE. A survey questionnaire was designed and sent to randomly selected full-time employees in the commercial Sector. The questionnaire included questions to measure the employee's satisfaction on their salary, and the working load and environment, and personal information such as the working experience and gender. Data Description The Employees Satisfaction.xls file contains information on 107 employees. 4 variables have been included in the excel file and are coded as follows: Gender: 1 = Male, 2 = Female. Working-Experience: 1= Low, 2= Moderate, 3= High Salary-Satisfaction: Overall satisfaction about salary Load-Satisfaction: Overall satisfaction about the work load and environment You should consider the following instructions when answering the case study project questions and preparing your report: For the report Should be typed. Show all of your work explicitly. Copy the Mega Stat output under each question. For testing hypothesis: Test the hypothesis use P-value at 5% significance level. State the null and alternative hypotheses. ⚫ Check the necessary assumptions. ⚫ Find the P-value and the test statistic. (use Mega Stat) ⚫ Make a conclusion statement in the words of the original problem. Case Questions: 1. For each of the 2 categorical variables (Gender and Working Experience), Find: • The Frequency tables for each variable. Bar Chart for each variable. • Comment on the results (which category have had the highest percentage), for each variable. 2. For each of the 2 quantitate variables (Salary-Satisfaction, Load-Satisfaction). ⚫ For each variable: Find mean, variance, standard deviation, C.V and mode, Five Summary Measures and IQR STAT130 Case Study Spring 2024 ⚫ For each variable: Find the Boxplot, and use the Boxplot to determine the shape of the distribution for each variable. • For each variable: Are there any outliers? and if any, what is its values? ⚫ For each variable: Which measure, the mean or median, is the better summary measure of the center of the distribution? • For each variable: Which measure, the standard deviation or IQR, is the better summary measure of the variation? 3. A rating of 3 is neutral satisfaction; therefore, ratings above 3 are, on average, satisfied. Test whether the employees in the commercial sector are satisfied with the current salary? 4. A rating of 3 is neutral satisfaction; therefore, ratings above 3 are, on average, satisfied. Test whether the employees in the commercial sector are satisfied with their work load? 5. Are there significant differences for the averages of salary satisfaction between male and female employees? 6. Are there significant differences for the averages of work load satisfaction between male and female employees? 7. Are there significant differences for the averages of salary satisfaction between employees working- experience? 8. Are there significant differences for the averages of work load satisfaction between employees working-experience? 9. Is employees working-experience depend on the employees' gender? 10. Based on your findings, make “practical" recommendations to increase the satisfaction on the salary and working environment for the employees in the commercial Sector