Health economics
1. How many males are in the data set? How many females?
2. Calculate the mean, median, minimum, maximum, and standard deviation for self-reported health.
3. Create a scatter plot displaying the relationship between BMI and age where BMI is on the Y-axis and age is on the X-axis. Include a line of best fit in the graph with the functional relationship (e.g. BMI=Intercept+number*age).
4. Create a new variable in Column H equal to age squared.
5. Calculate the proportion of the sample with a university level education.
6. What is the correlation between BMI and self-reported health. Provide a 1-2 sentence interpretation of this result.
7. How many individuals exercise at least 2-3 times per week?
Sheet1
BMI gender age Education How would you rate your health on a scale from 0-100 Exercise Future Health Data Key
19.130764 Female 35 1 95 5 3 Eduction
27.893906 Male 48 3 75 2 2 1 High School
23.007812 Female 61 1 80 2 3 2 Diploma or trade certificate
28.696568 Male 29 1 100 4 2 3 University
21.956327 Female 66 1 95 1 3
35.668575 Male 35 1 85 2 3 Exercise
22.314217 Female 62 3 90 5 2 1 Never
25.03616 Male 57 2 90 5 3 2 Less than once a week
30.245049 Male 29 1 70 1 3 3 Once a week
22.797702 Female 23 3 100 5 4 4 2-3 times a week
24.327406 Male 36 1 70 1 4 5 about everyday
17.531045 Male 22 2 75 4 3
31.473318 Male 54 1 90 5 3 Future Health
27.196543 Male 27 1 70 4 4 1 Pessimistic
24.63144 Male 68 2 80 4 3 2 neither optimistic nor pessimistic
26.853266 Male 48 2 100 1 4 3 Optimistic
25.092799 Male 46 1 75 3 2 4 Very Optimistic
28.621679 Male 37 1 80 4 3 Self-Rated Health
29.288632 Male 68 1 85 3 3 0-100 Scale
44.478762 Male 22 3 70 4 4
22.240076 Female 43 1 100 2 4
39.628105 Female 48 1 70 2 2
47.2747 Male 60 1 85 2 3
24.411951 Male 24 2 95 2 4
27.891446 Male 51 2 85 5 3
30.113565 Female 41 3 85 2 2
17.574247 Female 54 1 95 5 3
23.129372 Male 51 1 80 1 2
26.625248 Female 52 3 95 5 3
32.521783 Female 26 1 85 3 3
23.726149 Male 43 3 85 4 3
41.469388 Female 32 1 80 1 1
19.52555 Male 50 1 90 1 4
25.853898 Male 62 3 75 5 2
31.311771 Female 36 1 80 2 4
21.301272 Male 31 2 95 1 4
22.106381 Male 52 1 75 2 2
33.962681 Male 53 1 85 4 3
21.632907 Female 54 1 80 4 2
36.020567 Female 43 1 80 3 3
25.395719 Male 65 1 80 2 3
31.973022 Male 37 3 85 4 4
31.754818 Female 66 1 90 5 4
22.957128 Female 51 3 90 2 4
30.420561 Male 59 1 75 5 3
20.50611 Female 20 2 75 2 2
23.110218 Male 21 1 90 4 2
27.483645 Female 67 1 100 5 4
25.842501 Male 48 2 75 4 3
32.441421 Female 37 1 100 5 4
29.26405 Female 61 1 85 2 4
25.036258 Male 28 3 90 5 4
24.275901 Male 45 3 95 5 4
33.673291 Female 66 1 85 5 4
35.868337 Female 27 1 70 4 3
24.146179 Male 65 2 95 2 3
33.836358 Female 66 1 90 3 4
23.873136 Female 72 3 85 5 2
25.797802 Female 50 1 75 4 3
19.066698 Female 35 3 85 4 3
44.281898 Female 75 3 90 2 3
19.021409 Female 31 3 90 5 3
27.45714 Female 86 2 75 5 3
26.566387 Male 58 3 95 5 4
22.195039 Female 20 1 85 1 3
23.228272 Female 67 1 90 1 3
17.218004 Male 21 2 90 3 4
31.247503 Female 57 1 95 4 4
27.397544 Female 19 3 80 2 3
22.958752 Male 55 2 85 1 2
30.088565 Male 59 3 95 4 3
25.237954 Female 57 1 85 4 3
32.280487 Male 56 2 75 1 3
22.657443 Female 71 2 85 4 2
21.107266 Female 34 3 85 4 3
27.893906 Male 48 2 80 4 4
32.426698 Male 54 3 80 1 3
28.057628 Male 42 1 100 2 3
35.187644 Female 56 3 80 5 3
22.959086 Male 38 1 100 1 4
19.82102 Female 60 3 70 4 2
25.801817 Male 49 3 90 4 2
24.372938 Male 71 3 95 5 4
31.957605 Female 50 3 90 3 3
33.717312 Male 50 1 85 4 3
20.797556 Male 31 3 95 5 4
24.783624 Male 53 1 95 2 4
21.699445 Male 41 2 90 4 3
32.171691 Female 26 1 100 4 3
23.326889 Male 70 1 85 1 3
30.046279 Female 51 1 75 2 3
27.022529 Female 43 2 85 3 2
17.99308 Female 43 1 85 5 3
19.140625 Female 28 3 90 2 4
25.109607 Male 25 3 75 2 3
23.110218 Male 45 3 70 4 2
39.051407 Male 48 2 95 4 4
22.150622 Male 55 3 85 2 2
39.34669 Male 49 3 90 1 3
33.985947 Male 49 1 75 3 4
19.577551 Female 42 2 90 2 3
26.614527 Female 33 2 80 4 3
33.113202 Female 60 1 80 2 3
25.090077 Male 34 3 90 5 4
20.982331 Female 26 1 85 4 3
24.023571 Male 27 1 90 4 4
29.179868 Female 35 3 80 4 3
31.350649 Female 26 3 75 2 3
24.874243 Female 79 1 85 1 3
26.571013 Female 69 3 95 5 4
36.580073 Female 51 3 90 5 3
29.620431 Female 24 3 85 5 3
21.965653 Female 67 1 75 5 2
32.770713 Female 60 2 70 2 1
24.804687 Female 65 2 80 4 3
22.86643 Female 23 2 80 2 3
25.824133 Female 64 2 100 4 4
25.385606 Female 25 2 90 4 4
43.815165 Female 37 3 95 2 3
23.687385 Female 28 2 90 2 4
24.447279 Male 32 3 90 4 4
24.799269 Female 74 1 70 1 3
37.120368 Female 54 2 90 5 3
40.625456 Male 28 2 70 5 3
24.470205 Female 27 3 80 4 3
30.168745 Male 41 3 90 5 3
27.45714 Male 55 1 80 5 3
34.299383 Female 48 2 90 2 4
24.327612 Female 67 1 85 5 2
23.492785 Female 31 2 85 4 3
23.028227 Female 69 2 90 2 3
25.39941 Male 60 3 90 5 4
24.5662 Female 36 3 90 4 4
50.199003 Male 43 2 95 2 4
23.450918 Female 32 3 80 4 3
43.895249 Female 67 1 75 4 3
25.069765 Male 67 3 90 2 2
22.806901 Male 34 1 75 1 3
28.368495 Male 44 1 85 4 3
32.612883 Female 53 2 75 5 2
26.570701 Female 56 2 75 3 1
20.079271 Female 55 3 85 4 3
25.462963 Male 36 3 90 2 4
27.653559 Female 61 1 100 4 4
32.190468 Female 72 1 90 4 3
26.948711 Female 54 1 85 4 4
40.17355 Male 28 2 70 2 3
23.627373 Male 69 3 70 4 3
25.801817 Male 59 1 90 1 2
22.518518 Male 75 3 80 1 3
23.709728 Male 72 2 90 4 3
27.439446 Male 21 2 85 2 3
27.893906 Female 51 1 95 4 3
19.631902 Female 20 1 90 1 4
32.190468 Female 47 2 85 4 3
26.150269 Male 74 2 90 2 4
27.372743 Male 42 3 85 5 3
29.444534 Male 49 1 90 4 3
23.388687 Female 30 2 90 4 4
18.177471 Female 22 1 75 3 4
24.80884 Male 76 1 95 3 4
25.746853 Female 48 2 90 4 2
22.2984 Female 50 2 80 4 3
24.912427 Female 43 1 90 1 4
29.413998 Male 76 1 95 4 3
31.092804 Female 55 2 90 4 3
24.902665 Female 54 3 80 4 3
25.104125 Female 63 2 70 5 3
28.90625 Female 46 3 75 4 4
28.321879 Female 67 2 80 4 2
34.997003 Male 24 1 75 5 3
25.422012 Female 28 2 75 5 4
21.162319 Female 21 1 85 3 4
24.411951 Male 57 1 95 1 3
21.757812 Female 33 1 90 4 4
27.408364 Male 70 1 75 4 3
22.862546 Female 54 3 90 4 3
31.011131 Female 40 3 90 4 3
17.805408 Female 30 1 90 5 4
29.288632 Male 39 2 80 4 3
30.727078 Female 43 1 90 3 2
27.385356 Male 31 3 90 4 3
25.678217 Male 53 1 95 4 3
21.369768 Female 75 3 75 1 2
25.017107 Male 42 2 75 2 3
24.210081 Female 35 3 95 4 3
23.140496 Male 30 3 80 4 3
27.815924 Male 30 2 85 4 2
21.939611 Female 57 1 95 4 4
27.938327 Male 63 3 95 4 4
25.835037 Male 50 3 95 5 4
32.270788 Female 23 2 80 1 2
49.214458 Male 28 2 70 2 2
20.118992 Female 31 3 70 4 3
30.813246 Male 71 1 85 5 3
28.057628 Male 57 3 90 5 4
22.198833 Male 67 1 85 5 3
22.768166 Female 46 1 70 1 1
25.109607 Male 61 1 85 4 3
27.408364 Male 42 3 90 2 3
24.8886 Female 63 3 100 5 4
24.906982 Female 28 3 85 4 2
25.697228 Female 66 3 85 2 2
21.03351 Female 27 3 90 3 4
24.412118 Female 41 2 90 1 4
22.673628 Female 40 3 85 5 3
28.480709 Male 65 1 95 5 3
31.870145 Male 58 1 75 3 3
28.501753 Female 64 2 90 4 3
38.824001 Female 68 1 90 4 4
24.475309 Male 41 2 85 5 4
23.709943 Male 28 3 90 2 4
21.789001 Female 69 3 95 4 3
25.115791 Male 32 1 90 4 3
21.789001 Female 48 1 75 2 3
23.777064 Female 59 1 80 4 2
22.957128 Male 58 3 70 5 2
23.709943 Male 69 3 85 2 2
20.614694 Male 38 1 80 1 3
27.560706 Female 31 3 75 4 3
18.79409 Female 44 3 90 5 3
32.948012 Male 69 1 100 4 4
31.617128 Male 56 1 80 5 3
23.564602 Female 54 3 80 5 3
27.27586 Male 54 3 85 4 3
27.261708 Male 43 1 80 2 3
24.944065 Female 47 1 80 4 3
21.613618 Female 40 2 85 2 3
30.651917 Female 20 2 70 3 3
22.144531 Female 67 1 95 1 4
32.441081 Male 61 2 95 5 4
23.021962 Male 21 1 95 5 4
31.384083 Female 73 1 90 2 4
33.226364 Male 42 1 100 1 4
22.142511 Female 60 3 70 2 2
24.221453 Male 24 1 80 2 2
23.629012 Male 51 3 90 4 4
29.294281 Male 46 3 95 4 4
22.606103 Female 74 3 95 4 4
22.803557 Male 72 3 90 5 3
21.632907 Female 64 3 70 1 3
27.319252 Male 57 3 85 5 2
27.459398 Female 69 1 90 2 3
28.191687 Male 53 1 100 5 4
28.057628 Female 38 2 80 4 3
19.91088 Female 44 3 80 5 2
27.419192 Male 68 2 75 2 3
31.176157 Female 21 2 90 2 4
31.323943 Female 42 1 80 5 2
26.580877 Male 47 1 85 4 3
22.809502 Female 38 3 90 4 4
21.286396 Female 36 3 80 4 3
30.131428 Male 60 3 80 4 3
45.911724 Male 43 1 80 2 2
19.368308 Female 33 3 85 5 4
19.688171 Female 2 85 1 3
25.827037 Male 71 1 75 5 3
22.998242 Male 55 2 85 1 3
30.66647 Female 67 2 80 2 3
26.027582 Male 35 3 80 2 3
