STAT130Spring 2024IntroductionCase StudyEmployees Satisfaction Survey in the Commercial SectorTo study the Satisfaction on the salary and working environment for the employees in the commercialSector in UAE.A survey questionnaire was designed and sent to randomly selected full-time employees in thecommercial Sector.The questionnaire included questions to measure the employee's satisfaction on their salary, and theworking load and environment, and personal information such as the working experience and gender.Data DescriptionThe 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= HighSalary-Satisfaction: Overall satisfaction about salaryLoad-Satisfaction: Overall satisfaction about the work load and environmentYou should consider the following instructions when answering the case study project questionsand preparing your report:For the reportShould 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 SummaryMeasures and IQR STAT130Case StudySpring 2024⚫ For each variable: Find the Boxplot, and use the Boxplot to determine the shape of thedistribution 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 ofthe center of the distribution?• For each variable: Which measure, the standard deviation or IQR, is the better summarymeasure 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 femaleemployees?6. Are there significant differences for the averages of work load satisfaction between male and femaleemployees?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 employeesworking-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 salaryand working environment for the employees in the commercial Sector

Question

STAT130Spring 2024IntroductionCase StudyEmployees Satisfaction Survey in the Commercial SectorTo study the Satisfaction on the salary and working environment for the employees in the commercialSector in UAE.A survey questionnaire was designed and sent to randomly selected full-time employees in thecommercial Sector.The questionnaire included questions to measure the employee's satisfaction on their salary, and theworking load and environment, and personal information such as the working experience and gender.Data DescriptionThe 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= HighSalary-Satisfaction: Overall satisfaction about salaryLoad-Satisfaction: Overall satisfaction about the work load and environmentYou should consider the following instructions when answering the case study project questionsand preparing your report:For the reportShould 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 SummaryMeasures and IQR STAT130Case StudySpring 2024⚫ For each variable: Find the Boxplot, and use the Boxplot to determine the shape of thedistribution 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 ofthe center of the distribution?• For each variable: Which measure, the standard deviation or IQR, is the better summarymeasure 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 femaleemployees?6. Are there significant differences for the averages of work load satisfaction between male and femaleemployees?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 employeesworking-experience?9. Is employees working-experience depend on the employees' gender?10. Based on your findings, make “practical&#34; recommendations to increase the satisfaction on the salaryand working environment for the employees in the commercial Sector

Accepted Answer

The objective of this question is to analyze the satisfaction survey data of employees in the…