Use the Bureau of Labor Statistics (BLS) data that you used for the pivot table assignment earlier this term to try to understand better the market for your company.
Create 3 (three) Pivot Tables (on three separate spreadsheets) that you think show meaningful information for your company, considering such factors as the age of your customers, BLS expenditure categories/sub-categories, and geographic regions. (Hint: If you like, you can copy a pivot table you created for the pivot table assignment into your workbook for this assignment and then manipulate it further as needed.)
Create a Pivot Chart for one of your three pivot tables.
Note: Instead of looking at the dollar values, you may find it more interesting or useful in your analyses to look at percentages—how a given cell constitutes a percentage of its column total, row total, or the grand total. To do that
• Click anywhere in the pivot table,
• Right-click and select “Value Field Settings.”
• Select the “Show Values as” tab
• Scroll down to select “% of Column Total, ” “% of Row Total, ” or “% of Grand Total, ”
• Adjust the decimal places as necessary
In Your Report for Part 2: Discuss the insights you have gained from some or all of your three pivot tables. Include in your discussion any limitations of the BLS data and identify any additional data elements or dimensions that would have been useful.
