“Using Excel’s Regression Tool for the Armand’s Pizza Parlors Example” to develop regression equation and ANOVA table as in Figure 14.13 and answer the following questions:
Open the dataset of Armand’s (attached).
Follow the instructions under the title of “Using Excel’s Regression Tool for the Armand’s Pizza Parlors Example” to develop regression equation and ANOVA table as in Figure 14.13 (attached).
Upload the Figure 14.13.
What is the estimated regression equation?
Conduct the hypothesis test to test for significance of regression. Can we conclude that there is a significant relationship between student population and sales? Provide the rationale for your answer.
