Unit 8 Lab: Excel’s Regression Tool and Exercises / Unit 8 AS: Case Problem: Finding the Best Car Value

Unit 8 Lab: Excel’s Regression Tool and Exercises

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 and answer the following questions:

1. Open the dataset of Armand’s (attached).
2. 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).
3. Upload the Figure 14.13.
4. What is the estimated regression equation?
5. 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.

Unit 8 AS: Case Problem: Finding the Best Car Value

The purpose of this assignment is to apply simple regression techniques to find factors that determine the car values.

1. Open the dataset of FamilySedans (attached) and read the case entitled “Finding the Best Car Value” in its entirety at the end of Chapter 14.
2. Use descriptive statistics to summarize the data and make comments on them.
3. Use regression analysis to develop an estimated regression equation that could be used to predict the value score given the price of the car.
4. Use regression analysis to develop an estimated regression equation that could be used to predict the value score given the five-year owner costs.
5. Use regression analysis to develop an estimated regression equation that could be used to predict the value score given the road-test score.
6. Use regression analysis to develop an estimated regression equation that could be used to predict the value score given the predicted-reliability.
7. What conclusions can you derive from your analysis?

I have attached below the book and the 2 excel sheets (1)for each assignment