The columns in the excel file are:restaurant, meattype, calories, cal_fat (number of calories from fat), total_fat, trans_fat (trans fat), cholesterol, sodium, total_carb (total carbs), protein, Chicken_Beef (meals labeled as chicken = 0 or beef = 1), sat_fatCAT (0 = below the mean saturated fat value, 1 = above the mean saturated fat value), meattype_beef (includes only the beef meals from each restaurant, see code below), Chick Fil-A Sandwich, total_carb_Chick Fil-A (total carbs, in grams at Chick Fil-A for each sandwich), protein_Chick Fil-A (protein, in grams at Chick Fil-A for each sandwich).

for meattype:

• 0 = McDonalds chicken meals
• 1 = McDonalds beef meals
• 2 = Chick Fil-A chicken meals
• 3 = Sonic beef meals
• 4 = Sonic chicken meals
• 5 = Arbys beef meals
• 6 = Arbys chicken meals
• 7 = Burger King beef meals
• 8 = Burger King chicken meals

Will you conclude that there is less grams of total carbs than there is grams of protein, on average, for a menu item served at Chick Fil-A? Use a 5% level of significance.

Fornumerical answers, you use the SPSS output.You must input your answerexactlyas the measurement appears (to the same number of decimal places) on the SPSS output.Otherwise the automated grader will mark it incorrect.

Fortext answers, you choose from the list below.It is best totriple clickon the first word to highlight the word(s) exactly, then right click and copy (or control C) and paste (or control V) into the blank.The answer must matchexactly to one of the choices, otherwise, the automated grader will mark it incorrect.

Remember, do not add any additional spaces or characters.

Note:Use a choice only once.Do not repeat the use of an answer choice.Not all of the choices will be used.

for text answers choose from:

Paired sample t test

Independent sample t test

One way ANOVA

Regression

Chi Square

Chick Fil Sandwich and total_carb_Chick Fil-A

total_fat and total_carb

total_carb_Chick Fil-A and protein_Chick Fil-A

Chick Fil Sandwich and protein_Chick Fil-A

total_fat and protein

sat_fatCAT and trans_fat

the means are equal

the means are not equal

x

y

two

one

the mean total carbs is less than the mean protein at Chick Fil-A

the mean total carbs is more than the mean protein at Chick Fil-A

the mean total carbs is less than the mean protein at all of the restaurants

the mean total carbs is more than the mean protein at all of the restaurants

same as

greater

less

less than 0.05

more than 0.05

less than 0.01

more than 0.01

unequal

equal

insufficient

sufficient

reject

fail to reject

support the Ho

support the Ha

amount of total carbs at Chick Fil-A

amount of protein at Chick Fil-A

amount of total carbs at all of the restaurants

amount of protein at all of the restaurants

likely

unlikely

Based on the research question, the method to use on SPSS is Blank 1.

The data that I would use to conduct the test is the Blank 2 from the data set.

The null hypothesis, Ho, is Blank 3.

The alternate hypothesis, Ha, is Blank 4 and is a Blank 5 sided test.

The value of the t statistic is Blank 6.

The P-value is Blank 7which is Blank 8.

In conclusion, at the Blank 9 % level of significance, we Blank 10 the null hypothesis and say there is Blank 11 evidence to Blank 12.

