open the data file below in this data set you are using the independent variables fat saturated fat carbs and sodium to predict the calories for 21 different fast food chicken sandwiches

/in /by

  1. Calculate a multiple regression in Excel using the data from the file above. (2 points)

Make sure to include in your output:

  • Residual plots for each of the independent variables
  • Normal probability plot

2. Decide if each of the residual plots meets the equal spread condition. (2 points)

3. Decide if the normal probability plot meets the nearly normal condition. (1 point)

4. Make a decision about the overall model using the F-statistic and its associated p-value. Assume alpha = 0.05. (1 point)

5. Make a decision for the slope of each of the independent variables using the t-test statistic and its associated p-value. Assume alpha = 0.05. (4 points