Lab Practice Nov 2

Part 1

• Open QlikView
• Load Wine Data
• Bar Chart: Price per Year
• Scatter Chart: AGST vs Price (Dimension: Year)
• Scatter Chart: Harvest Rain vs Price (Dimension: Year)
• For both Scatter Charts - on Axes Tab, clear Forced 0 fot X and Y
• For both Scatter Charts - on Presentation Tab, make symbol size = 6pt

Answer the following question: What is the correct relationship between harvest rain, average growing season temperature, and wine prices? Choose the answer below

• More harvest rain increases the price and higher temperatures increase the price
• More harvest rain increases the price and higher temperatures decrease the price
• More harvest rain decreases the price and higher temperatures increase the price
• More harvest rain decreases the price and higher temperatures decrease the price

Part 2

• Create a new Sheet: AGST
• Copy Scatter Plot: AGST vs Wine to the new sheet
• A simple option for the prediction line will be flat line at the average price, in this case 7.07.
• On the Expression Tab, select Advanced Mode Highlight Price Expression and add Average Trendline
• Add Statistics Object for Price with Average, Min and Max values

Part 3

• Create Linear Chart.
  Dimension: AGST
  Expressions:
  Only(Price)
  7.07
  0.5*Only(AGST)-1.25
• Add the following expressions to the Line Chart:
  Only(Price)-(0.5*Only(AGST)-1.25)
  Only(Price)-7.07
• Add Show Values on Data Points for both Expressions
• Enable X-Axis Scrollbar
• Observe the error for each Data Point