Pivot Table

Description

Analyze the given data set and visualize appropriate charts using pivot tables.

Data_Set: Food-Nutrients.xlsx
Data_Source: More sample data file. (n.d.). In Contextures. 

Answer questions 1 through 6 in one Excel sheet
For questions 7 & 8, use a separate individual Excel sheet for the chart and its corresponding story

(1 point) Data domain
(1 point) Data source
(1 point) Number of records
(2.5 points) A detailed explanation of attributes
(1 point) Assumptions, if any
(4.5 points) Write any three goals to analyze the data
(4.5 points) Draw the appropriate pivot charts for the goals you had taken
(4.5 points) Write the stories for the charts you had drawn

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top