Mcdonalds 0 380 60 7 .0 95 1110 44 37 0 0 Chargrilled Chicken Club Sandwich 37 37 Mcdonalds 1 840 410 45 1.5 130 1580 62 46 1 1 1 Chargrilled Chicken Sandwich 36 29 Mcdonalds 1 1130 600 67 3.0 220 1920 63 70 1 1 1 Chick-n-Slider 26 16 Mcdonalds 0 750 280 31 .5 155 1940 62 55 0 1 1 Piece Chick-n-Strips 6 11 Mcdonalds 0 920 410 45 .5 120 1980 81 46 0 1 2 Piece Chick-n-Strips 13 22 Mcdonalds 1 540 250 28 1.0 80 950 46 25 1 1 1 3 Piece Chick-n-Strips 22 28 Mcdonalds 1 300 100 12 .5 40 680 33 15 1 0 1 4 piece Chick-n-Strips 29 37 Mcdonalds 0 510 210 24 .0 65 1040 49 25 0 0 Chicken Deluxe 42 31 Mcdonalds 1 430 190 21 1.0 85 1040 35 25 1 1 1 4 piece Chicken Nuggets 5 14 Mcdonalds 1 770 400 45 2.5 175 1290 42 51 1 1 1 6 piece Chicken Nuggets 7 21 Mcdonalds 1 620 300 34 1.5 95 790 48 32 1 1 1 8 piece Chicken Nuggets 9 28 Mcdonalds 0 530 180 20 .0 125 1150 48 42 0 0 12 piece Chicken Nuggets 14 41 Mcdonalds 0 700 300 34 .0 85 1190 67 33 0 1 30 piece Chicken Nuggets 35 103 Mcdonalds 1 250 70 8 .0 30 480 31 13 1 0 1 Chicken Salad Sandwich 55 28 Mcdonalds 1 640 330 36 1.5 110 1260 40 37 1 1 1 Chicken Sandwich 40 28 Mcdonalds 0 580 190 21 .0 135 1890 50 48 0 0 4 Piece Grilled Chicken Nuggets 1 13 Mcdonalds 0 740 310 35 .5 95 1780 69 39 0 1 6 Piece Grilled Chicken Nuggets 2 19 Mcdonalds 0 350 130 15 .0 40 600 40 15 0 0 8 piece Grilled Chicken Nuggets 2 25 Mcdonalds 1 380 160 18 1.0 70 840 34 23 1 0 1 12 Piece Grilled Chicken Nuggets 3 38 Mcdonalds 1 480 200 22 .0 80 870 45 25 1 0 1 Spicy Grilled Chicken Sub Sandwich 47 33 Mcdonalds 1 580 300 33 1.5 95 920 41 29 1 1 1 Regular Grilled Chicken Sub Sandwich 48 34 Mcdonalds 0 520 160 18 .0 115 1540 50 40 0 0 Spicy Chicken Sandwich 41 29 Mcdonalds 0 680 280 32 .0 80 1430 69 31 0 0 Spicy Deluxe 43 34 Mcdonalds 0 570 200 23 .0 60 1050 64 28 0 0 Chargrilled Chicken Cool Wrap 29 37 Mcdonalds 0 530 200 22 .0 45 1000 59 25 0 0 Chicken Enchiladas Meal Kit 70 39 Mcdonalds 1 530 240 27 1.5 100 1090 41 31 1 1 1 Chicken Parmesan Meal Kit 65 48 Mcdonalds 1 670 320 35 1.5 95 1010 56 32 1 1 1 Mcdonalds 0 560 180 20 .0 115 1550 56 41 0 0 Mcdonalds 0 730 300 33 .0 80 1430 75 32 0 0 Mcdonalds 1 690 340 37 1.5 110 1310 51 38 1 1 1 Mcdonalds 0 630 200 22 .0 135 1930 61 48 0 0 Mcdonalds 0 800 320 36 .5 95 1820 80 39 0 1 Mcdonalds 0 370 190 21 .0 70 910 16 28 0 0 Mcdonalds 0 480 250 28 .0 95 1290 21 38 0 0 Mcdonalds 0 760 390 44 .5 145 1890 32 58 0 0 Mcdonalds 0 1210 630 70 1.0 240 3230 52 94 0 1 Mcdonalds 0 1510 790 88 1.0 295 3770 64 115 0 1 Mcdonalds 0 2430 1270 141 2.0 475 6080 103 186 0 1 Mcdonalds 0 180 100 11 .0 30 340 11 10 0 0 Mcdonalds 0 270 140 16 .0 45 510 16 15 0 0 Mcdonalds 0 440 240 27 .0 75 840 26 24 0 0 Mcdonalds 0 890 480 53 .0 145 1680 53 49 0 1 Mcdonalds 0 1770 960 107 .5 295 3370 105 98 0 1 Mcdonalds 0 640 240 27 .0 105 1780 63 39 0 0 Mcdonalds 0 960 360 40 .0 160 2670 94 58 0 0 Mcdonalds 0 1600 600 66 .0 265 4450 156 97 0 1 Mcdonalds 0 140 70 7 .0 0 20 13 7 0 0 Mcdonalds 0 270 80 9 .0 80 740 18 31 0 0 Mcdonalds 0 490 250 28 .0 95 1120 28 33 0 0 Mcdonalds 0 190 110 12 .0 40 660 9 14 0 0 Mcdonalds 0 320 120 14 .0 45 1230 9 42 0 0 Mcdonalds 0 490 250 28 .0 95 1120 28 33 0 0 Mcdonalds 0 220 90 10 .0 15 500 26 8 0 0 Mcdonalds 0 350 100 12 .0 110 1070 27 37 0 0 Mcdonalds 0 520 230 25 .0 75 960 46 28 0 0 Chick Fil-A 2 430 144 16 .0 85 1120 37 37 0 0 Chick Fil-A 2 310 54 6 .0 55 820 36 29 0 0 Chick Fil-A 2 270 99 11 .0 45 800 26 16 0 0 Chick Fil-A 2 120 54 6 .0 25 320 6 11 0 0 Chick Fil-A 2 230 108 12 .0 55 630 13 22 0 0 Chick Fil-A 2 350 153 17 .0 70 940 22 28 0 0 Chick Fil-A 2 470 207 23 .0 90 1250 29 37 0 0 Chick Fil-A 2 500 207 23 .0 75 1590 42 31 0 0 Chick Fil-A 2 130 54 6 .0 40 490 5 14 0 0 Chick Fil-A 2 190 81 9 .0 55 730 7 21 0 0 Chick Fil-A 2 260 110 12 .0 70 990 9 28 0 0 Chick Fil-A 2 390 162 18 .0 115 1460 14 41 0 0 Chick Fil-A 2 970 414 46 .0 285 3660 35 103 0 0 Chick Fil-A 2 490 170 19 .0 80 1130 55 28 0 0 Chick Fil-A 2 440 171 19 .0 60 1350 40 28 0 0 Chick Fil-A 2 70 18 2 .0 35 220 1 13 0 0 Chick Fil-A 2 110 27 3 .0 50 330 2 19 0 0 Chick Fil-A 2 140 36 4 .0 70 440 2 25 0 0 Chick Fil-A 2 210 45 5 .0 100 670 3 38 0 0 Chick Fil-A 2 430 108 12 .0 85 1310 47 33 0 0 Chick Fil-A 2 450 117 13 .0 75 1000 48 34 0 0 Chick Fil-A 2 450 171 19 .0 60 1620 41 29 0 0 Chick Fil-A 2 540 225 25 .0 80 1760 43 34 0 0 Chick Fil-A 2 350 126 14 .0 60 960 29 37 0 0 Chick Fil-A 2 860 423 47 1.0 100 2520 70 39 0 1 Chick Fil-A 2 720 279 31 .0 120 1780 65 48 0 1 Sonic 3 710 380 43 2.0 120 1120 44 35 1 1 3 Sonic 3 640 330 37 2.0 100 930 42 31 1 1 3 Sonic 3 340 150 17 1.0 35 640 34 15 1 0 3 Sonic 3 410 220 24 .5 55 730 32 20 1 1 3 Sonic 3 380 200 23 1.0 40 470 32 15 1 0 3 Sonic 3 450 250 28 1.0 60 800 33 19 1 1 3 Sonic 3 600 350 38 2.0 110 1350 35 31 1 1 3 Sonic 3 870 530 59 2.0 140 1350 45 39 1 1 3 Sonic 3 640 330 37 2.0 100 790 43 31 1 1 3 Sonic 3 650 340 37 2.0 100 860 46 32 1 1 3 Sonic 3 740 430 48 2.0 110 760 44 31 1 1 3 Sonic 3 710 380 43 2.0 120 1120 43 35 1 1 3 Sonic 3 720 380 43 2.0 120 1190 47 35 1 1 3 Sonic 3 800 480 54 2.0 130 1090 44 35 1 1 3 Sonic 3 1280 830 92 4.0 260 1630 44 67 1 1 3 Sonic 3 1120 680 76 4.0 235 1550 44 63 1 1 3 Sonic 3 1130 680 76 4.0 235 1620 47 63 1 1 3 Sonic 3 1220 780 87 4.0 245 1520 45 63 1 1 3 Sonic 3 1120 680 76 4.0 235 1690 43 63 1 1 3 Sonic 4 610 270 30 .0 110 1570 44 40 0 0 Sonic 4 680 350 39 .0 80 1120 53 31 0 1 Sonic 4 430 180 20 .0 80 940 33 28 0 0 Sonic 4 570 300 33 .0 45 1060 47 23 0 0 Sonic 4 450 220 24 .0 35 740 43 19 0 0 Sonic 4 280 130 14 .0 0 800 16 22 0 0 Sonic 4 470 220 24 .0 0 1340 26 37 0 0 Sonic 4 740 350 39 .0 90 1550 63 33 0 0 Sonic 4 1000 550 61 .5 125 4520 70 23 0 1 Sonic 4 1350 900 100 .0 190 2180 69 23 0 1 Sonic 4 380 190 22 .0 45 1250 27 18 0 0 Sonic 4 560 290 32 1.0 65 1890 41 27 0 0 Sonic 4 350 150 17 .0 45 860 30 21 0 0 Sonic 4 610 270 30 .0 80 1500 51 36 0 0 Sonic 4 970 410 46 1.0 55 2160 109 30 0 0 Sonic 4 1080 460 51 1.0 75 2390 118 37 0 1 Sonic 4 1190 510 57 1.0 90 2610 126 44 0 1 Sonic 4 330 140 16 .0 55 670 25 22 0 0 Sonic 4 440 190 21 .0 70 900 34 29 0 0 Sonic 4 550 240 26 .0 90 1120 42 36 0 0 Sonic 4 730 350 39 .0 90 1540 62 32 0 0 Sonic 4 100 580 64 .5 100 2070 65 39 0 1 Arbys 5 330 100 11 .0 30 920 40 18 1 0 5 Arbys 5 400 90 10 .0 30 1230 58 18 1 0 5 Arbys 5 450 180 20 1.0 50 1280 45 23 1 0 5 Arbys 5 630 290 32 1.5 100 2100 48 39 1 1 5 Arbys 5 650 300 33 1.0 105 1460 51 38 1 1 5 Arbys 6 690 280 31 .0 90 1990 66 38 0 1 Arbys 5 690 280 31 .0 90 1990 66 38 1 1 5 Arbys 6 540 220 24 .0 60 2110 53 29 0 0 Arbys 6 650 280 31 .0 90 1750 56 39 0 1 Arbys 6 690 310 35 .0 110 2000 53 41 0 1 Arbys 6 550 230 26 .0 60 1480 52 29 0 0 Arbys 5 360 120 14 .5 50 970 37 23 1 0 5 Arbys 5 510 210 24 1.5 95 1610 38 38 1 1 5 Arbys 5 640 290 32 .5 105 1950 46 42 1 1 5 Arbys 5 740 350 39 2.0 130 2530 48 49 1 1 5 Arbys 5 610 270 30 2.0 130 2040 38 48 1 1 5 Arbys 6 710 410 46 .5 65 980 53 22 0 0 Arbys 6 840 400 44 .5 75 1210 81 33 0 0 Arbys 6 240 100 11 .0 30 640 19 16 0 0 Arbys 6 360 150 17 .0 45 950 28 23 0 0 Arbys 6 600 250 28 .0 75 1590 47 39 0 0 Arbys 5 550 260 29 1.0 60 1290 48 24 1 0 5 Arbys 5 740 320 35 1.0 125 2050 62 43 1 1 5 Arbys 5 590 250 59 1.0 75 1510 59 26 1 1 5 Arbys 5 600 310 35 1.0 110 1240 42 33 1 1 5 Arbys 5 430 160 17 1.0 45 1060 45 23 1 0 5 Arbys 5 650 320 36 1.0 115 1760 44 30 1 1 5 Arbys 6 290 120 13 .0 20 860 31 12 0 0 Arbys 6 290 110 12 .0 25 720 30 15 0 0 Arbys 5 220 80 9 .0 30 890 21 14 1 0 5 Arbys 5 240 90 11 .0 30 670 21 14 1 0 5 Arbys 5 240 90 11 .0 30 670 21 14 1 0 5 Arbys 6 430 220 24 .0 65 1000 26 28 0 0 Burger King 7 330 140 16 .0 55 830 32 18 1 0 7 Burger King 7 290 120 14 .5 40 720 28 12 1 0 7 Burger King 7 300 130 14 .0 45 710 28 16 1 0 7 Burger King 7 520 280 31 1.0 105 1180 33 31 1 1 7 Burger King 7 450 230 26 1.0 95 960 29 26 1 1 7 Burger King 7 360 160 18 .0 70 520 28 22 1 0 7 Burger King 7 900 486 54 3.0 210 1740 50 56 1 1 7 Burger King 7 580 300 33 1.5 85 1030 45 26 1 1 7 Burger King 7 260 90 10 .0 35 490 28 13 1 0 7 Burger King 7 550 250 27 1.5 95 1140 48 30 1 1 7 Burger King 7 310 110 13 .5 25 450 38 9 1 0 7 Burger King 7 1100 666 74 1.0 180 1620 59 50 1 1 7 Burger King 7 770 432 48 2.0 95 1360 47 29 1 1 7 Burger King 7 900 510 57 2.0 140 1050 51 47 1 1 7 Burger King 7 990 580 65 2.0 160 1480 53 52 1 1 7 Burger King 7 660 360 40 1.5 90 980 49 28 1 1 7 Burger King 7 760 430 47 1.0 100 1410 53 33 1 1 7 Burger King 7 340 170 19 .0 40 510 28 14 1 0 7 Burger King 7 380 210 23 1.0 55 730 29 16 1 0 7 Burger King 8 590 360 40 .0 150 1540 18 42 0 1 Burger King 8 720 450 50 .0 120 1960 32 36 0 1 Burger King 8 550 330 37 .0 115 1640 17 36 0 1 Burger King 8 690 430 48 1.0 100 1750 31 35 0 1 Burger King 8 530 290 32 .0 95 1640 26 35 0 0 Burger King 8 670 380 43 .0 80 1760 40 34 0 0 Burger King 8 560 270 30 .0 90 980 40 29 0 0 Burger King 8 700 370 41 .0 80 1090 54 28 0 1 Burger King 8 320 120 14 .0 115 650 16 36 0 0 Burger King 8 450 220 24 .0 85 1070 30 29 0 0 Burger King 8 830 468 52 .5 110 2100 57 34 0 1 Burger King 8 440 243 27 .0 15 630 44 7 0 0 Burger King 8 480 220 25 .0 5 1160 42 22 0 0 Burger King 8 730 351 39 .0 90 1930 63 32 0 1 Burger King 8 470 260 29 .0 50 890 34 21 0 0 Burger King 8 570 225 25 .0 70 1340 57 32 0 0 Burger King 8 580 252 28 .5 70 2310 56 30 0 0 Burger King 8 430 250 28 .0 30 760 34 12 0 0 Burger King 8 670 370 41 .5 60 1070 54 23 0 0 Burger King 8 470 170 19 .0 85 850 39 37 0 0 Burger King 8 630 350 39 1.0 65 1390 46 24 0 0 Burger King 8 410 150 17 .0 20 870 53 12 0 0 Burger King 8 840 459 51 1.0 95 1760 62 32 0 1 Burger King 8 530 333 37 .0 55 1420 28 20 0 0 Burger King 8 410 220 25 .0 35 850 35 12 0 0 Burger King 8 700 378 42 .0 65 1140 57 25 0 0 Burger King 8 760 405 45 .0 95 1720 58 32 0 1