Data Analytics Exercise 3 Fall 2020
In this exercise, students will conduct a One-Way ANOVA using SAS. The student will create a summary report of their analysis and create an informative graphic that is included in a business memorandum that provides a recommendation based on their analysis of the dataset.
Our research question is “Is there a difference in employee pay by location for our company?” You need to turn this question into a statistical question that you can answer using this data.
To help you get started, we have provided an additional video presentation and PowerPoint discussing the concept of ANOVA. You need to be logged into your my.troy.edu account to access these videos.
Note: You at a minimum you required to provide this example of Summary and Anova Tables required to show you performed the ANOVA in SAS: DAX ANOVA Tables Required.pdf
Instructions
DAX3 ANOVA Video (Links to an external site.)
DAX3 ANOVA PowerPoint
Once you are ready, you can download the step-by-step instructions and view the video by clicking on these links:
DAX3 Instructions 2020.pdf
Help
Anova Interpretation – Student v1-3.pdf
Finally, when you are ready to work on your DAX3 Report, you can download the deliverable “Business memo” file here:
Deliverable
Rubric
DAX3 (Fall 2020)
DAX3 (Fall 2020)
| Criteria |
Ratings |
Pts |
| This criterion is linked to a Learning OutcomeBusiness Memo submitted on time |
| 10.0 ptsFull Marks |
0.0 ptsNo Marks |
|
10.0 pts |
| This criterion is linked to a Learning OutcomeSalutationCorrect salutation, date, subject line, etc. |
| 5.0 ptsFull Marks |
0.0 ptsNo Marks |
|
5.0 pts |
| This criterion is linked to a Learning OutcomeMethod discussionParagraph 2 provides an explanation of any steps taken and discusses if ANOVA is appropriate to run on this data. Tables and graphs should be referenced. |
| 20.0 ptsFull Marks |
15.0 ptsMostly Correct |
10.0 ptsPartially Correct |
5.0 ptsMostly Incorrect |
0.0 ptsNo Marks |
|
20.0 pts |
| This criterion is linked to a Learning OutcomeEvidenceAppropriate tables and graphs. This should include graphs/plots to verify the assumptions, a summary statistics table, the ANOVA results, boxplots, etc. |
| 20.0 ptsFull Marks |
15.0 ptsMostly Correct |
10.0 ptsPartially Correct |
5.0 ptsMostly Incorrect |
0.0 ptsNo Marks |
|
20.0 pts |
| This criterion is linked to a Learning OutcomeSummaryParagraph 3 summarizes the results discussing whether the results of the ANOVA are significant, clearly states whether the null hypothesis is rejected, and identifies if there are any levels of the categorical variable where the mean is significantly different. Appropriate tables and figures should be referenced. |
| 25.0 ptsFull Marks |
19.0 ptsMostly Correct |
13.0 ptsPartially Correct |
7.0 ptsMostly Incorrect |
0.0 ptsNo Marks |
|
25.0 pts |
This criterion is linked to a Learning OutcomeConclusionParagraph 4 provides a conclusion based on the student’s analysis, clearly provides an interpretation and recommendation of the results and the impact of the recommendation.
The conclusion is the plain language answer to the research question and what steps we should take next to find the answer to our question. |
| 20.0 ptsFull Marks |
15.0 ptsMostly Correct |
10.0 ptsPartially Correct |
5.0 ptsMostly Incorrect |
0.0 ptsNo Marks |
|
20.0 pts |
| Total Points: 100.0 |
