Using Tax Data file:
Create a PivotTable showing Tax by Year (with Year as the Row variable).
Create a new PivotTable showing Income Average for each Year (with Year as the Row Variable)
Create a PivotTable which shows Average Yearly Income with Tax in the Rows and Income in the Columns.
Based on the data provided – Which Year has the highest Tax.
Based on the data what can you conclude?
Problem Guide:
You will manipulate and analyze data using Excel or SPSS.
You will copy charts, graphs, tables, from Excel or SPSS into a Word document.
Write a report on your findings in the Word document referencing the charts, graphs, and tables from Excel or SPSS.
The original questions must be typed out as headings, with follow up answers + charts, graphs, and tables in paragraph format, and a summary or conclusion at the end of the paper. Problems have no references limit and must be in APA format.
Rubric
Problems Grading Rubric
Criteria Ratings Pts
This criterion is linked to a Learning OutcomeIntroduction
Since the first paragraph or section of a document is assumed to be the introduction of the paper, the word ‘Introduction’ is not needed. Do not begin a paper with the word ‘Introduction’ as a heading (APA, 2020, p. 47). The paper’s title should be the first heading above the first body paragraph of your paper and must be bolded
3 to >2.0 pts
Excellent
Fully interprets the significance of the subject matter and major components of the paper
2 to >1.0 pts
Acceptable
Adequately interprets the significance of the subject matter and major components of the paper
1 to >0 pts
Unacceptable
Inadequately interprets the significance of the subject matter and major components of the paper
3 pts
This criterion is linked to a Learning OutcomeProblems
Problems test your knowledge (already gained in undergraduate) in using Excel or SPSS to manipulate and analyze data (a prerequisite in research).
Manipulation and analyzing data using Excel or SPSS.
Copy charts, graphs, and tables, from Excel or SPSS and write a report in a Word document.
38 to >25.33 pts
Excellent
Very precise analyses with clear, concise, and accurate reporting. Provides precise supporting graphs, tables, and charts
25.33 to >11.52 pts
Acceptable
Adequate analyses of problems with some deficiencies in the depth of reporting and quality. Provides some graphs, tables, and charts
11.52 to >0 pts
Unacceptable
Inadequate analyses of problems with major deficiencies in the depth of reporting and quality. Does not provide graphs, tables, and charts
38 pts
This criterion is linked to a Learning OutcomeSummary
Contextualizing the analyses.
3 to >2.0 pts
Excellent
Fully engaging. Restates the analyses, calls to action, and makes predictions
2 to >1.0 pts
Acceptable
Adequately engaging. Deficiencies in restating the analyses, some calls to action, and some predictions
1 to >0 pts
Unacceptable
Inadequately engaging. Major deficiencies in restating the analyses don’t call to action and no predictions
3 pts
This criterion is linked to a Learning OutcomeDocumentation
Grammar and Spellings
3 to >2.0 pts
Excellent
Grammatically correct, no typos, proofread for logic. No copy and paste
2 to >1.0 pts
Acceptable
A limited number of grammatical mistakes, and typos. Limited copy and paste
1 to >0 pts
Unacceptable
Major grammatical mistakes and typos. Major copy and paste
3 pts
This criterion is linked to a Learning OutcomeAPA
Writing style
3 to >2.0 pts
Excellent
Conforms to APA style of writing
2 to >1.0 pts
Acceptable
Limited conformity to APA style of writing
1 to >0 pts
Unacceptable
Nonconformity to APA style of writing
3 pts
Total Points: 50