You are thinking about opening up a Starbucks in your area but what to know if it is a good investment. How much money do Starbucks actually make in a year? You collect data to, to help estimate Annual Net Sales, in thousands, of dollars to know how much money you will be making. You collect data on 27 stores to help make your decision. x1 = Rent in Thousand per month x2 = Amount spent on Inventory in Thousand per month x3 = Amount spent on Advertising in Thousand per month x4 = Sales in Thousand per month x5= How many Competitors stores are in the Area Find the estimated regression equation which can be used to estimate Annual Net Sales when using these 5 variables are predictor variables. See Attached Excel for Data.\

b₀: -49.17 thousand dollars represents the estimated average annual net sales when the monthly rent, the inventory expenses, the advertising expenses, the monthly sales and the number of competitors in the area are zero.

b₁: 15.03 represents the variation in the estimated average annual sales when the monthly rent increases $1000 and all other variables remain constant.

b₂: 0.17 represents the variation in the estimated average annual sales when the inventory expenses increase $1000 and all other variables remain constant.

b₃: 12.23 represents the variation in the estimated average annual sales when the advertisement expenses increase $1000 and all other variables remain constant.

b₄: 14.29 represents the variation in the estimated average annual sales when the monthly sales increase $1000 and all other variables remain constant.

b₅: -2.96 represents the variation in the estimated average annual sales when the number of competitors in the area increase in one unit and all other variables remain constant.

I hope this helps!