Analysis Procedures: What did you do to conduct your analysis?

You are in charge of conducting an analysis for your organization to discover if there is a relationship between an employee’s performance rating and the number of sick days they take each year. Your coworker has already collected the data, and they are ready for you to analyze.

Review the data that your coworker collected in the Analysis of Correlation Test Data Spreadsheet.

First, plan your analysis. Second, conduct your analysis. Third, describe your analysis.

Create a 5- to 7-slide Microsoft® PowerPoint® presentation and include speaker notes. Include the following elements in your presentation.

Part 1: Planning:
What are the null and alternative hypotheses?
Where did you obtain your data or who obtained it for you?

Part 2: Analysis
What are the descriptive statistics for your sample? Include:
Sample size
Mean
Median
Mode
Standard deviation
Analysis Procedures: What did you do to conduct your analysis?

Part 3: Results and Discussion
What are the test statistics and results? Include:
t statistic
p-value
What are the results? Are the results inferable to the population?
Do you reject or fail to reject the null hypothesis? Explain.
What do the results mean? What is your recommendation to the organization?

Participant ID
Performance Rating
Number of Sick Days
32 4 21
33 5 21
40 6 18
5 12 12
39 12 14
7 13 13
10 16 11
23 21 7
2 23 12
42 23 14
50 23 5
20 25 12
24 32 11
27 32 10
13 34 10
48 34 6
38 42 7
19 53 9
16 56 8
29 56 10
31 56 8
43 56 21
46 56 21
6 64 20
30 65 19
34 65 10
45 65 10
1 67 9
18 67 7
21 67 4
28 67 2
35 67 12
49 67 1
8 68 1
37 73 1
12 74 3
4 75 4
44 76 5
14 78 2
3 83 2
47 84 7
36 87 5
26 89 9
15 90 10
22 90 4
9 95 4
11 96 1
17 97 5
25 98 1
41 99 6