R programming
Module Assignment
Module 4
QMB-6304 Analytical Methods for Business
Write a simple R script to execute the following:
Preprocessing
- Load into R the data included in “Assignment 4 Data.xlsx”. This data set shows age (years), weight (pounds), and height (inches) for 251 adults. This will be your master data set.
- Create a new variable in the master data set which will be each individual’s body mass index. The calculation should be done as:
BMI=(weight* .45)(height* .025)2
- Using the method presented in class and applying the numerical portion of your U number as a random number seed, take a random sample of 45 cases from the master data set. This will be your primary data set.
Analysis
- Use R to conduct a simple linear regression on the data with weight as the independent variable and bmi as the dependent variable. As a part of this be sure to:
Report the beta coefficients and associated p values and confidence intervals from your model.
Give a written interpretation of your beta coefficients in terms of the actual case at hand.
Assess your model’s conformance with the LINE assumptions of regression.
Give a prediction using your model for an individual weighing 185 pounds. Include 95% confidence and prediction intervals and written interpretations of both intervals. - A 10-year-old boy has been presented to you who weighs 72 pounds. Give two reasons for why it would be wrong to use your model to predict the boy’s BMI.
Your deliverable will be a single MS-Word file showing 1) the R script which executes the above instructions and 2) the results of those instructions. The first line of your script file should be a “#” comment line showing your name as it appears in Canvas. Results should be presented in the order in which they are listed here. Deliverable due time will be announced in class and on Canvas. This is an individual assignment to be completed and submitted by the time stated on Canvas. No collaboration of any sort is allowed on this assignment. Please remember the prohibition on using screen shots in your deliverable.
6304 Assignment 4 Data (1).xlsx
fat
IDNO AGE WEIGHT HEIGHT
1 23 154.25 67.75
2 22 173.25 72.25
3 22 154.00 66.25
4 26 184.75 72.25
5 24 184.25 71.25
6 24 210.25 74.75
7 26 181.00 69.75
8 25 176.00 72.50
9 25 191.00 74.00
10 23 198.25 73.50
11 26 186.25 74.50
12 27 216.00 76.00
13 32 180.50 69.50
14 30 205.25 71.25
15 35 187.75 69.50
16 35 162.75 66.00
17 34 195.75 71.00
18 32 209.25 71.00
19 28 183.75 67.75
20 33 211.75 73.50
21 28 179.00 68.00
22 28 200.50 69.75
23 31 140.25 68.25
24 32 148.75 70.00
25 28 151.25 67.75
26 27 159.25 71.50
27 34 131.50 67.50
28 31 148.00 67.50
29 27 133.25 64.75
30 29 160.75 69.00
31 32 182.00 73.75
32 29 160.25 71.25
33 27 168.00 71.25
34 41 218.50 71.00
35 41 247.25 73.50
36 49 191.75 65.00
37 40 202.25 70.00
38 50 196.75 68.25
39 46 363.15 72.25
40 50 203.00 67.00
41 45 262.75 68.75
42 48 217.00 70.00
43 41 212.00 71.50
44 39 125.25 68.00
45 43 164.25 73.25
46 40 133.50 67.50
47 39 148.50 71.25
48 45 135.75 68.50
49 47 127.50 66.75
50 47 158.25 72.25
51 40 139.25 69.00
52 51 137.25 67.75
53 49 152.75 73.50
54 42 136.25 67.50
55 54 198.00 72.00
56 58 181.50 68.00
57 62 201.25 69.50
58 54 202.50 70.75
59 61 179.75 65.75
60 62 216.00 73.25
61 56 178.75 68.50
62 54 193.25 70.25
63 61 178.00 67.00
64 57 205.50 70.00
65 55 183.50 67.50
66 54 151.50 70.75
67 55 154.75 71.50
68 54 155.25 69.25
69 55 156.75 71.50
70 62 167.50 71.50
71 55 146.75 68.75
72 56 160.75 73.75
73 55 125.00 64.00
74 61 143.00 65.75
75 61 148.25 67.50
76 57 162.50 69.50
77 69 177.75 68.50
78 81 161.25 70.25
79 66 171.25 69.25
80 67 163.75 67.75
81 64 150.25 67.25
82 64 190.25 72.75
83 70 170.75 70.00
84 72 168.00 69.25
85 67 167.00 67.50
86 72 157.75 67.25
87 64 160.00 65.75
88 46 176.75 72.50
89 48 176.00 73.00
90 46 177.00 70.00
91 44 179.75 69.50
92 47 165.25 70.50
93 46 192.50 71.75
94 47 184.25 74.50
95 53 224.50 77.75
96 38 188.75 73.25
97 50 162.50 66.50
98 46 156.50 68.25
99 47 197.00 72.00
100 49 198.50 73.50
101 48 173.75 72.00
102 41 172.75 71.25
103 49 196.75 73.75
104 43 177.00 69.25
105 43 165.50 68.50
106 43 200.25 73.50
107 52 203.25 74.25
108 43 194.00 75.50
109 40 168.50 69.25
110 43 170.75 68.50
111 43 183.25 70.00
112 47 178.25 70.00
113 42 163.00 70.25
114 48 175.25 71.75
115 40 158.00 69.25
116 48 177.25 72.75
117 51 179.00 72.00
118 40 191.00 74.00
119 44 187.50 72.25
120 52 206.50 74.50
121 44 185.25 71.50
122 40 160.25 68.75
123 47 151.50 66.75
124 50 161.00 66.50
125 46 167.00 67.00
126 42 177.50 68.75
127 43 152.25 67.75
128 40 192.25 73.25
129 42 165.25 69.75
130 49 171.75 71.50
131 40 171.25 70.50
132 47 197.00 73.25
133 50 157.00 66.75
134 41 168.25 69.50
135 44 186.00 69.75
136 39 166.75 70.75
137 43 187.75 74.00
138 40 168.25 71.25
139 49 212.75 75.00
140 40 176.75 71.00
141 40 173.25 69.50
142 52 167.00 67.75
143 23 159.75 72.25
144 23 188.15 77.50
145 24 156.00 70.75
146 24 208.50 72.75
147 25 206.50 69.75
148 25 143.75 72.50
149 26 223.00 70.25
150 26 152.25 69.00
151 26 241.75 74.50
152 27 146.00 72.25
153 27 156.75 67.25
154 27 200.25 73.50
155 28 171.50 75.25
156 28 205.75 69.00
157 28 182.50 72.25
158 30 136.50 68.75
159 31 177.25 71.50
160 31 151.25 72.25
161 33 196.00 73.00
162 33 184.25 68.75
163 34 140.00 70.50
164 34 218.75 72.00
165 35 217.00 73.75
166 35 166.25 68.00
167 35 224.75 72.25
168 35 228.25 69.50
169 35 172.75 69.50
170 35 152.25 67.75
171 35 125.75 65.50
172 35 177.25 71.00
173 36 176.25 71.50
174 36 226.75 71.75
175 37 145.25 69.25
176 37 151.00 67.00
177 37 241.25 71.50
178 38 187.25 69.25
179 39 234.75 74.50
180 39 219.25 74.25
181 40 118.50 68.00
182 40 145.75 67.25
183 40 159.25 69.75
184 40 170.50 74.25
185 40 167.50 71.50
186 41 232.75 74.25
187 41 210.50 72.00
188 41 202.25 72.50
189 41 185.00 68.25
190 41 153.00 69.25
191 42 244.25 76.00
192 42 193.50 70.50
193 42 224.75 74.75
194 42 162.75 72.75
195 42 180.00 68.25
196 42 156.25 69.00
197 42 168.00 71.50
198 42 167.25 72.75
199 43 170.75 67.50
200 43 178.25 70.25
201 43 150.00 69.25
202 43 200.50 71.50
203 44 184.00 74.00
204 44 223.00 69.75
205 44 208.75 73.00
206 44 166.00 65.50
207 47 195.00 72.50
208 47 160.50 70.25
209 47 159.75 70.75
210 49 140.50 68.00
211 49 216.25 74.50
212 49 168.25 71.75
213 50 194.75 70.75
214 50 172.75 73.00
215 51 219.00 64.00
216 51 149.25 69.75
217 51 154.50 70.00
218 52 199.25 71.75
219 53 154.50 69.25
220 54 153.25 70.50
221 54 230.00 72.25
222 54 161.75 67.50
223 55 142.25 67.25
224 55 179.75 68.75
225 55 126.50 66.75
226 55 169.50 68.25
227 55 198.50 74.25
228 56 174.50 69.50
229 56 167.75 68.50
230 57 147.75 65.75
231 57 182.25 71.75
232 58 175.50 71.50
233 58 161.75 67.25
234 60 157.75 67.50
235 62 168.75 67.50
236 62 191.50 72.25
237 63 219.15 69.50
238 64 155.25 69.50
239 65 189.75 65.75
240 65 127.50 65.75
241 65 224.50 68.25
242 66 234.25 72.00
243 67 227.75 72.75
244 67 199.50 68.50
245 68 155.50 69.25
246 69 215.50 70.50
247 70 134.25 67.00
248 72 201.00 69.75
249 72 186.75 66.00
250 72 190.75 70.50
251 74 207.50 70.00
._6304 Assignment 4 Data (1).xlsx