Question 4: Let's say x= 1, 2, 3 and Y= 6, 4, 3. Please find a. ) Correlation coefficient r (show by hand or by using = correl function in excel). Also, what does our correlation r tell us? Please explain. b. ) Now find our r squared (also known as Coefficient of determination). What does this r squared tell us? Please explain. c. ) Find the average of x and the averages of y (use = average () function in excel). d. ) Find the standard deviation of x with excel (use =stdev.s function). Also, find standard deviation of y with excel (use=stdev.s function). e. ) For Y= b1*X + b0. Find b1 by hand showing b1= r(sy/sx) where sy= standard deviation of y and sx= standard deviation of X. Also, bo= (Average of Y) - b1*(Average of X)