MATLAB: An Introduction with Applications
6th Edition
ISBN: 9781119256830
Author: Amos Gilat
Publisher: John Wiley & Sons Inc
expand_more
expand_more
format_list_bulleted
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 3 images
Knowledge Booster
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
- The following table shows the starting salary and profile of a sample of 10 employees in a certain call center agency. Run a multiple regression analysis with starting salary as the dependent variable (pesos) and GPA, years of experience and civil service ratings as the independent variables. Use .05 level of significance. Copy-paste the data and run the analysis using MS Excel. starting salary GPA Years of experience Civil Service Ratings 15000 80.1 1 79.5 15000 81.2 1 78.0 15500 81.3 2 79.0 16000 82.4 3 80.0 16200 83.4 3 85.0 17500 87.9 4 89.9 18000 90.3 5 89.1 16300 84.2 3 84.1 17000 87.0 4 89.0 17900 88.1 5 89.2 What is the computed R square of the resulting multiple linear regression and its interpretation?arrow_forwardPlease answer... I'm needed only 1 hours time to dd .... Thank uarrow_forwardListed below are systolic blood pressure measurements (in mm Hg) obtained from the same woman. Find the regression equation, letting the fight arm blood pressure be the predictor (x) variable. Find the best predicted systolic blood pressure in the left arm given that the systolic blood pressure in the right arm is 90 mm Hg. Use a significance level of 0.05. Right Arm Left Arm % 102 101 94 80 79 177 172 143 143 143 Click the icon to view the critical values of the Pearson correlation coefficient r The regression equation is y=+x. (Round to one decimal place as needed.). Given that the systolic blood pressure in the right arm is 90 mm Hg, the best predicted systolic blood pressure in the left arm is mm Hg. (Round to one decimal place as needed) M H N H & C Copyright ©2022 Pearson Education Inc. All rights reserved. | Terms of Use | Privacy Policy | Permissions | Contact Us | a 33 M 0 8 K Vi 1. fio 11 O More (2) { 87°F Next [ insert prt sc 7:46 8/5/2 backspacearrow_forward
- Can you please check my workarrow_forwardplease please answer fast please please answer super super fastarrow_forwardIdentify whether this statement is True or False and provide justification for your answer. “A positive correlation between attitude and intention will always result in a significant effect between the two variables in regression analysis.”arrow_forward
- i submitted a picture of the questionarrow_forwardPLEASE ANSWER 4,5 AND 6arrow_forwardUsing the data in the Excel spreadsheet "auto.xlsx", estimate a regression to answer the following question. A 1 inch increase in LENGTH corresponds to a _________________ increase in MPG (miles per gallon). Use negative values if it results in a decreased price. Round your answers to two decimals. make price mpg rep78 headroom trunk weight length turn displacement gear_ratio foreign AMC Concord 4,099 22 3 3 11 2,930 186 40 121 3.58 Domestic AMC Pacer 4,749 17 3 3 11 3,350 173 40 258 2.53 Domestic AMC Spirit 3,799 22 3 12 2,640 168 35 121 3.08 Domestic Buick Century 4,816 20 3 5 16 3,250 196 40 196 2.93 Domestic Buick Electra 7,827 15 4 4 20 4,080 222 43 350 2.41 Domestic Buick LeSabre 5,788 18 3 4 21 3,670 218 43 231 2.73 Domestic Buick Opel 4,453 26 3 10 2,230 170 34 304 2.87 Domestic Buick Regal 5,189 20 3 2 16 3,280 200 42 196 2.93 Domestic Buick Riviera 10,372 16 3 4 17 3,880 207 43 231 2.93 Domestic Buick Skylark 4,082 19 3 4 13 3,400 200 42 231…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman