Excel spreadsheet you provided
I calculated the correlation coefficient for data at .891. Can you please use
this data and Excel spreadsheet and provide the calculations to arrive at
the correlation coefficient of .891? In addition, what would the
correlation coefficient of .891 tell us about the data ?
Please see the excel file attached for the calculations.
Worksheet "Calculation of correlation coeff" contains calculations for correlation coeff. using formula.
Worksheet "regression analysis" contains regression output for ...
MS excel file contains calculations for correlation coefficient using formula.