This is about using multiple Linear Regression with indicator variable with 10 stores.Key question is deciding on management choice.Need to decide who to promote and how much to pay them.Need description and the answer with details at to why and who the manager is that was chosen.There are four managers to choose from.

Alice runs locations 1, 5 and 6. Bill runs locations 2 and 9. Chauncey runs locations 3 and 10. Lastly, Deter runs locations 4, 7 and 8.

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.

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.

Clearly and fully state the relationship to be analyzed

Perform the Linear Regression

Correctly and clearly interpret all the parameter results from the regression

Consider all of the data in terms of each of the four components, Linear Parameters, Random Sampling,

Sample Variation in the Explanatory Variable

Zero mean of the error term conditional on the independent variables

Big Grocery

Revenue

Square Footage

Population

Manager

Location 1

Revenue 23,665,319.22

Square Footage 48,720.39

Population 146073

Alice

Location 2

Revenue 20,066,838.98

Sq Ft 40,778.72

Pop 134878

Bill

Location 3

Rev 23,508,691.46

Sq Ft 21,654.19

pop 225131

Chauncey

Location 4

Rev 11,748,300.32

Sq ft 33,344.11

Pop 49987

Deter

Location 5

rev 33,450,105.86

sq ft 116,006.40

pop 89939

Alice

Location 6

rev 18,248,754.69

sq ft 44,655.98

pop 53514

Alice

Location 7

rev 10,943,196.86

sq ft 8,549.08

pop 127423

Deter

Location 8

rev 32,934,788.04

sq ft 157,424.48

pop 26790

Deter

Location 9

rev 16,821,187.57

sq ft 63,075.32

pop 17092

Bill

Location 10

rev 19,285,241.45

sq ft 53,256.79

pop 86985

Chauncey