Unit 3 Module 1 Application Assignment
Unit 3 Module 3 Application Assignment
1. Download the attached file, CPSC-LOA-Data-MM-DD-2016.csv, and save to the desktop
2. Open Excel
3. Import CPSC-LOA-Data-MM-DD-2016.csv, this is a delimited comma separated file
4. Create a pivot table (named Primary Violation) showing Sum of LOT size and Primary Violation, then sort greatest to least
5. Create a second pivot table (named Country) showing Sum of LOT size and country, the sort greatest to least.
6. Save file as FirstInitialLastNameBUSA2205Unit3Mod3.xlsx (DBridgesBUSA2205Unit3Mod3.xlsx)
NOTE: there should be three worksheets total in this workbook when it is turned in.