1. Use Excel to compute the correlation coefficient between the following variables. (Enter the data into co lumns). Make sure you obtain the same answer using your University-approved calculator. x12345y711151923 What do you notice? Plot a scatter diagram to confirm your conclusion. 2. Use your calculator (in regression mode) to find the correlation coefficient for each of the following dat a sets (a)x.584529515203y.29171116183338 (b)x.155253020405055y.3540304540502555