BUAL2650 AUBURN Independent Variables Calculations For Chicken Sandwiches

  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

 

"Is this question part of your assignment? We Can Help!"