BUAL2650 AUBURN Independent Variables Calculations For Chicken Sandwiches Calculate a multiple regression in Excel using the data from the file above. (2 p

BUAL2650 AUBURN Independent Variables Calculations For Chicken Sandwiches 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 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.
Ex 11 Chicken data.xlsx
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 pvalue. 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)
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.
Ex 11 Chicken data.xlsx
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 pvalue. 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)
Sandwich
Wendy’s Ultimate Chicken Grill
Baja Fresh Original Baja Taco with Charbroiled Chicken
Burger King Smoky BBQ Fire Grilled Chicken Baguette
Quiznos Sub Honey Bourbon Chicken on Wheat bread
McDonald’s Chicken McGrill
Blimpie Grilled Chicken Hot Sub
Subway Oven Roasted Chicken Breast
Blimpie Buffalo Chicken Hot Sub
Wendy’s Spicy Chicken Fillet
Taco Bell Ranchero Chicken Soft Taco (two tacos)
KFC Oven Roasted Chicken Tender Wrap
Subway Buffalo Chicken Sub
Burger King Chicken Whopper
Au Bon Pain Arizona Chicken
Boston Market Rotisserie Chicken Carver
Chipolte Soft Tacos with Chicken (three tacos)
Cosi Grilled Chicken with Tomato, Basil, and Mozzarella
Atlanta Bread Company Chargrilled Chicken Pesto Panini
Corner Bakery Café Chicken Pomodori Panini
Panera Bread Tuscan Chicken on Rosamary & Onion Focaccia
Calories
360
370
380
400
400
470
470
500
510
540
550
550
570
580
640
660
720
740
910
950
Fat
Sat Fat
7
8
4
5
16
20
20
24
19
30
23
30
25
19
29
29
30
30
40
56
2
1
2
1
3
4
6
8
4
8
4
8
5
7
7
12
11
16
18
10
Carbs
44
53
57
57
37
51
46
52
57
42
55
46
48
58
61
56
65
78
86
76
Sodium
1100
680
1580
1040
1020
910
970
2570
1480
1580
1630
1760
1410
1590
980
1630
1260
1660
1970
2130

Purchase answer to see full
attachment