Homework 4,

1a) Using the spreadsheet in the link at the bottom of this page please run simple regresson with pie sales as the dependent variable and price as the independent varible

1b) Using the information of the regression you ran in 1a what is the slope coefficient on price? What does that mean?

1c) Using the information of the regression you ran in 1a what are the confidence interval for the slope coefficient on price? What does that mean?

1d) Using the information of the regression you ran in 1a what is the coefficient of determination of the regression? What does that mean?

2a) Using the spreadsheet in the link at the bottom of this page please run multiple regresson with pie sales as the dependent variable and price and advertising as the independent varibles

2b) Using the information of the regression you ran in 1a what is the slope coefficient on price? Is it the same as in 1a, why or why not?

2c) Using the information of the regression you ran in 1a what are the confidence interval for the slope coefficient on advertising? What does that mean?

2d) Using the information of the regression you ran in 1a what is the coefficient of determination of the regression? What does that mean?

3) Compare the regression in 1a and 2a. Does advertising have an effect on the number of pies sold? Explain how you came to your conclusion.

Spreadsheet homwork 4 => http://jtorrez.uprrp.edu/6551/hw4.xlsx