Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

here is the excel file Use Excel to perform linear regression to describe cereal

ID: 2951208 • Letter: H

Question

here is the excel file


Use Excel to perform linear regression to describe cereal calorieswith a single variable, sugars.


a. Report the simple regressionmodel.


b. Interpret the modelparameters.


c. Report the R-square value, and drawconclusions.

Use Excel again to perform multiple regression with all possiblevariables.


a. Which variables would appear to besignificant with 10% confidence?


b. Eliminate those variables that arenot significant, and rerun the regression with only

those significant variables. Report the revised multipleregression model.


c. Interpret the modelparameters.


d. Report the R-square value and theadjusted R-square. Compare to the single variable

model.


here is the data


http://www.2shared.com/file/6529639/49411091/homework_8_-_breakfast_cereal.html

Explanation / Answer

where is the data??