project economics

Journal Article ECO 302

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”.

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 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)