1. Run a single regression using the above data. (with profit as the dependent variable and Food Sales as independent variable).

2. Run a single regression using the above data. (with profit as the dependent variable and Nonfood Sales as independent variable).

3. Run a single regression using the above data. (with profit as the dependent variable and Store Size as independent variable).

You have to use Microsoft Excel to run regression in order to get full credits in the project. For how to use regression analysis in Excel, please refer to Chapter 10 Appendix or go to D2L -> Content -> Document Sharing -> Excel Data Analysis then download the file "ECO 302 Excel Lessons" Sample Data for Supermarket Profits. Supermarket Food Sales Nonfood Sales Store Size Profit Number (tens of thousands | (tens of thousands (thousands of (thousands of of dollars) of dollars) square feet) dollars) X1 X2 X3 F 305 35 35 20 130 98 22 15 189 83 27 17 175 76 16 9 101 93 28 16 6 269 77 46 27 421 44 56 35 09 -1 195 57 12 7 282 31 40 22 10 203 92 32 23 1. Run a single regression using the above data. (with profit as the dependent variable and Food Sales as independent variable). Profit = by + b" * Food Sales| 2. Run a single regression using the above data. (with profit as the dependent variable and Nonfood Sales as independent variable). Profit = b + b" * Nonfood Sales 3. Run a single regression using the above data. (with profit as the dependent variable and Store Size as independent variable). Profit = by + bm * Store Size You have to indicate the purpose of the study, why you believe such a study could be important for a business and discuss the characteristics of each data (for example, descriptive statistics). You should compare the performance of three regressions according to what the instructor taught in the online class live. In addition, you should also discuss which equation is preferable, and why it is preferable. It should be 2 pages plus Appendix. (Excel printouts should be included in the Appendix)