I need someone to complete this

1 answer below »
I need someone to complete this
Answered Same DayFeb 09, 2021

Answer To: I need someone to complete this

Pooja answered on Feb 09 2021
138 Votes
README
    INSTRUCTIONS
    QMB3200
    Case Participation Assignment
    For this assignment you will work With your team or individually on the PERFORMANCE LAWN EQUIPMENT case of your Evans Textbook.
    The HR department is concerned w
ith the high rate of turnover in its field service staff. Senior managers have suggested that the
    department look closer at its recruiting policies, particularly to try to identify the characteristics
    of individuals that lead to greater retention. However, in a recent staff meeting, HR managers
    could not agree on these characteristics. Some argued that years of education and grade point
    averages were good predictors. Others argued that hiring more mature applicants would lead to
    greater retention. To study these factors, the staff agreed to conduct a statistical study to
    determine the effect that years of education, college grade point average, and age when hired
    have on retention. A sample of 40 field service engineers hired ten years ago was selected to
    determine the influence of these variables on how long each individual stayed with the company.
    Data are compiled in the Employee Retention worksheet
    The following information was collected for the 40 subjects in the study :
    YearsPLE    Employee duration (length of hire)
    YrsEducation    Years of education
    College GPA    Employee GPA
    Age    Age of the employee when hired
    Gender    Employee gender
    College Grad    Whether employee had a college degree
    Local    Whether employee is from the local area
     Using the Employee Retention worksheet
    1. Create a random sample of 35 employees using excel RAND() Function. Then copy your sample to the DATA sheet and use it to respond to the questions below.
    2. Compute the descriptive statistics for each of the variables in the dataset and use appropriate graphs to illustrate their distribution
    3.  Create Pivot tables that summarize the data and provide useful insights about factors that affect employee retention. Illustrate with graphs when appropriate.
    4. Are there statistically significant differences in employee retention due to gender, college graduation status, or whether the employee is from the local area?
Employee Retention
    Employee Retention
    YearsPLE    YrsEducation    College GPA    Age    Gender    College Grad    Local    r....
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here