GER1000 Quiz 2: Correlation and association

GER1000 Quiz 02:

Key Notes:
1) Scatter Diagram using Excel
2) =STDEV(array of numbers) using Excel to calculate standard deviation
3) =CORREL(array1, array2) using excel to calculate correlation
4) Standard Unit of Data = (Data – Average) / Standard Deviation

Question 1) Option V) CORREL(B2:B6,C4:C8)
    Common sense.
Question 2) Option V) (iii) only
It is a measure of linear association between two variables √ range between −1 and 1, and it summarizes the direction and strength of linear association.
Question 3) Option II) 1.25
    Standard Unit = (72 – 71) / 0.8 = 1.25
Question 4) Option II) 0.1 to 0.5
Answer: 0.209631
Question 5) Option V) Both I and ii
    Removing sets of data will change the coefficient correlation
Question 6) Option I) The average of Y is larger than the average of X.
    Common sense to read the graph properly.