Below is the information I am needing help with on what I am trying to accomplish. I have been given histogram with information and ran a data analysis and am now having trouble determining which manager I would choose and second guessing myself on my entire analysis.

Assignment:

You are the CEO of Big Grocery. Your company is planning on expanding into new markets. As a part of this endeavor you are expected to make decisions on things such as store size, location and management. To help you make this decision you ask a subordinate (its good to be the CEO) to compile some data for you to help with making your decision. The data is outlined in the Part 1 document and is copied below. The key question that we want to address is how do you decide on the management choice for your new store? You have several managers which were introduced in Part 1. You need to decide who to promote to the position of management for the new store. Assume you are going to pick one of your current managers take over the new store. Use MLR to estimate the manager's impact on revenue after controlling for the other important variables for which you have data. Justify your estimate, and make a decision on who to promote in your document.

Information provided that I put in excel format to run an analysis:

Multiple Linear Regression - Big Grocery

Revenue Square footage Population Alice Bill Chauncey

$ 23,665,319.22 48720.39 146073 1 0 0

$ 20,066,838.98 40778.72 134878 0 1 0

$ 23,508,691.46 21654.19 225131 0 0 1

$ 11,748,300.32 33344.11 49987 0 0 0

$ 33,450,105.86 116006.4 89939 1 0 0

$ 18,248,754.69 44655.98 53514 1 0 0

$ 10,943,196.86 8549.08 127423 0 0 0

$ 32,934,788.04 157424.48 26790 0 0 0

$ 16,821,187.57 63075.32 17092 0 1 0

$ 19,285,241.25 53256.79 86985 0 0 1

Data Analysis received from above information from excel:

Regression Statistics

Multiple R 0.997838966

R Square 0.995682603

Adjusted R Square 0.990285856

Standard Error 753750.6921

Observations 10

ANOVA df SS MS F Significance F

Regression 5 5.241E+14 1.0482E+14 184.4968264 8.11978E-05

Residual 4 2.27256E+12 5.6814E+11

Total 9 5.26373E+14

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%

intercept 1866376.736 824571.5015

Square footage 186.4998646 6.709996059

Population 62.95022791 5.336192308

Alice 4163154.539 636926.1643

Bill 2109981.271 693293.1846

Chauncey 2721259.138 800988.8029

Is my equation correct? = 1866376 + 186.50 (sq.ft) + 62.95(population) + 4163154.53 (MgrAlice) + 2109981.27 (MgrBill) + 2721259.14 (MgrChauncey)

Also, I am needing help with identifying which manager would be best to select with my results along with considering each of the sufficient conditions which are below (especially needing help with #4 - PLEASE!)

1. Linear in Parameters
2. Random Sampling
3. Sample Variation in the Explanatory Variable
4. Zero mean of the error term conditional on the independent variable <--- need the most explanation and help here and figuring out the best manager pick for the job on the overall analysis.

Please help! I am more than happy to supply any extra information you may need.