Share
Explore BrainMass

Sales Equation, Correlation Coefficient and Coefficient of Determination

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

Attachments

Solution Summary

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

$2.19