Question: Question 5(7 marks) Yummy Lunch Restaurant needs to decide the most profitable location for their business expansion. Marketing manager plans to use a multiple regression

Question 5(7 marks)

Yummy Lunch Restaurant needs to decide the most profitable location for their business expansion. Marketing manager plans to use a multiple regression model to achieve their target. His model considers yearly revenue as the dependent variable. He found that number of people within 2KM (People), Mean household income(income), no of competitors and price as explanatory variables of company yearly revenue.

The following is the descriptive statistics and regression output from Excel.

Revenue

People

Income

Competitors

Price

Mean

343965.68

5970.26

41522.96

2.8

5.68

Standard Error

5307.89863

139.0845281

582.1376385

0.142857

0.051030203

Median

345166.5

6032

41339.5

5.75

Mode

#N/A

5917

#N/A

Standard Deviation

37532.51115

983.47613

4116.334718

1.010153

0.360838027

Sample Variance

1408689393

967225.2984

16944211.51

1.020408

0.130204082

Sum

17198284

298513

2076148

140

284

Count

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.77

R Square

Adjusted R Square

Standard Error

25139.79

Observations

50.00

ANOVA

Significance F

Regression

40585376295

3.0831E-08

Residual

28440403984

Total

69025780279

Coefficients

Standard Error

t Stat

P-value

Intercept

-68363.1524

78524.7251

-0.8706

0.3886

People

6.4394

3.7051

0.0891

Income

7.2723

0.9358

0.0000

Competitors

-6709.4320

3818.5426

0.0857

Price

15968.7648

10219.0263

0.1251

You are required to;

a.Complete the missing entries from A to L in this output (2 marks)

ANSWER:

b.Derive the regression model(1 mark)

ANSWER:

c.What does the standard error of estimate tell you about the model?(1 mark)

ANSWER:

d.Assess the independent variables significance at 5% level (develop hypothesis if necessary in the analysis)? (3 marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

On August 1, Pure Joy Corporation (a U.S.-based importer) placed an order to purchase merchandise from a foreign supplier at a price of 400,000 pounds. Pure Joy will receive and make payment for the...

Question 5(7 marks) AutoSave . Off Statistics for Business Decision O Search Ricky Kafle RK X File Home Insert Design Layout References Mailings Review View Help Table Design Layout Share Comments...

Question 5 (7 marks) Yummy Lunch Restaurant needs to decide the most profitable location for their business expansion. Marketing manager plans to use a multiple regression model to achieve their...

Yummy Lunch Restaurant needs to decide the most profitable location for their business expansion. Marketing manager plans to use a multiple regression model to achieve their target. His model...

SUMMARY OUTPUT Regression Statistics Multiple R 0.79 R Square A Adjusted R Square B Standard Error 26563.53 Observations 34.00 ANOVA df SS MS F Significance F Regression C 33447876745 F H 7.94E-06...

Yummy Lunch Restaurant needs to decide the most profitable location for their business expansion. Marketing manager plans to use a multiple regression model to achieve their target. His model...

Would you be able to put together another monthly cash flow analysis, this time for year 1? INCOME STATEMENT Year 1 269,115.00 48,930.00 20,388.00 338,433.00 $ $ $ $ COGS $ 113,940.00 $ 125,940.00 $...

The present value of Azure Ltd's existing assets is $27 million with a variance of 16 percent, while the firm's debt (with a weighted average duration of 10 years), when rendered into zero coupon...

Search the HR Assistant job on the BLS site and record the median annual national pay. Is the median pay for the entry level HR role (HR assistant) what you expected as a potential first job outside...

A partnership owns property that was contributed with a built - in loss. Two years later, it is sold at a loss. How is the loss characterized and allocated?Under 7 0 4 ( c ) , built - in losses must...

Write a net ionic equation to show why the solubility of Pb(OH)2(s) increases in the presence of a strong acid and calculate the equilibrium constant for the reaction of this sparingly soluble salt...

Consider an assembly line with 20 stations. Each station has a 0.5% probability of making a defect. At the end of the line, an inspection step singles out the defective units. The inspection step...

Z Your answer is partially correct. Try again. Indicate, by using ratios, the change in liquidity and profitability of Messersmith Company from 2016 to 2017. (Round Earnings per share to 2 decimal...

The liquidity and cash management performance of short-term financing structure should not be expected from the sector which is expected to develop with long term partnerships. For this reason, there...

Firm A and Firm B are going to play a Cournot game where both players will choose cither high or low output. Firm B has been doing rescarch on a new method of production. If B's rescarch is...

1. What is being described here: How a country views the contribution of skills towards its economic and social life, finding expression in the policies and practices of the state, its agents and its...

Employee counseling and wellness programs of all types are popular in the United States, despite the relative lack of scientific evidence that conclusively supports the efficacy of these programs. If...

Suppose you were asked by your employer to develop a proposal for an employee assistance program (EAP). Which approach would you recommend: an in-house program run by employees of your organization...

Some people believe that wellness programs infringe on an individuals right to choose his or her own lifestyle, maintaining that an individual has the right to smoke cigarettes, eat junk food, and...