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 type of meat (chicken or beef) in the meal has an effect on the amount of saturated fat in the meal?Use a 5% level of significance.

for text answers choose from:

Paired sample t test

Independent sample t test

One way ANOVA

Regression

Chi Square

trans_fat and Chicken_Beef

total_fat and meattype

Chicken_Beef and sodium

sat_fatCAT and Chicken_Beef

meattype_Beef and sat_fatCAT

meattype and Chicken_Beef

all of the means are the same

some of the means are different

type of meat and amount of saturated fat are not independent

type of meat and amount of saturated fat are independent

the mean type of meat is less than the mean saturated fat level

the mean type of meat is more than the mean saturated fat level

independent

dependent

unequal

equal

same as

greater than

less than

insufficient

sufficient

reject

fail to reject

is associated with

is not associated with

support the Ho

support the Ha

higher proportion

lower proportion

post hoc

it is inconclusive

there are more chicken dishes

there are more beef dishes

that are higher in saturated fat content than chicken dishes

that are higher in saturated fat content than beef dishes

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 number of chicken meals (0) below the mean saturated fat level (0) is Blank 3.

The number of chicken meals (0) above the mean saturated fat level (1) is Blank 4.

The number of beef meals (1) below the mean saturated fat level (0) is Blank 5.

The number of beef meals (1) above the mean saturated fat level (1) is Blank 6.

The null hypothesis, Ho, is Blank 7.

The alternate hypothesis, Ha, is Blank 8.

As the P-value of Blank 9 is Blank 10 alpha of Blank 11 %, we Blank 12 the null hypothesis.

We have Blank 13 evidence to support that the type of meat (chicken or beef) and the mean amount of saturated fat are Blank 14.

From the SPSS output, there are Blank 15 % of the chicken meals with saturated fat levels above the mean and Blank 16 % of the beef meals with saturated fat levels above the mean.

Thus, a significantly Blank 17 of chicken dishes than beef dishes have higher saturated fat levels.We can conclude that type of meat Blank 18 the amount of saturated fat.

restaurant	meattype	calories	cal_fat	total_fat	trans_fat	cholesterol	sodium	total_carb	protein	Chicken_Beef	sat_fatCAT	meattype_beef	Chick Fil-A_Sandwich	total_carb_Chick Fil-A	protein_Chick Fil-A
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	220	1920	63	70	1	1	1	Chick-n-Slider	26	16
Mcdonalds	0	750	280	31	0.5	155	1940	62	55	0	1		1 Piece Chick-n-Strips	6	11
Mcdonalds	0	920	410	45	0.5	120	1980	81	46	0	1		2 Piece Chick-n-Strips	13	22
Mcdonalds	1	540	250	28	1	80	950	46	25	1	1	1	3 Piece Chick-n-Strips	22	28
Mcdonalds	1	300	100	12	0.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	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	0.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	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	0.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	0.5	145	1890	32	58	0	0
Mcdonalds	0	1210	630	70	1	240	3230	52	94	0	1
Mcdonalds	0	1510	790	88	1	295	3770	64	115	0	1
Mcdonalds	0	2430	1270	141	2	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	0.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	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	120	1120	44	35	1	1	3
Sonic	3	640	330	37	2	100	930	42	31	1	1	3
Sonic	3	340	150	17	1	35	640	34	15	1	0	3
Sonic	3	410	220	24	0.5	55	730	32	20	1	1	3
Sonic	3	380	200	23	1	40	470	32	15	1	0	3
Sonic	3	450	250	28	1	60	800	33	19	1	1	3
Sonic	3	600	350	38	2	110	1350	35	31	1	1	3
Sonic	3	870	530	59	2	140	1350	45	39	1	1	3
Sonic	3	640	330	37	2	100	790	43	31	1	1	3
Sonic	3	650	340	37	2	100	860	46	32	1	1	3
Sonic	3	740	430	48	2	110	760	44	31	1	1	3
Sonic	3	710	380	43	2	120	1120	43	35	1	1	3
Sonic	3	720	380	43	2	120	1190	47	35	1	1	3
Sonic	3	800	480	54	2	130	1090	44	35	1	1	3
Sonic	3	1280	830	92	4	260	1630	44	67	1	1	3
Sonic	3	1120	680	76	4	235	1550	44	63	1	1	3
Sonic	3	1130	680	76	4	235	1620	47	63	1	1	3
Sonic	3	1220	780	87	4	245	1520	45	63	1	1	3
Sonic	3	1120	680	76	4	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	0.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	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	55	2160	109	30	0	0
Sonic	4	1080	460	51	1	75	2390	118	37	0	1
Sonic	4	1190	510	57	1	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	0.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	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	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	0.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	0.5	105	1950	46	42	1	1	5
Arbys	5	740	350	39	2	130	2530	48	49	1	1	5
Arbys	5	610	270	30	2	130	2040	38	48	1	1	5
Arbys	6	710	410	46	0.5	65	980	53	22	0	0
Arbys	6	840	400	44	0.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	60	1290	48	24	1	0	5
Arbys	5	740	320	35	1	125	2050	62	43	1	1	5
Arbys	5	590	250	59	1	75	1510	59	26	1	1	5
Arbys	5	600	310	35	1	110	1240	42	33	1	1	5
Arbys	5	430	160	17	1	45	1060	45	23	1	0	5
Arbys	5	650	320	36	1	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	0.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	105	1180	33	31	1	1	7
Burger King	7	450	230	26	1	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	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	0.5	25	450	38	9	1	0	7
Burger King	7	1100	666	74	1	180	1620	59	50	1	1	7
Burger King	7	770	432	48	2	95	1360	47	29	1	1	7
Burger King	7	900	510	57	2	140	1050	51	47	1	1	7
Burger King	7	990	580	65	2	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	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	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	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	0.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	0.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	0.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	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	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