Wk 5 – Signature Assignment: Analysis of Correlation Test Data
Wk 5 – Signature Assignment: Analysis of Correlation Test Data
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. Submit your Excel spreadsheet including the output for the Correlation and Regression analyses plus the corresponding hypothesis tests. Address the following in your presentation
Create a 5- to 7-slide Microsoft PowerPoint presentation and include speaker notes. Points will be deducted for slides without 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?
Submit your assignment. Make sure to submit your Excel spreadsheet including the output for the Correlation test and the corresponding hypothesis test along with your PowerPoint presentation to earn full credit for the assignment. The Excel spreadsheet accounts for 40 points out of the 160 points available for this assignment.
Answer preview to Wk 5 – Signature Assignment: Analysis of Correlation Test Data
8 slides