Lab 3 - Graded Lab

In this lab you will work with USDA dataset - in shared files.

Write answers for analysis questions using Text Box inside Qlik View application file.

• First, we will learn how to load data into QlikView application.
• 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.
  Analysis: 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.
  Analyze the result.

• Find correlation between different components of your choice and analyze the results: for instance, Cholesterol vs. TotalFat, VitaminC vs. Calories, etc. For each pair, build an appropriate chart and perform analysis.