Hi,

I am doing a study case in my statistic class and I was wondering how to do the following two questions:

6)Suppose that an employee is 'dissatisfied' with the job if the degree of satisfaction for at least one of the 3 expressed satisfactions (work, pay or promotion) is less than 70. Perform tests to determine if employees are dissatisfied with their job.

7)What can be said about the relationships between the job satisfaction variables? Discuss on the basis of scatter plots and correlations of the relevant variables.

Study case description:

Nasee Inc. runs a Chain store 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.

Use appropriate (applicable) methods of descriptive statistics, including tables and plots, to summarize the data (depending on the data type - quantitative continuous or discrete and qualitative or categorical). That is, an appropriate tables of descriptive statistics (mean, standard deviation, coefficient of variation, quartiles, IQR, correlations) is needed and appropriate plots (histograms, dotplots, bar/pie charts, stem plots, boxplots, scatterplots) of the variables, overall and when appropriate, by categories. You are expected to produce displays that will allow you to describe the distribution in terms of symmetry, dispersion, and outlying observations. Present the summaries of statistical results that will be beneficial in communicating to others. The results must be fully discussed and clearly explained in context addressing the issues.

Here is the link to access the data for the study case: https://docs.google.com/spreadsheets/d/1oHqlz4EPn5ZYaauDa-ymr9GhvJsGw6UJI3UjC55lWA0/edit?usp=sharing