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...

1 answer below »

Results:
The boxplot of the Payment co
esponding 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 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX
MANAGERIAL XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX
SUPERVISORY XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX
TECHNICAL XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX
Table 1 : Descriptive statistics of Jobtype vs Pay
The boxplot of the Payment co
esponding 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 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX
COLLEGE XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX
HSDIP XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX
Table 2 : Descriptive statistics of Education vs Pay
The boxplot of the payment co
espomdimg 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 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX
Loc_B XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX
Loc_C XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX
Table 3 : Descriptive statistics of Location vs Pay
For 4th)
Rows: Row Variables Columns: Worksheet columns
BAMA College HSDIP All
CLERICAL XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX5755
MANAGERIAL XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX8387
SUPERVISORY XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX6564
TECHNICAL XXXXXXXXXX
XXXXXXXXXX580
XXXXXXXXXX0392
All XXXXXXXXXX
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 XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX1801
MANAGERIAL XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX0165
SUPERVISORY XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX1585
TECHNICAL XXXXXXXXXX
XXXXXXXXXX653
XXXXXXXXXX9612
All XXXXXXXXXX
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 XXXXXXXXXX
Likelihood Ratio XXXXXXXXXX
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 XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX3790
COLLEGE XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX0038
HSDIP XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX7791
All XXXXXXXXXX
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 XXXXXXXXXX
Likelihood Ratio XXXXXXXXXX

Table 9: The summary statistics for Chi square for the EDUCATION vs LOCATION
Discussion:
The side by side boxplot of the Payment co
esponding 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 co
esponding 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 co
esponding 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 XXXXXXXXXXand 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 XXXXXXXXXXand 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 cu
ent 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
eferences cited in this report.
https:
www.shrm.org/hr-today/trends-and-forecasting
esearch-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
Answered Same DayApr 09, 2022

Solution

Bikash answered on Apr 09 2022
17 Votes
Answer 5)
· 95% confidence for job satisfaction with respect to work ranges from 70.30 to 73.17 with mean of 71.74
· 95% confidence for job satisfaction with respect to pay range from 59.26 to 65.70 with mean of 62.48
· 95% confidence for job satisfaction with respect to promotion range from 65.11 to 69.65 with mean of 67.38
· Least job satisfaction is observed with respect to pay
· Highest job satisfaction is observed with respect to work
95% confidence for job satisfaction with respect to work for each location:
· Employees in location A have higher job satisfaction with respect to work as compared to location B and C
· More number of employees were surveyed in location A (44) as compared to location B and C
· Employees in location B and C have similar job satisfaction with respect to work
95% confidence for job satisfaction with respect to pay for each location:
· Employees in location A has higher job satisfaction with respect to pay as compared to location B and C
· Employees in location C are slightly more satisfied as compared to location B with respect to location B...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here