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