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
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.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps