MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
6th Edition
ISBN: 9781119256830
Author: Amos Gilat
Publisher: John Wiley & Sons Inc
Bartleby Related Questions Icon

Related questions

bartleby

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
Check Mark
Knowledge Booster
Background pattern image
Statistics
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.
Similar questions
Recommended textbooks for you
Text book image
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Text book image
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Text book image
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Text book image
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
Text book image
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Text book image
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman