Conduct simple linear regression analyses relating each predictor to Glucose using the Regression tool in the Data Analysis toolpak The data is provided below. Thank you! GLUCOSE AGE SEX SYSBP TOTCHOL CURSMOKE DIABETES 77 39 1 106 195 0 0 76 46 2 121 250 0 0 70 48 1 127.5 245 1 0 103 61 2 150 225 1 0 85 46 2 130 285 1 0 99 43 2 180 228 0 0 85 63 2 138 205 0 0 78 45 2 100 313 1 0 79 52 1 141.5 260 0 0 88 43 1 162 225 1 0 76 50 2 133 254 0 0 61 43 2 131 247 0 0 64 46 1 142 294 1 0 84 41 2 124 332 0 0 39 2 114 226 1 0 70 38 2 140 221 1 0 72 48 1 138 232 1 0 89 46 2 112 291 1 0 78 38 2 122 195 1 0 65 41 1 139 195 0 0 85 42 2 108 190 1 0 43 2 123.5 185 0 0 113 52 2 148 234 0 0 75 52 2 132 215 1 0 83 44 1 137.5 270 1 0 66 47 1 102 294 1 0 60 2 110 260 0 0 83 35 1 132 225 1 0 65 61 2 182 272 0 0 74 60 2 130 247 0 0 63 36 1 102 295 1 0 75 43 1 115 226 1 0 79 40 1 125 227 0 0 88 59 2 150 209 0 0 75 61 1 134 175 1 0 73 62 1 125 235 0 0 87 54 1 147 214 1 0 83 37 1 124.5 225 0 0 75 56 1 153.5 257 0 0 225 52 1 160 178 0 1 90 42 2 153 233 1 0 80 36 1 111 180 0 0 78 43 2 116.5 243 1 0 74 41 2 122 237 1 0 52 2 148 0 0 100 54 1 132 195 0 0 215 53 2 206 311 0 1 98 49 2 96 208 0 0 87 65 2 179.5 252 0 0 74 46 1 119 261 1 0 75 63 2 116 179 1 0 62 36 1 139 194 1 0 79 63 2 156.5 267 1 0 95 51 1 112 216 0 0 75 47 2 130 237 1 0 75 62 2 145 240 0 0 39 2 115 209 1 0 94 46 2 116 250 1 0 55 54 2 114 266 1 1 80 49 1 143.5 255 1 0 82 44 1 115 185 0 0 87 40 2 158 205 1 0 93 56 1 121 270 1 0 74 67 2 157 254 0 0 73 53 1 123.5 220 1 0 72 57 2 126.5 235 1 0 64 57 1 136 220 0 0 45 63 2 154 252 0 0 202 62 2 190 212 0 1 78 38 1 107 223 1 0 83 47 2 112.5 300 1 0 87 52 2 110 302 0 0 63 2 164.5 248 0 0 95 42 1 116 175 1 0 87 37 2 119 200 0 0 75 41 2 150 189 1 0 83 44 2 110 221 1 0 103 59 2 138.5 258 0 0 68 44 2 155 202 0 0 89 44 2 115 213 1 0 63 45 2 151 183 0 0 65 41 1 152 274 1 0 83 60 1 179 170 1 0 70 39 1 155 285 0 0 87 53 2 138 210 0 0 82 52 2 124 170 1 0 83 61 2 182 210 0 0 65 36 2 113 197 1 0 77 62 2 138 261 0 0 78 61 2 200 326 1 0 70 41 1 124 252 1 0 195 62 1 117.5 286 1 1 76 41 1 121 274 0 0 75 53 1 138 188 1 0 97 39 1 132.5 256 1 0 77 51 2 102 244 0 0 104 66 2 154 311 0 0 77 52 1 136 288 1 0 65 60 1 126 243 1 0

Conduct simple linear regression analyses relating each predictor to Glucose using the Regression tool in the Data Analysis toolpak The data is provided below. Thank you! GLUCOSE AGE SEX SYSBP TOTCHOL CURSMOKE DIABETES 77 39 1 106 195 0 0 76 46 2 121 250 0 0 70 48 1 127.5 245 1 0 103 61 2 150 225 1 0 85 46 2 130 285 1 0 99 43 2 180 228 0 0 85 63 2 138 205 0 0 78 45 2 100 313 1 0 79 52 1 141.5 260 0 0 88 43 1 162 225 1 0 76 50 2 133 254 0 0 61 43 2 131 247 0 0 64 46 1 142 294 1 0 84 41 2 124 332 0 0 39 2 114 226 1 0 70 38 2 140 221 1 0 72 48 1 138 232 1 0 89 46 2 112 291 1 0 78 38 2 122 195 1 0 65 41 1 139 195 0 0 85 42 2 108 190 1 0 43 2 123.5 185 0 0 113 52 2 148 234 0 0 75 52 2 132 215 1 0 83 44 1 137.5 270 1 0 66 47 1 102 294 1 0 60 2 110 260 0 0 83 35 1 132 225 1 0 65 61 2 182 272 0 0 74 60 2 130 247 0 0 63 36 1 102 295 1 0 75 43 1 115 226 1 0 79 40 1 125 227 0 0 88 59 2 150 209 0 0 75 61 1 134 175 1 0 73 62 1 125 235 0 0 87 54 1 147 214 1 0 83 37 1 124.5 225 0 0 75 56 1 153.5 257 0 0 225 52 1 160 178 0 1 90 42 2 153 233 1 0 80 36 1 111 180 0 0 78 43 2 116.5 243 1 0 74 41 2 122 237 1 0 52 2 148 0 0 100 54 1 132 195 0 0 215 53 2 206 311 0 1 98 49 2 96 208 0 0 87 65 2 179.5 252 0 0 74 46 1 119 261 1 0 75 63 2 116 179 1 0 62 36 1 139 194 1 0 79 63 2 156.5 267 1 0 95 51 1 112 216 0 0 75 47 2 130 237 1 0 75 62 2 145 240 0 0 39 2 115 209 1 0 94 46 2 116 250 1 0 55 54 2 114 266 1 1 80 49 1 143.5 255 1 0 82 44 1 115 185 0 0 87 40 2 158 205 1 0 93 56 1 121 270 1 0 74 67 2 157 254 0 0 73 53 1 123.5 220 1 0 72 57 2 126.5 235 1 0 64 57 1 136 220 0 0 45 63 2 154 252 0 0 202 62 2 190 212 0 1 78 38 1 107 223 1 0 83 47 2 112.5 300 1 0 87 52 2 110 302 0 0 63 2 164.5 248 0 0 95 42 1 116 175 1 0 87 37 2 119 200 0 0 75 41 2 150 189 1 0 83 44 2 110 221 1 0 103 59 2 138.5 258 0 0 68 44 2 155 202 0 0 89 44 2 115 213 1 0 63 45 2 151 183 0 0 65 41 1 152 274 1 0 83 60 1 179 170 1 0 70 39 1 155 285 0 0 87 53 2 138 210 0 0 82 52 2 124 170 1 0 83 61 2 182 210 0 0 65 36 2 113 197 1 0 77 62 2 138 261 0 0 78 61 2 200 326 1 0 70 41 1 124 252 1 0 195 62 1 117.5 286 1 1 76 41 1 121 274 0 0 75 53 1 138 188 1 0 97 39 1 132.5 256 1 0 77 51 2 102 244 0 0 104 66 2 154 311 0 0 77 52 1 136 288 1 0 65 60 1 126 243 1 0

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Concept explainers

