Assignment 2: 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.
o 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.
Submit your answers in a two- to three-page Microsoft Word document and a Microsoft Excel sheet.
Answer will be sent by email. It may take few hours to send the answer. You may email us if you have any query.
