Lab 3 - Mini Graded Lab

In this lab you will work with USDA dataset.

• Create a new sheet, called it Lab3
• Buid a bar chart with Expression Group. Dimension: Description. Expressions: Sum(Cholesterol), Sum(Calories), Sum(VitaminC). To create an Expression Group, highlight second expression and select Group. Perform the same action with the third exression. Sort by Y-Value in Descending Order. On Dimensions Limit Tab, show only 10 Largest value and clear Show Others. Find an item with MAX Cholesterol, MAX Vitamin C and MAX Calories.

• Build a Scatter Chart to find a correlation between Carbohydrate and Protein content in different foods. Dimension: Description. Expressions: X: Carbohydrate, Y: Protein. On Presentation Tab, make symbol size 6pt. Describe the result.

• Bonus: If time permits, find correlation between different components: for instance, Cholesterol vs. TotalFat, VitaminC vs. Calories, etc.