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 it is ready for you to analyze.

Review the data 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

133 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