Question 7: Download the attached Excel spreadsheet. This spreadsheet contains data for two variables X and Y. Our X variable is our independent variable and our Yvariable is our dependent variable. Using the correlation function in Excel type "correlox variable, Yvariable calculate the r value Ther value for this data set is Correlation Problem sx 10 KB A. 0.05 80.24 OC 0.49 D. 0.78 Reset Selection 1 Points Question 9 of 11 strength of assocation Based on your calculated Correlation coefficient in the previous problem, your restarch group determines there is a between these two variables O A Very strong O 8 Strong OC Moderate OD Weak O E Very weak SAWA 3 . C D X 1 1 14 . 14 TI 1 15 18 30 15 10 10 18 ya 7 16 17 To calculate our correlation coefficient, bewure to use Excel's correlation function You must type c) where X represents all data under in your column and represents a date in your Y column 22 20 10 13 Question 7: Download the attached Excel spreadsheet. This spreadsheet contains data for two variables X and Y. Our X variable is our independent variable and our Yvariable is our dependent variable. Using the correlation function in Excel type "correlox variable, Yvariable calculate the r value Ther value for this data set is Correlation Problem sx 10 KB A. 0.05 80.24 OC 0.49 D. 0.78 Reset Selection 1 Points Question 9 of 11 strength of assocation Based on your calculated Correlation coefficient in the previous problem, your restarch group determines there is a between these two variables O A Very strong O 8 Strong OC Moderate OD Weak O E Very weak SAWA 3 . C D X 1 1 14 . 14 TI 1 15 18 30 15 10 10 18 ya 7 16 17 To calculate our correlation coefficient, bewure to use Excel's correlation function You must type c) where X represents all data under in your column and represents a date in your Y column 22 20 10 13