Assignment: Business Analytics & Research Methods

1. Create a PivotTable showing Tax by Year (with Year as the Row variable).
2. Create a new PivotTable showing Income Average for each Year (with Year as the Row Variable)
3. Create a PivotTable which shows Average Yearly Income with Tax in the Rows and Income in the Columns.
4. Based on the data provided - Which Year has the highest Tax.
5. Based on the data what can you conclude?

Problem Guide:

1. You will manipulate and analyze data using Excel or SPSS.
2. You will copy charts, graphs, tables, from Excel or SPSS into a Word document.
3. Write a report on your findings in the Word document referencing the charts, graphs, and tables from Excel or SPSS.