Explore BrainMass
Share

Explore BrainMass

    Sales Equation, Correlation Coefficient and Coefficient of Determination

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

    Problem 24
    Consider the following annual sales data for 1996-2003, use the linear regression method and
    a. determine the estimated sales equation.
    b. determine the correlation coefficient and the coefficient of determination.

    Year .....Sales
    1996 ........2
    1997 ........4
    1998 ........10
    1999 ........8
    2000 ........14
    2001 ........18
    2002 ........17
    2003 ........20

    © BrainMass Inc. brainmass.com October 9, 2019, 8:48 pm ad1c9bdddf
    https://brainmass.com/business/sales-equation-correlation-coefficient-and-coefficient-of-determination-163189

    Attachments

    Solution Summary

    Excel is used to find a Sales Equation, Correlation Coefficient and Coefficient of Determination.

    $2.19