Is BMI associated with eating out in restaurants frequently (more than five times per week on average) after adjusting for GENDER and AGE?

Use SPSS

1) Perform various exploratory analyses (graphical/numerical) to assess: the distribution of BMI by GENDER, AGE, and RESTAURANT.

2) Fit a multiple linear with BMI as your dependent variable and GENDER, AGE, and RESTAURANT as the independent variables.

3) Perform residual analysis and see if the residuals are more normal when the BMI is transformed using natural logarithm. In other words, perform the multiple linear regression in part (2) using ln (BMI) and see if the residuals behave better in terms of normality (e.g., obtain the Q-Q plot and the boxplot of residuals). Interpret all results including the R-square.

4) Make a prediction (of ln BMI) for one participant of your choice with a specified GENDER, AGE, and RESTAURANT.

Patient_ID	Gender	Age	Race	BMI	Cholesterol	Resturante
100243	0	25		19.47	158	0
100270	1	76	4	38.46	180	0
100597	0	29	1	34.07	234	1
102981	1	40	4	28.29	147	0
103523	1	33	4	23.37	142	0
107153	1	34	4	23.24	183	0
108449	0	46	4	32.23	211	0
108968	0	48	1	23.69	115	0
109245	1	29	3	18.19	172	1
109274	0	21	1	17.81	114	0
112539	1	34	4	35.56	214	0
112835	1	33	4	20.91	161	0
114251	0	28	4	28.68	191	0
116697	0	52	1	28.3	195	1
116756	0	38	2	22.81	172	0
118772	0	21	1	26.58	240	0
120325	0	26	1	26.95		1
121326	0	34	2	28.94	185	0
121554	1	51	2	26.17	291	0
121915	0	48	1	23.5		0
122264	1	41	2	27.53	183	0
122744	0	24	1	21.85	159	0
122843	0	45	1	26.99	218	1
123331	1	28	1	21.66	169	1
123662	0	25	4	26.66	256	0
123695	0	50	4	19.28	199	0
124882	1	21	1	22.06	191	0
124931	1	35	3	20.4	207	1
125280	0	63	3	25.68	220	0
125334	1	30	3	23.39	293	0
125586	1	29	1	28.06		1
126172	0	68	3	29.64	208	0
126689	0	29	3	18.42	175	1
131094	0	32	2	24.82	158	0
135069	1	48	1	25.19	221	0
138390	1	24	4	21.17	171	0
139360	1	80	1	30.58	230	0
139621	0	29	1	36.55	297	0
143120	1	30	4	35.03	172	0
143382	1	62	1	31.59	194	1
143422	1	41	4	27.22	221	0
144812	0	26	2	25.31	170	0
147353	1	58	2	59.43	177	0
151102	1	37	1	19.2	177	1
151664	0	54	3	36.27	143	0
152400	1	56	3	27.04	154	0
157727	0	22	1	26.21	143	0
159278	1	36	3	20.9	241	0
163367	0	38	4	25.79	260	1
166093	1	25	4	21.2	158	0
166455	1	27	4	20.76	233	0
167579	0	29	4	37.95	173	0
167862	1	44	4	30.23	152	0
168841	1	31	3	24.57	229	1
171039	1	40	4	27.53	239	0
172272	1	47	1	26.79	197	0
173316	1	53	4	25.79	178	0
173346	1	69	1	41.88		0
173773	1	35	3	24.91	250	0
181987	1	26	4	17.48	158	1
185204	1	36	2	22.37	174	0
188622	0	30	4	27.01	192	0
192312	1	53	2	37.37	201	0
194736	0	29	1	21.25	201	0
199547	1	62	4	31.21	132	0
199678	1	27	1	19.04	189	0
201857	1	35	4	24.73	210	0
202501	1	50	4	28.29	225	0
202933	0	37	2	26.48		1
205400	0	65	1	34.03		0
205410	1	35	2	29.97	159	0
207772	1	22	1	28.39	203	0
208756	1	62	4	29.52	227	0
212183	1	63	1	23.24		0
213329	0	51	2	30.08	204	1
215118	0	51	2	20.63	270	0
217059	0	48	1	26.57	275	1
220077	1	26	4	22.65	152	0
220970	0	48	2	25.08	244	0
222085	1	74	3	27.69	162	0
223338	0	49	4	32.48	186	1
224683	0	58	2	18.41	258	0
230361	0	48	4	36	202	0
230892	1	26	4	34.81	234	0
231374	1	86	1	22.58		0
231767	1	50	3	28.83	235	0
233415	0	74	1	31.77	198	0
235626	1	55	1	23.73	228	0
236173	1	30	2	29.03	163	0
237157	0	22	4	20.67	190	1
237429	1	51	1	20.27	186	1
247802	0	43	1	26.43	187	0
248820	0	56	2	23.31	225	0
249540	1	24	1	21.92	157	1
249987	0	68	3	22.82	133	0
253568	1	22	4	28.4	171	0
254353	0	56	4	21.58	172	0
257398	1	44	1	31.37	257	0
258212	1	33	2	35.32	176	0
260515	0	22	3	25.45	157	1
261561	1	44		22.44	256	0
263232	0	34	4	28.21	304	0
264674	1	49	4	36.36	177	0
265679	1	85	1	39.76	182	0
266404	1	36	4	29.57	210	0
268812	1	26	3	23.37	293	0
274983	0	45	4	24.1		1
279513	1	29	1	22.6	139	0
279731	1	33	4	28.18	188	0
284790	0	33	1	18.82	191	0
285127	1	63	3	22.63	211	0
287351	1	26	4	34.35		0
289028	1	24	2	33.29	163	0
290963	1	38	3	22.56	205	0
291575	1	21	3	34.9	158	0
293882	0	23		22.77	138	0
294575	1	55	2	33.46	172	0
295157	0	80	2	43.6	185	0
295580	0	36	4	30.36	154	1
296041	1	44	2	29.14	223	0
296541	1	62	1	28.59		0
296662	0	46	2	15.73	144	0
298574	0	37	1	28.72	220	1
300298	1	23	3	35.61	142	0
304310	1	29	1	19.96		0
304314	1	40	3	24.87	168	0
304760	1	26	4	27.22	197	0
308403	1	43	4	35.52	208	0
309473	0	42	4	29.66	163	1
310485	0	36	2	30.81	182	1
310539	0	66	4	20.15	175	0
311274	1	73	2	25.58	186	0
313027	0	59	1	24.71	246	0
313286	1	61	2	27.6	129	0
318563	1	28	2	24.48	160
322484	0	33	2	20.48	221	0
322843	0	36	2	26.12	270	0
329308	1	27	4	25.84	176	0
329656	1	70	2	27.91	181	0
332817	1	27	4	37.38		0
333059	0	50	4	30.8	223	1
336422	1	31	4	21.45	152	0
339120	0	56	1	22.74	206	0
340059	0	26	3	24.92	201	1
342285	0	54	1	28.09		0
343744	1	40	2	16.43		0
345670	1	40	4	26.43	171	0
346770	0	20	4	33.31	184	1
348420	0	36	2	41.05	205	0
348490	1	34	2	37.58		0
348820	0	62	1	26.42	238	0
348923	0	25	1	25.11	168	1
349455	0	24	1	32.62		0
350397	1	67	2	54.72	179	0
352326	0	28	2	20.71	175	0
353319	0	32	2	23.82	182	0
353470	1	39	4	28.38	232	0
355620	0	43	2	29.7	232	1
356574	0	57	3	31.97	180	0
358051	0	29	3	20.75	198	0
360948	1	36	4	24.62	248	0
363403	0	29	4	26.75	193	1
365909	1	39	3	21.79	176	0
366565	1	24	1	24.93	183	0
366830	0	79	1	33.04	261	0
369705	1	28	4	24.07	153	0
371603	1	27	1	18.18	238	1
371664	0	46	1	28.12	187	0
371677	0	46	1	26.51	171	1
372175	1	24	1	19.75	229	0
377791	0	29	1	27.15	179	1
378697	1	46	4	25.35	188	0
380888	1	21	1	24.19		0
381799	0	58	4	30.81	178	0
388393	1	48	1	31.13	244	0
389390	1	44	2	43.05	260	0
389608	1	21	1	21.97	132	1
393680	1	23	4	22.48	173	1
396153	0	59	2	24.49	226	0
406526	1	48	4	27.47	235	0
409178	0	47	1	20.45	161	1
412698	1	29	4	27.41	119	0
414747	0	26	4	27.55	181	1
416994	0	23	4	23.53	154	0
418976	0	25	4	20.28	151	1
423054	0	78	1	26.63		0
426913	0	62	1	22.91	206	0
428405	1	40	2	32.47	193	1
429782	1	69	2	26.68		0
432586	1	27	4	21.3	178	0
432888	1	33	4	41.02	241	0
433040	1	26	4	32.32	212	0
433562	1	51	1	31.09		0
434746	1	46	3	22.91	182	0
436721	1	25	2	27.06	156	1
438284	1	61	1	33.31	225	0
439624	0	39	3	22.44	203
440185	0	42	4	24.39	194	1
440814	1	55	4	27.99	200
441575	1	42	1	33.83	243	1
443110	0	22	4	23.7	166	1
448368	1	22	4	35.92	242	0
454566	0	49	4	41.98	209	1
465921	0	51	1	32.04	295	1
466360	0	73	1	31.79	151	0
469572	1	74	4	24.49	161	0
471540	1	51	4	31.24	240	0
473018	1	70		39.31	257	0
480298	0	73	2	21.04	171	0
481860	0	23	4	34.8	206	0
482865	1	39	4	23.95	171	0
485308	1	25	2	32.66	153	0
486433	0	39	2	28.43	185	0
486978	1	40	2	30.08	179	0
487046	1	42	4	40.7	148	0
487748	0	33	1	26.27	212	0
488314	0	71	1	25.69	198	0
488996	1	30	4	23.83	132	0
489699	1	40	4	29.17	175	0
497335	0	35	1	25.28	209	1
497944	1	44	4	42.74	251	0
498003	0	29	1	29.41		1
504797	0	76	2	27.13		0
508876	0	56	3	24.07	209	0
512798	1	42	3	27.2	160	1
513117	1	24	2	21.69		1
513661	1	52	1	20	197	0
513937	0	34	1	24.36	313	1
514947	1	56	3	19.19	237	0
516516	0	87	1		177	0
518030	1	56	4	26.93		0
522842	0	22	4	29.47		0
523377	1	27	4	28.08	190	0
523483	1	40	2	30.34		0
524167	1	58	1	35.65	228	0
525108	0	36	4	28.55	160	0
526751	1	70	1	38.91		0
526818	1	25	4	34.62	170	0
528063	1	33	3	18.6	241	1
528395	0	26	3	20.86	140	1
528677	0	61	1	29.01		0
529215	0	55	1	22.63	135	0
530265	0	31	4	28.37	200	0
531059	1	65	4	34.7	198	0
534888	1	54	1	19.58	227	0
535328	1	21	4	23.91	125	0
535735	1	44	4	27.61	191	0
537500	0	44	2	32.77	152	0
541314	1	46	1	25.74	185	1
542455	0	26	1	22.79	136	0
543698	1	51	3	30.69	259	0
544973	1	59	1	21.82	163	0
545649	1	82	1	18.72	134	0
546192	1	42	1	39.65	258	0
547692	0	37	4	34.38	229	0
549991	1	25	4	22.48	151	1
550804	0	41	4	25.39	214	0
552550	1	49	3	27.84	251	0
554990	0	39	2	25.3	211	0
559444	1	27	4	22.33	291	1
564510	0	50	4	42.33	198	1
565209	1	64	1	24.47	222	0
565226	0	41	4	30.6	218	0
570712	1	20	4	25.83	193	1
572590	1	30	4	29.32	170	0
578894	1	53	2	27.37	198	0
582199	0	52	1	22.16	241	0
582587	0	48	1	33.01	249	1
582633	1	52	1	22.29	197	0
582925	1	43	2	44.71		0
583013	0	35	4	35.09	154	1
583730	1	69	1	24.87	213	0
585093	1	26	4	22.96	185	0
585194	0	26	1	22.81	162	0
588612	1	33	3	20.74		0
589628	0	66	2	27.1	172	0
596204	1	47	1	21.88	170	0
598356	1	45	3	21.83	158	0
598546	0	44	4	29.65	239	1
599253	0	36	4	23.98	245	1
600300	1	44	4		158	1
600457	0	52	2	40.07	111	0
601696	1	50	2	25.13	243	0
603341	1	46	1	25.39	186	1
605989	1	47	4	23.39		0
610943	0	26	2	22.33	165	0
611256	1	73	1	42.1	139	0
611747	1	33	4	29.38		0
611894	1	51	1	27.83	167	0
612244	0	31	4	25.37	160	1
613976	0	54	3	33.18	230	0
616485	0	46	1	25.92	228	1
618039	0	46	2	34.69	236	0
618264	1	79	1	34.34		0
621557	1	52	3	21.22	136	0
622209	1	77	1	41.76	274	0
622344	1	52	4	34.8	226	0
625466	1	56	2	36.3	165	0
626542	1	72	2	32.72		0
627033	0	29	1	27.73	160	0
627347	1	28	4	27.16	179	0
629860	1	27	2	25.02	142	0
631442	0	35	1	16.61	143	0
632007	1	28	3	25.21	222	0
634639	1	46	4	27.37	196	0
634943	1	39	4	27.34	216	0
636637	1	61	4	21.25	182	0
638014	1	34	4	31.26	131	0
639888	1	75	2	38.38	148	0
642475	1	66	2	37.21		0
643054	1	85	1	20.88	205	0
650262	0	44	4	26.35	146	1
654339	1	45	2	36.19	217	0
659676	1	52	2	27.32		0
663409	1	43	3	19.74	186	0
664102	1	37	3	23.1	222	0
664519	0	38	2	30.85	150	0
665480	0	41	1	28.47	251	0
667748	0	29	4	18.55	144	1
669690	1	61	4	26.02	180	0
675379	0	44	2	28.67	233	0
675389	1	39	4	23.5	129	0
677696	1	29	3	21.35	216	0
677895	1	54	2	38.41	224	0
678293	1	26	1	17.53	158	0
678871	0	42	1	32.74	197	0
682792	1	74	4	26.01	209	0
689637	1	48	1	20.86	161	0
690179	0	52	2	21.45	211	1
690322	1	22	3	22.77	182	0
694653	1	40	4	21.44	173	0
698489	1	27	1	22.83	196	0
707196	1	52	1	29.09	253	0
707953	0	89	2	25.59	180	1
709557	0	27	1	26.14	200	0
713005	1	48	1	25.09	168	0
713601	1	27	1	48.32	167	0
713674	0	61	4	28.58	192	1
715964	1	42	3	35.32	214	0
717862	1	70	2	38.75	274	0
719106	0	34	4	30.81	203	1
719585	1	77	4	31.87	137	0
719921	1	48	1	23.85	310	0
721430	0	22	1	31.32	229	0
722936	1	66	4	30.91	256	0
723421	1	44	1	22.53	208	0
728349	0	40	4	29.24	237	0
730917	1	35	4	26.56	250	0
733490	1	30	1	39.86	171	1
735652	1	23	1	27.38	222	1
741534	1	50	3	26.08	230	0
741665	1	67	2	25.85	217	0
741964	1	20	4	23.68	115	0
743072	0	61	2	33.42	196	0
743144	1	38	4	24.93	154	0
743892	1	44		25.85	229
744106	1	36	4	19.99	206	0
744799	1	49	1	24.52	172	1
745775	1	44	4	32.99	181	0
746069	1	51	2	24.41		0
749723	1	24	2	30.52	166	0
750553	0	29	3	25.91	198	1
752534	1	40	4	24.47	174	0
760905	0	21	1	25.68		0
764222	1	75	1	26.62	204	1
768134	0	24	4	23.99	150	1
769950	1	37	2	31.8	161	0
774444	0	62	1	21.44	137	1
776508	1	43	1	22.02		0
778198	1	23	1	24.76	170	0
781787	1	41	1	28.56	171	1
781977	0	76	4	26.88		0
785952	0	36	4	27.65	172	1
789516	1	49	4	31.25	175	0
794051	0	48	1	28.52	177	1
794996	1	46	3	24.16	210	0
798554	0	52	4	20.57	98	0
799493	1	50	1	29.52	235	1
799853	0	61	1	27.93	254	1
800402	1	38	4	26.83	197	0
803020	0	46	4	30.21	242	1
804218	1	49	1	34.74		1
804908	1	40		29.02	171	0
806918	0	28	4	32.87	181	0
807603	1	29	1	22.19	149	0
808182	1	35	3	22.65	174	0
809596	1	23	2	25.94	165	1
809644	1	30	1	28.77	216	0
811059	0	22	3	22.28	218	1
811076	0	55	2	26.16	173	0
812799	1	43	4	27.72	211	0
814257	1	39	4	27.36		0
814764	1	23	1	18.62		0
816672	0	32	1	32.95		1
816879	0	51	4	26.87		0
823239	0	35	2	36.59	170	0
823511	0	45	3	24.18	184	0
824919	1	42	4	22.71	195	1
826084	1	21	4	32.06	241	0
826327	1	46	4	36.96	170	0
827244	1	42	4	29.75	191	0
829076	1	25	1	21.2	210	1
832817	1	63	2	22.93	217	0
833076	0	65	1	28.19	270	0
834293	0	43	1	30.72	264	1
834890	0	21	3	22.68	200	0
835958	0	30	4	28.96	323	0
838487	1	47	1	34.44	190	0
845708	1	40	2	25.19		0
845761	0	29	1	24.92	156	1
847334	1	59	1	24.14		0
847431	1	43	2	26.49	133	0
851729	0	43	4	22.37	192	0
852780	0	43	2	22.47	161	0
854094	1	37	3	19.7	214	1
855773	1	33	3	23.21	226	0
859608	1	69	2	39.78	253	0
860322	1	23	4	29.23	156	0
861198	0	75	1	32.76	177	0
861380	0	20	2	19.96	157	0
863750	0	68	3	28.71	214	0
872284	0	84	1	26.72	245	0
874641	0	41	3	22.85	185	0
876025	1	21	4	29.32	183	0
876507	1	52	4	26.72	205	0
878364	1	48	3	30.51		1
878618	0	34	4	31.5	225	0
883492	1	58	4	24.6	242	0
884312	0	46	1	28.11		0
884906	0	24	4	35.07	170	1
885213	0	48	4	30.19		0
893946	1	40	1	20.6	181	0
897707	1	31	3	22.75	160	0
900415	1	48	3	26.63	279	0
901555	1	40	4	21.09	205	0
904794	0	47	1	32.38	206	0
905749	0	66	1	23.33		0
909195	0	61	3	21.11	189	0
909565	0	52	4	24.27	203	1
914348	1	35	4	30.08	161	0
918302	1	62	1	33.33		1
918946	0	43	1	18.55	216	0
921086	1	41	2	27.99	158	0
924275	1	52	3	20.22	195	0
925274	1	48	1	30.79	259	0
933712	1	63	4	29.39	351	0
936048	1	55	4	23.96	187	0
936364	0	51		27.44		0
937072	0	29	4	21.8	190	0
937268	0	34	4	21.82	174	1
943664	1	42	4	38.32	198	0
944331	1	38	4	28.03	165	0
946100	0	53	3	29.18	169	0
949787	0	72	1	28.92	180	0
950094	1	36	2	41.99	143	0
951538	1	38	4	24.71	175	1
952600	1	54	4	22.41	161	0
954597	0	33	2	43.37		0
956025	1	28	2	27.82		0
958557	1	46	4	31.62	199	0
958930	0	35	1	28.44		1
959158	1	59	1	44.33	223	0
960289	0	42	2	23.58	241	0
962454	1	39	4	19.39	200	1
970555	1	23	3	20.65	124	1
971261	0	44	1	24.36	269	1
972625	1	43	4	24.57	191	0
972735	1	23	4	24.89	134	0
976435	1	62	4	36.65		0
979133	0	37	2	24.71		1
979313	1	43	4	24.45	152	0
979431	1	26	4	19.7	152	0
979998	1	46	4	34.94	201	0
980709	1	55	1	27.87	194	0
982864	0	24	3	30.83	193	0
985047	0	25	1	21.51		0
987400	1	20	4	21.27	148	0
987703	1	35	4	35.75		0
989565	1	30	2	30.75	177	0
989911	1	38	4	30.12	185	0
991436	1	49	3	29.62	252	0
991451	1	35	1	20.9	171	1
992251	0	45	3	24.4	199	0
992920	1	30	4	30.2	140	0
993818	1	41	4	26.54	202	0
995246	1	35	1	24.03	137	0
995822	0	20	4	17.63	159	0
999478	1	51	1	24.69	223	0
999718	0	29	1	26.19	214	1