Explore BrainMass

Statistics: Advertising and sales, correlation analysis

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 ?


Solution Preview


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 ...

Solution Summary

MS excel file contains calculations for correlation coefficient using formula.