Explore BrainMass

Explore BrainMass

    Statistics: Advertising and sales, correlation analysis

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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 ?

    © BrainMass Inc. brainmass.com December 24, 2021, 5:48 pm ad1c9bdddf
    https://brainmass.com/business/business-math/statistics-advertising-and-sales-correlation-analysis-71324

    Attachments

    Solution Preview

    Hello

    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.

    $2.49

    ADVERTISEMENT