Data Analytics Exercise 3 Fall 2020

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

admin

Author Since: November 30, 2020