Question

I am having difficulty with question 3. Can you please provide the steps that necessary in Excel to complete following:

Conduct simple linear regression analyses relating each predictor to Glucose using

the Regression tool in the Data Analysis toolpak

The data is provided below. Thank you!

GLUCOSE	AGE	SEX	SYSBP	TOTCHOL	CURSMOKE	DIABETES
77	39	1	106	195	0	0
76	46	2	121	250	0	0
70	48	1	127.5	245	1	0
103	61	2	150	225	1	0
85	46	2	130	285	1	0
99	43	2	180	228	0	0
85	63	2	138	205	0	0
78	45	2	100	313	1	0
79	52	1	141.5	260	0	0
88	43	1	162	225	1	0
76	50	2	133	254	0	0
61	43	2	131	247	0	0
64	46	1	142	294	1	0
84	41	2	124	332	0	0
	39	2	114	226	1	0
70	38	2	140	221	1	0
72	48	1	138	232	1	0
89	46	2	112	291	1	0
78	38	2	122	195	1	0
65	41	1	139	195	0	0
85	42	2	108	190	1	0
	43	2	123.5	185	0	0
113	52	2	148	234	0	0
75	52	2	132	215	1	0
83	44	1	137.5	270	1	0
66	47	1	102	294	1	0
	60	2	110	260	0	0
83	35	1	132	225	1	0
65	61	2	182	272	0	0
74	60	2	130	247	0	0
63	36	1	102	295	1	0
75	43	1	115	226	1	0
79	40	1	125	227	0	0
88	59	2	150	209	0	0
75	61	1	134	175	1	0
73	62	1	125	235	0	0
87	54	1	147	214	1	0
83	37	1	124.5	225	0	0
75	56	1	153.5	257	0	0
225	52	1	160	178	0	1
90	42	2	153	233	1	0
80	36	1	111	180	0	0
78	43	2	116.5	243	1	0
74	41	2	122	237	1	0
	52	2	148		0	0
100	54	1	132	195	0	0
215	53	2	206	311	0	1
98	49	2	96	208	0	0
87	65	2	179.5	252	0	0
74	46	1	119	261	1	0
75	63	2	116	179	1	0
62	36	1	139	194	1	0
79	63	2	156.5	267	1	0
95	51	1	112	216	0	0
75	47	2	130	237	1	0
75	62	2	145	240	0	0
	39	2	115	209	1	0
94	46	2	116	250	1	0
55	54	2	114	266	1	1
80	49	1	143.5	255	1	0
82	44	1	115	185	0	0
87	40	2	158	205	1	0
93	56	1	121	270	1	0
74	67	2	157	254	0	0
73	53	1	123.5	220	1	0
72	57	2	126.5	235	1	0
64	57	1	136	220	0	0
45	63	2	154	252	0	0
202	62	2	190	212	0	1
78	38	1	107	223	1	0
83	47	2	112.5	300	1	0
87	52	2	110	302	0	0
	63	2	164.5	248	0	0
95	42	1	116	175	1	0
87	37	2	119	200	0	0
75	41	2	150	189	1	0
83	44	2	110	221	1	0
103	59	2	138.5	258	0	0
68	44	2	155	202	0	0
89	44	2	115	213	1	0
63	45	2	151	183	0	0
65	41	1	152	274	1	0
83	60	1	179	170	1	0
70	39	1	155	285	0	0
87	53	2	138	210	0	0
82	52	2	124	170	1	0
83	61	2	182	210	0	0
65	36	2	113	197	1	0
77	62	2	138	261	0	0
78	61	2	200	326	1	0
70	41	1	124	252	1	0
195	62	1	117.5	286	1	1
76	41	1	121	274	0	0
75	53	1	138	188	1	0
97	39	1	132.5	256	1	0
77	51	2	102	244	0	0
104	66	2	154	311	0	0
77	52	1	136	288	1	0
65	60	1	126	243	1	0

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Correlation, Regression, and Association$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.