Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The owner of a restaurant in Tucson, has recorded sales data for the past several years. He has alio recorded dots on potentially relevant variables.

image text in transcribed
image text in transcribed
image text in transcribed
The owner of a restaurant in Tucson, has recorded sales data for the past several years. He has alio recorded dots on potentially relevant variables. The data tab has the necessary data. 1. Estimate a simple linear regression equation involving annual sales (the dependent variable) and the size of the population (the explanatory varlable). Interpret the R square and p values 10 points ( 6 points for linnes regression/equation work and 4 points for interpreting the values) 2. Estimate a simple linear resression equation involving annual sales (the dependent variable) and adyertialig expenditure (the explenatory voriable). interpret the R square and p values. Is thly model better than the first model in question 1 - 10 points ( 6 points for linnear regreselon/equation work and 4 points for interpreting the values) 3. Estimate a muitiple linear regresaion equation inwolving annual sales (the dependent vatiable) and the slze of the population, advertising expenditure (the explaratory variables), Interpret the A square value \& p values- 20 points ( 15 points for multiple recression/equation, 5 points for interpreting the values) Please Note: Solution subrnission should have 3 new tabs (1 for each questions 1-3 above). Solution can be done with Excel fegression if you prefer to keep it simple and just use Excel Year12345678910111213141516171819Sales$15,713$12,937$12,872$16,227$15,388$13,180$17,199$20,674$20,350$14,444$17,530$16,711$9,715$12,248$13,856$15,285$15,620$17,158$17,800Population102,558101,792104,347106,180106,562105,209109,185109,976110,659111,844111,576113,784112,482116,487117,316117,830118,148118,481121,069Advertising$20,000$15,000$25,000$30,000$15,000$25,000$35,000$40,000$20,000$25,000$35,000$5,000$12,000$16,000$21,000$22,000$24,000$26,000$28,000 The owner of a restaurant in Tucson, has recorded sales data for the past several years. He has also recorded data on potentiatly relevant variables. The data tab has the necessary data. 1. Estimate a simple linear regression equation involving anmual sales (the dependent variable) and the size of the population (the explanatory variable). Interpret the H square and p values - 10 points ( 6 points for linnear regression/equation work and 4 points for Interpreting the values) 2. Estimate a simple lineat regression equation involving annual sales (the dependent variable) and advortising expenditure (the explanatory variable). Interpret the R. square and p vahwes. Is this model better than the first model in question 1 - - 10 points ( 6 points for linnear regression/equation work and 4 points for interpreting the values) 3. Ertimate a multiple linear regresslon equation involving annual sales (the dependent variable) and the size of the population, advertising expentiture (the explanatory variables) interpret the f rquare value \& p values. 20 points ( 15 points for multiple regression/equation, 5 points for interpreting the values) Please Note: Solution submission should have 3 new tabs ( 1 for each questions 1-3 above). Solution can be done with txcel hegression if you prefer to keep it simple and just use Frcel The owner of a restaurant in Tucson, has recorded sales data for the past several years. He has alio recorded dots on potentially relevant variables. The data tab has the necessary data. 1. Estimate a simple linear regression equation involving annual sales (the dependent variable) and the size of the population (the explanatory varlable). Interpret the R square and p values 10 points ( 6 points for linnes regression/equation work and 4 points for interpreting the values) 2. Estimate a simple linear resression equation involving annual sales (the dependent variable) and adyertialig expenditure (the explenatory voriable). interpret the R square and p values. Is thly model better than the first model in question 1 - 10 points ( 6 points for linnear regreselon/equation work and 4 points for interpreting the values) 3. Estimate a muitiple linear regresaion equation inwolving annual sales (the dependent vatiable) and the slze of the population, advertising expenditure (the explaratory variables), Interpret the A square value \& p values- 20 points ( 15 points for multiple recression/equation, 5 points for interpreting the values) Please Note: Solution subrnission should have 3 new tabs (1 for each questions 1-3 above). Solution can be done with Excel fegression if you prefer to keep it simple and just use Excel Year12345678910111213141516171819Sales$15,713$12,937$12,872$16,227$15,388$13,180$17,199$20,674$20,350$14,444$17,530$16,711$9,715$12,248$13,856$15,285$15,620$17,158$17,800Population102,558101,792104,347106,180106,562105,209109,185109,976110,659111,844111,576113,784112,482116,487117,316117,830118,148118,481121,069Advertising$20,000$15,000$25,000$30,000$15,000$25,000$35,000$40,000$20,000$25,000$35,000$5,000$12,000$16,000$21,000$22,000$24,000$26,000$28,000 The owner of a restaurant in Tucson, has recorded sales data for the past several years. He has also recorded data on potentiatly relevant variables. The data tab has the necessary data. 1. Estimate a simple linear regression equation involving anmual sales (the dependent variable) and the size of the population (the explanatory variable). Interpret the H square and p values - 10 points ( 6 points for linnear regression/equation work and 4 points for Interpreting the values) 2. Estimate a simple lineat regression equation involving annual sales (the dependent variable) and advortising expenditure (the explanatory variable). Interpret the R. square and p vahwes. Is this model better than the first model in question 1 - - 10 points ( 6 points for linnear regression/equation work and 4 points for interpreting the values) 3. Ertimate a multiple linear regresslon equation involving annual sales (the dependent variable) and the size of the population, advertising expentiture (the explanatory variables) interpret the f rquare value \& p values. 20 points ( 15 points for multiple regression/equation, 5 points for interpreting the values) Please Note: Solution submission should have 3 new tabs ( 1 for each questions 1-3 above). Solution can be done with txcel hegression if you prefer to keep it simple and just use Frcel

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance And Financial Markets

Authors: Keith Pilbeam

3rd Edition

023023321X, 978-0230233218

More Books

Students also viewed these Finance questions