Lab Practice
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