Question
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
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.
Starbuck Sales data.xlsx
Question 3 options:
Annual Net Sales = 44.4256 + 5.5406(Rent) + 0.0979(Inventory) + 3.7165(Advertising) + 2.9543(Sales) - 2.5614(Competitor)
Annual Net Sales = -49.0449 + 0.9911(Rent) + 0.9823(Inventory) + 0.9782(Advertising) + 27.6181(Sales) - 2.9766(Competitor)
Annual Net Sales = -49.0449 + 15.1571(Rent) + 0.1744(Inventory) + 12.1779(Advertising) + 14.2972(Sales) - 2.9766(Competitor)
Annual Net Sales = -1.1039+ 2.736(Rent) + 1.9204(Inventory) + 3.2767(Advertising) + 4.8384(Sales) - 1.1620(Competitor)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started