Employee Satisfaction and Sick Days Taken: Pearson Correlation Report

Sigchi4life
Category:
Management
Price: $40 USD

Question description

Employee Satisfaction and Sick Days Taken: Pearson Correlation Report



Muat be familiar with Pearson correlation computations in Microsoft Excel and assignment needs to be submitted by 6:00pm est

Assignment 2: RA 2: Employee Satisfaction and Sick Days Taken: Pearson Correlation Report

For this assignment, you will read a brief scenario, analyze two data sets, and conduct a Pearson correlation in Microsoft Excel. You will justify the results in a 10- to 12-page report following the directions below.

Background Scenario:

Company ABC has hired you to conduct an employee satisfaction survey. You have conducted the survey and received the satisfaction scores of twenty participants. Company ABC is asking that you work with human resources (HR) by obtaining a report on the number of sick days for the twenty employees who completed your employee satisfaction survey. You are to take both sets of data and conduct a Pearson correlation to determine whether there is a relationship between employee satisfaction and the number of sick days taken. Assume the survey and the sick days are being measured over a one-year time frame.

Click here to view the data.

Directions:

Using the data sets provided, conduct a Pearson correlation (in Microsoft Excel). In a 10- to 12-page report to company ABC, which includes the Microsoft Excel data results sheet, address the following:

  • Include an executive summary explaining your findings.
  • Summarize for the client what a Pearson correlation is and why it was chosen for this analysis. Discuss the validity and reliability of a Pearson correlation.
  • Explain the type of correlation you discovered, if any. State the specific correlation coefficient and be specific as to whether it was positive or negative. Also, indicate whether the results were significantly positive or negative.
  • Describe the results from your statistical analysis, indicating the relationship between employee satisfaction and sick days taken in a year.
  • Determine what other variables may have impacted this relationship and the scores of the employee satisfaction survey.
  • Justify what research, if any, supports your findings on satisfaction and sick days.
  • Include a copy of your Pearson correlation computations in Microsoft Excel.

Your final product will be in a Microsoft Word document of approximately 10 to 12 pages. Utilize four to five scholarly sources in your research. Your document should be written in a clear, concise, and organized manner; demonstrate ethical scholarship in accurate representation and attribution of sources; and display accurate spelling, grammar, and punctuation.


Tutor Answer

(Top Tutor) Daniel C.
(997)
School: Carnegie Mellon University
PREMIUM TUTOR
Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1823 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors