MM 207 Purdue Unit 6 Mental Health Linear Regression Equation Paper & Excel Sheet During this unit, you will learn about how to use Excel to create a linear regression equation. Please follow these steps:
Choose any Excel Discussion dataset. Include the name of the dataset. From that dataset, select any two quantitative variables that you suspect will be related (such as age and height for example). What is the name of the dataset you have chosen? Which two variables did you choose?
Next, using Excel, calculate the relationship (r value) between the two variables. Recall that the Excel “formula” for correlation is “=CORREL.” What is the r value for the two variables that you have chosen? Is it positive or negative? Is it strong, medium, or weak? Note that it is best to have an r value that is medium or strong. It is recommended that you try a few different variables until you find two variables with an r value between .5 and 1 (or between -.5 and -1).
Next, use Excel to create a scatterplot for the two variables. You decide which variable will be dependent (y) and which will be independent (x). On the scatterplot, include the “trendline” and the “equation for the line” using Excel options. Attach your scatterplot to your post.
Finally, using the equation of the line that you generated above, plug in any reasonable value for x (your chosen independent variable) and solve the equation for y (your chosen dependent variable). It is up to you to determine which of your two variables is x and which is y. What prediction do you get? Show all your work. In other words, type out the equation, plug in a value for x, and show your solution for y. MALE ID #
AGE
1391
2129
2489
2490
2738
2988
2989
3346
3606
3607
3608
3610
3747
4832
4839
5599
5600
5601
6226
7190
7192
7194
9073
9074
10864
12349
15515
16137
16521
16523
16768
17006
18392
19017
19381
19635
19991
20518
21135
32230
58
22
32
31
28
46
41
56
20
54
17
73
52
25
29
17
41
52
32
20
20
29
18
26
33
55
53
28
28
37
40
33
26
53
36
34
42
18
44
20
HEIGHT
(in.)
70.8
66.2
71.7
68.7
67.6
69.2
66.5
67.2
68.3
65.6
63
68.3
73.1
67.6
68
71
61.3
76.2
66.3
69.7
65.4
70
62.9
68.5
68.3
69.4
69.2
68
71.9
66.1
72.4
73
68
68.7
70.3
63.7
71.1
65.6
68.3
66.3
Notes: Age in years
HT: height in inches
WT: weight in pounds
WAIST: waist circumference in cm
WEIGHT
(lbs.)
119.9623
135.0044
141.1913
119.2234
142.2893
114.4376
139.1223
135.5864
135.8082
122.921
122.0601
124.8415
127.2254
123.8409
118.7168
136.3588
119.947
122.6357
136.0057
128.8957
137.8349
122.9765
139.068
137.8157
133.7542
138.7618
119.7526
125.1842
119.8783
140.4206
145.3173
122.3574
142.6855
143.7441
145.8434
127.2614
123.5906
145.918
118.9597
137.2507
WAIST
Month of
(in.)
PULSE
CHOL
BMI
Birth
38.43365
68
175
23.8 December
43.25597
64
118
23.2 January
45.62474
88
268
24.6 June
37.25318
72
262
26.2 December
45.59872
64
255
23.5 December
36.88445
72
194
24.5 August
45.03234
60
327
21.5 September
42.3498
88
269
31.4 June
42.84019
76
141
26.4 January
39.83487
60
293
22.7 August
39.59747
96
292
27.8 October
38.63728
72
239
28.1 January
41.29002
56
275
25.2 December
39.55765
64
308
23.3 October
38.18389
60
291
31.9 June
42.38728
64
128
33.1 December
38.21421
84
172
33.2 August
39.51569
76
259
26.7 November
43.55081
84
283
26.6 January
42.90048
88
301
19.9 May
44.41314
72
223
27.1 November
37.82213
56
265
23.4 December
45.60734
68
310
27 November
45.55108
64
247
21.6 September
43.15511
60
187
30.9 September
44.10674
68
271
28.3 May
37.34014
60
111
25.5 October
40.5983
60
153
24.6 December
38.44279
56
249
23.8 June
43.58905
84
217
27.4 January
45.87752
72
117
28.7 June
37.57996
84
161
26.2 May
44.28848
88
201
26.4 December
44.73608
56
132
32.1 November
45.84145
64
191
19.6 November
42.34512
56
307
20.7 January
40.1763
56
286
26.3 September
45.37722
60
240
26.9 October
38.30347
64
295
25.6 December
42.84417
72
256
24.2 June
PULSE: pulse rate in beats per minute
SYS: systolic blood pressure in mmHg
DIAS: diastolic blood pressure in mmHg
CHOL: cholesterol in mg
BMI: body mass index
LEG: upper leg length in cm
ELBOW: elbow breadth in cm
WRIST: wrist breadth in cm
ARM: arm circumference in cm
Credit: U.S. Department of Health and Human Services.
National Center for Health Statistics
Third National Health and Nutrition Examination Survey.
***delete the first column of ID numbers***
Purchase answer to see full
attachment