Share
Explore BrainMass

Product Development Correlation

The product development team at Piggybank is wondering if there is a correlation between retail online sales and total retail sales. Use the Discussion Board to work with the peer/mentor group to calculate the correlation between online and total retail sales, and interpret the results. Share examples and insights.

Give two examples of correlation which are evaluated in a business environment and discuss the decision made by evaluating the correlation. From 4th quarter 1999 - To 4th quarter 2003 calculate correlation coefficients with Excel

Attachments

Solution Preview

The correlation coefficient is a measure that determines the degree to which two variable's movements are associated. It is calculated as:
correlation coefficient = Covariance (X, Y) / [SD (Y) * SD (X)]

correlation between retail online sales and total retail sales.
Please refer to EXCEL for calculation.
Note:
Let Y = Total Retail sales, X = Online sales.
Ym = Average of Y
Xm = Average of X
Variance(Y) = Average of [(Y-Ym)^2]
Where "^2" means to the power of 2, or ...

Solution Summary

The product development team at Piggybank is wondering if there is a correlation between retail online sales and total retail sales. Use the Discussion Board to work with the peer/mentor group to calculate the correlation between online and total retail sales, and interpret the results. Share examples and insights.

Give two examples of correlation which are evaluated in a business environment and discuss the decision made by evaluating the correlation. From 4th quarter 1999 - To 4th quarter 2003 calculate correlation coefficients with Excel

$2.19