Question

HELP ASAP

For the data set below, calculate the correlation between X and Y to three (3) decimal places. To Use Excel's CORREL Function 1). Open up the worksheet above and select a blank cell you might need to click "Enable Editing" to select a cell). 2). Type -CORRELL 3). For "arrayı, select the column of values for one of the variables. Remember, for correlation that it does not matter which variable you call "X" and which you call "Y." It does matter for regression, but this question is just asking about correlation. 4). Type a comma: 5). For "array2," select the other column of values. Be sure you always select the same number of X's as you do Y's: otherwise, you will get an error message or Excel will return a "#N/A" value in the cell. 6). Type ) and hit "Enter." The number that you get is the correlation Report this value to three decimal places.

Answer 1

A B C D E F G H I J Here we use CORREL () Function to find corrlation correlation = 0.212972 So the correlation between x and y is = 0.213 55 51 Means there is weak positive correlation between X and y 11 43 9