Share
Explore BrainMass

Correlation Analysis of Wal-Mart vs. Sears

Using Microsoft Excel, create a correlation analysis of Wal-Mart's annual net income over the past 10 years compared with Sears's annual net income over the past 10 years and interpret the results.

Do both companies' net incomes fall during a recession?

Using Microsoft Excel, create a multiple regression equation that explains Wal-Mart's annual net income and interpret the results.

Using Microsoft Excel, create a multiple regression equation that explains Sears's annual net income and interpret the results.

Solution Preview

Your tutorial is in Excel and Word (attached). The sources for the data are in the textbox at the top of each column in Excel (put your mouse over cell). I obtained the Net Income for Walmart from 2001-2010 and the net income for ...

Solution Summary

Your tutorial is in Excel and Word (attached). The sources for the data are in the textbox at the top of each column in Excel (put your mouse over cell). I obtained the Net Income for Walmart from 2001-2010 and the net income for Sears Holdings from 2006 (inception) to 2010. I correlated the two earnings and discussed the outcome. I then ran a regression against earnings with US population over age 15, S&P price earnings ratio, 10 year treasury rate and inflation rates from 2001 - 2010. The regressions are interpreted. Five references to show the source of the data used are given.

$2.19