The owner of Original Italian Pizza restaurant chain wants to understand which variable most strongly influences the sales of his specialty deep-dish pizza. He has gathered data on the monthly sales of deep-dish pizzas at his restaurants and observations on other potentially relevant variables for each of several outlets in central Indiana. These data are provided in the file P10_04.xlsx. Estimate a simple linear regression equation between the quantity sold (Y) and each of the following candidates for the best explanatory variable: average price of deep-dish pizzas (X1), monthly advertising expenditures (X2), and disposable income per household in the areas surrounding the outlets (X3). Round your answers for intercept coefficients to the nearest whole number and slope coefficients to two decimal places, if necessary. If your answer is negative number, enter "minus" sign. The owner of Original Italian Pizza restaurant chain wants to understand which variable most strongly influences the sales of his specialty deep-dish pizza. Hehas gathered data on the monthly sales of deep-dish pizzas at his restaurants and observations on other potentially relevant variables for each of several outletsin central Indiana. These data are provided in the file P10_04.xlsx. Estimate a simple linear regression equation between the quantity sold (Y) and each of thefollowing candidates for the best explanatory variable: average price of deep-dish pizzas (X₁), monthly advertising expenditures (X2), and disposable incomeper household in the areas surrounding the outlets (X3). Round your answers for intercept coefficients to the nearest whole number and slope coefficients to twodecimal places, if necessary. If your answer is negative number, enter "minus" sign.Ŷ =ŷ =++X1+X2X3Ŷ =Which variable is most strongly associated with the number of pizzas sold? Explain your choice.The variable most strongly associated with the number of pizzas sold is the monthly advertising expenditurescorrelation coefficient with the quantity soldbecause it has the strongest 1234567891011234 15 16121314AOutlet Number12345600789DELE HE101112131415BQuantity Sold85,30040,50061,80050,80060,60079,40071,40070,70055,60070,90077,20063,20071,10055,50042,100CAverage Price$10.14$10.88$12.33$12.70$12.29$9.79$11.26$11.23$11.97$12.07$10.68$12.49$12.36$9.96$11.77DMonthly Advertising Expenditures$64,800$42,800$58,600$46,500$50,700$60,100$55,600$57,900$52,100$60,700$64,400$55,600$60,900$47,200$46,100EDisposable Income per Household$42,100$38,300$41,000$43,300$44,000$41,200$41,700$43,600$39,900$44,800$41,800$44,200$40,100$39,100$38,000

Question

The owner of Original Italian Pizza restaurant chain wants to understand which variable most strongly influences the sales of his specialty deep-dish pizza. He has gathered data on the monthly sales of deep-dish pizzas at his restaurants and observations on other potentially relevant variables for each of several outlets in central Indiana. These data are provided in the file P10_04.xlsx. Estimate a simple linear regression equation between the quantity sold (Y) and each of the following candidates for the best explanatory variable: average price of deep-dish pizzas (X1), monthly advertising expenditures (X2), and disposable income per household in the areas surrounding the outlets (X3). Round your answers for intercept coefficients to the nearest whole number and slope coefficients to two decimal places, if necessary. If your answer is negative number, enter &#34;minus&#34; sign. The owner of Original Italian Pizza restaurant chain wants to understand which variable most strongly influences the sales of his specialty deep-dish pizza. Hehas gathered data on the monthly sales of deep-dish pizzas at his restaurants and observations on other potentially relevant variables for each of several outletsin central Indiana. These data are provided in the file P10_04.xlsx. Estimate a simple linear regression equation between the quantity sold (Y) and each of thefollowing candidates for the best explanatory variable: average price of deep-dish pizzas (X₁), monthly advertising expenditures (X2), and disposable incomeper household in the areas surrounding the outlets (X3). Round your answers for intercept coefficients to the nearest whole number and slope coefficients to twodecimal places, if necessary. If your answer is negative number, enter &#34;minus&#34; sign.Ŷ =ŷ =++X1+X2X3Ŷ =Which variable is most strongly associated with the number of pizzas sold? Explain your choice.The variable most strongly associated with the number of pizzas sold is the monthly advertising expenditurescorrelation coefficient with the quantity soldbecause it has the strongest 1234567891011234 15 16121314AOutlet Number12345600789DELE HE101112131415BQuantity Sold85,30040,50061,80050,80060,60079,40071,40070,70055,60070,90077,20063,20071,10055,50042,100CAverage Price$10.14$10.88$12.33$12.70$12.29$9.79$11.26$11.23$11.97$12.07$10.68$12.49$12.36$9.96$11.77DMonthly Advertising Expenditures$64,800$42,800$58,600$46,500$50,700$60,100$55,600$57,900$52,100$60,700$64,400$55,600$60,900$47,200$46,100EDisposable Income per Household$42,100$38,300$41,000$43,300$44,000$41,200$41,700$43,600$39,900$44,800$41,800$44,200$40,100$39,100$38,000

Accepted Answer

outlet number 
Quantity sold 
Average price 
advertising expence
disposable income

1
85300
10.14…

an Pizza restaurant chain wants to understan monthly sales of deep-dish pizzas at his resta lata are provided in the file P10_04.xlsx. Esti e best explanatory variable: average price of surrounding the outlets (X3). Round your an y. If your answer is negative number, enter X1