OPTION #1: Using Pivot Tables – Product Sold You are required to complete both parts A and B

OPTION #1: Using Pivot Tables – Product Sold

You are required to complete both parts A and B. 

Part A:

Complete Lab 2-2 Use PivotTables to Denormalize and Analyze the Data (pp. 60 – 67) in your textbook. Download Data Files Here (Links to an external site.)

Part B:

1. Your analysis should be written as an essay and should include the following:

• Introduction
• Analysis
  • Headings - Part 1, Part 2, Part 3, Part 4, and Part 5 (i.e., Part 1: Identify the Questions) – headings are shown in the Lab.
    • Part 4 – Answer Question 5 only
    • Part 5 – Answer Question 7 only
• Conclusion.

2. Submit your analysis as a Word document and submit any additional requirements noted in the Lab (i.e., Excel files, tables, etc.).

Your paper should be 3-4 pages in length, not including required cover and references pages or other files and tables, and conform to the guidelines found in the CSU Global Writing Center (Links to an external site.). Include at least two scholarly references in addition to the course textbook.  The CSU Global Library (Links to an external site.) is a good place to find these references