library(readxl)
library(dplyr)
##
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
##
## filter, lag
## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union
data_kesehatan <- read_excel("data_kesehatan.xlsx")
data_kesehatan <- as.data.frame(data_kesehatan)
data_kesehatan
## id umur jenis_kelamin tinggi_badan berat_badan gula_darah tekanan_sistolik
## 1 1 33 Perempuan 159.5587 62.85027 80.08403 129.29775
## 2 2 59 Perempuan 152.9881 54.73592 79.20090 108.63735
## 3 3 39 Perempuan 156.1915 66.84162 99.64040 132.77287
## 4 4 64 Laki-laki 173.8024 54.83932 97.35650 108.78105
## 5 5 67 Perempuan 164.0242 62.21020 49.01314 129.45360
## 6 6 20 Perempuan 150.0967 61.15284 120.81147 136.44992
## 7 7 45 Perempuan 157.9015 59.39500 104.99451 105.17336
## 8 8 64 Laki-laki 165.8377 55.87974 148.32415 136.61993
## 9 9 47 Perempuan 156.7671 62.21052 113.70396 112.65701
## 10 10 42 Perempuan 161.3638 58.73365 91.06081 124.41530
## 11 11 68 Perempuan 162.9534 39.93666 155.94782 123.02756
## 12 12 42 Laki-laki 171.7058 57.82400 156.64452 113.59205
## 13 13 53 Laki-laki 178.6273 86.87589 75.62576 124.02154
## 14 14 48 Perempuan 159.2637 61.65035 109.38064 101.54354
## 15 15 23 Perempuan 157.5179 62.21498 95.77506 117.95795
## 16 16 65 Perempuan 144.1411 66.57205 103.74102 132.38686
## 17 17 31 Perempuan 159.4424 58.44678 104.55085 87.38813
## 18 18 20 Laki-laki 164.9385 63.24518 74.76199 97.68111
## 19 19 35 Perempuan 163.2124 52.62787 105.71179 102.57094
## 20 20 68 Laki-laki 161.0070 85.46609 134.98495 96.16365
## 21 21 64 Perempuan 170.6770 50.16811 96.71820 126.29375
## 22 22 54 Laki-laki 174.3259 73.18390 96.74147 105.10607
## 23 23 51 Laki-laki 177.7689 78.46436 127.97144 87.53179
## 24 24 70 Laki-laki 174.9531 71.78190 117.96792 110.43647
## 25 25 52 Perempuan 155.6892 57.85835 67.03010 114.14047
## 26 26 55 Perempuan 157.2980 55.26486 104.57114 132.85178
## 27 27 46 Laki-laki 165.0678 71.70588 133.07094 103.44372
## 28 28 49 Laki-laki 164.9795 59.36502 128.30553 137.41934
## 29 29 33 Perempuan 169.8014 50.64308 108.39903 125.97544
## 30 30 26 Laki-laki 162.8909 90.86717 114.42442 125.43528
## 31 31 68 Laki-laki 183.6871 63.21497 76.06130 107.21211
## 32 32 65 Perempuan 162.2705 55.22136 106.00263 149.30502
## 33 33 54 Perempuan 161.8002 66.31568 80.91102 117.53594
## 34 34 59 Laki-laki 164.8303 73.10230 90.83964 92.62654
## 35 35 19 Perempuan 160.1156 58.46580 118.71207 116.94215
## 36 36 43 Perempuan 153.5355 62.27103 77.26214 90.98334
## 37 37 57 Perempuan 164.2762 45.99146 105.33837 115.34235
## 38 38 29 Perempuan 166.5087 53.45064 108.56664 113.66659
## 39 39 35 Perempuan 146.6501 60.44972 101.09824 130.22745
## 40 40 30 Laki-laki 164.5292 65.07063 136.44378 135.14244
## 41 41 25 Laki-laki 164.4796 61.65812 79.55305 109.10843
## 42 42 40 Perempuan 162.7286 81.47887 112.12261 132.09163
## 43 43 40 Laki-laki 180.4724 71.57353 98.22139 141.36485
## 44 44 37 Perempuan 158.8007 60.51395 94.78336 108.23784
## 45 45 26 Laki-laki 168.7466 66.04202 109.28182 110.21393
## 46 46 25 Laki-laki 183.3165 78.99354 79.59199 129.76168
## 47 47 30 Laki-laki 169.2932 61.69188 73.73098 122.74572
## 48 48 42 Perempuan 165.2998 68.36245 90.11038 128.23162
## 49 49 32 Perempuan 147.6860 72.92436 135.03514 141.07026
## 50 50 63 Perempuan 150.1817 59.76245 101.11530 125.80625
## 51 51 20 Laki-laki 167.3708 50.61495 106.62869 135.77552
## 52 52 41 Perempuan 166.2798 59.22070 96.20307 129.34358
## 53 53 60 Perempuan 162.6117 68.13164 109.40985 126.50431
## 54 54 24 Laki-laki 170.6335 55.49176 80.96641 125.79127
## 55 55 47 Laki-laki 181.1896 74.80626 123.15821 139.36985
## 56 56 29 Laki-laki 169.3800 61.71826 111.69411 104.96610
## 57 57 25 Laki-laki 177.5656 80.20253 83.87094 103.42226
## 58 58 57 Laki-laki 174.4153 75.38482 101.09106 128.87919
## 59 59 65 Perempuan 161.3837 61.17367 114.32663 118.20466
## 60 60 37 Laki-laki 159.2697 71.20719 111.15462 121.11008
## 61 61 53 Perempuan 165.2318 67.28968 129.63868 131.11916
## 62 62 23 Perempuan 157.9092 61.13967 87.74024 131.29943
## 63 63 38 Perempuan 163.1110 48.88413 122.32273 116.05994
## 64 64 32 Laki-laki 179.1014 69.71605 120.73096 115.31184
## 65 65 60 Perempuan 153.4433 58.69372 96.75034 121.10398
## 66 66 41 Laki-laki 180.8331 70.31526 80.48147 135.94527
## 67 67 60 Perempuan 164.4454 45.11818 78.21710 126.39031
## 68 68 60 Laki-laki 157.7043 68.44655 109.15574 141.49511
## 69 69 59 Laki-laki 167.2785 75.68289 98.57747 119.88545
## 70 70 41 Laki-laki 170.6245 80.10678 135.58205 136.88501
## 71 71 57 Laki-laki 175.9151 64.82018 110.70276 133.24503
## 72 72 51 Laki-laki 176.7377 67.05905 92.56110 129.18125
## 73 73 55 Laki-laki 174.7902 73.97842 79.48916 126.22051
## 74 74 18 Perempuan 158.5639 67.22813 88.35197 115.80176
## 75 75 43 Laki-laki 175.9475 70.91267 106.85777 118.36444
## 76 76 29 Perempuan 160.9101 75.60577 90.98131 123.44093
## 77 77 38 Laki-laki 171.2236 58.80100 110.28460 120.73333
## 78 78 50 Laki-laki 170.5219 56.72245 93.31324 134.14837
## 79 79 36 Laki-laki 172.9972 61.46376 97.88880 118.36024
## 80 80 24 Laki-laki 170.1727 63.06695 85.38981 118.94435
## 81 81 31 Perempuan 160.1227 63.81630 138.10087 112.73521
## 82 82 53 Perempuan 161.8843 52.22405 106.65243 117.92496
## 83 83 40 Laki-laki 172.7022 62.72616 104.61267 118.96852
## 84 84 59 Laki-laki 168.1404 60.03161 66.16275 85.29396
## 85 85 23 Laki-laki 170.8270 59.58311 113.19584 99.52752
## 86 86 41 Perempuan 164.6732 63.65886 79.52753 118.91270
## 87 87 69 Perempuan 165.4886 51.69495 82.16957 116.02074
## 88 88 64 Perempuan 156.5536 55.16389 118.36682 101.98696
## 89 89 64 Laki-laki 168.4666 66.78675 90.94599 90.12693
## 90 90 27 Perempuan 157.7143 63.16237 65.03255 114.68446
## 91 91 25 Laki-laki 178.1787 69.08566 135.39808 129.80244
## 92 92 52 Laki-laki 177.3793 81.87187 52.45186 146.59858
## 93 93 36 Laki-laki 178.0168 81.91601 111.45623 119.42315
## 94 94 52 Laki-laki 165.9577 62.11037 120.34498 142.39777
## 95 95 35 Laki-laki 184.0174 54.52223 87.38064 121.24533
## 96 96 28 Perempuan 151.8515 54.39197 108.88574 121.73298
## 97 97 59 Perempuan 161.0911 61.92837 108.78261 124.87238
## 98 98 23 Perempuan 160.9890 57.18037 120.81246 106.94134
## 99 99 42 Laki-laki 170.1469 74.20574 109.68199 119.22423
## 100 100 45 Laki-laki 178.7494 53.85961 95.10232 133.62672
## 101 101 49 Perempuan 156.3886 51.88709 118.31984 108.75411
## 102 102 35 Perempuan 154.0378 53.66949 116.01245 115.17591
## 103 103 43 Laki-laki 163.4302 63.06905 81.26862 102.78344
## 104 104 68 Perempuan 164.5064 73.11242 71.98425 125.31528
## 105 105 43 Laki-laki 166.9399 56.35291 103.20555 126.37200
## 106 106 64 Laki-laki 172.3183 75.89983 94.52075 129.72521
## 107 107 66 Perempuan 154.6243 66.60738 80.28922 101.70285
## 108 108 50 Laki-laki 171.4839 60.95785 101.67861 121.60853
## 109 109 39 Laki-laki 178.6567 72.26325 73.60007 105.83913
## 110 110 26 Laki-laki 184.2630 77.48081 103.22453 119.99423
## 111 111 67 Perempuan 159.4158 80.60360 87.50143 140.13936
## 112 112 34 Laki-laki 175.2974 67.87152 119.14329 112.44712
## 113 113 21 Perempuan 165.2948 60.80736 148.48978 130.75025
## 114 114 67 Laki-laki 165.7895 69.13286 81.68042 108.75497
## 115 115 55 Perempuan 156.3014 64.71869 121.15328 112.82208
## 116 116 25 Perempuan 155.5912 68.77287 116.50299 126.58083
## 117 117 47 Perempuan 159.2092 71.56530 98.59612 109.81332
## 118 118 68 Perempuan 161.8601 44.59884 90.92707 94.45553
## 119 119 48 Laki-laki 181.7910 73.73241 131.50615 138.97753
## 120 120 39 Laki-laki 176.3797 74.03290 59.89084 125.40536
## 121 121 52 Laki-laki 171.6620 59.58327 87.13610 111.24541
## 122 122 35 Perempuan 159.3503 58.30280 71.26313 90.08882
## 123 123 34 Laki-laki 160.6286 76.41830 127.90627 148.53315
## 124 124 29 Laki-laki 174.6257 54.70689 96.18593 170.85556
## 125 125 37 Perempuan 166.6879 65.32128 89.50658 123.11221
## 126 126 69 Laki-laki 174.7862 72.50248 163.68089 132.74710
## 127 127 26 Laki-laki 169.5742 75.63867 98.99925 138.36840
## 128 128 23 Perempuan 160.8346 61.57022 91.12501 109.47293
## 129 129 25 Laki-laki 179.3486 62.67146 105.99731 114.73206
## 130 130 54 Perempuan 156.6493 63.44879 68.63151 94.09318
## 131 131 50 Perempuan 163.6322 61.51002 109.80605 108.95133
## 132 132 64 Perempuan 156.9620 49.26205 98.07674 129.33615
## 133 133 53 Laki-laki 164.9488 50.56349 109.37050 115.63926
## 134 134 56 Laki-laki 180.6345 83.99576 80.35259 116.78683
## 135 135 45 Laki-laki 172.6417 69.43944 79.54032 118.31161
## 136 136 52 Laki-laki 155.6344 75.24914 86.13171 92.04500
## 137 137 61 Perempuan 166.9915 54.50547 84.64021 132.56445
## 138 138 59 Laki-laki 168.5945 69.03314 125.98100 98.34761
## 139 139 69 Laki-laki 176.0605 69.24737 131.58291 116.87145
## 140 140 41 Laki-laki 169.2868 80.19157 96.86216 113.42155
## 141 141 34 Laki-laki 174.3693 77.11602 92.82127 116.72109
## 142 142 39 Perempuan 157.1878 57.12020 93.41922 141.89949
## 143 143 19 Perempuan 164.2250 46.51267 101.38473 111.26910
## 144 144 28 Laki-laki 170.3921 76.64416 101.93808 108.25354
## 145 145 62 Perempuan 165.1982 56.33792 105.80069 97.20519
## 146 146 30 Laki-laki 157.7273 47.89367 85.06642 107.91453
## 147 147 30 Laki-laki 170.6953 96.91714 83.06207 102.50723
## 148 148 22 Laki-laki 165.9970 65.17323 123.94155 126.11919
## 149 149 31 Perempuan 174.5814 57.82186 89.02745 107.05494
## 150 150 56 Laki-laki 168.7407 73.74644 106.06091 124.56063
## 151 151 62 Laki-laki 177.1046 85.38430 98.86059 117.80359
## 152 152 44 Laki-laki 156.0508 68.90290 80.84301 98.49657
## 153 153 38 Perempuan 166.6643 61.24925 111.82124 108.14088
## 154 154 31 Laki-laki 170.8165 72.13958 103.46210 133.27669
## 155 155 24 Laki-laki 163.7475 68.13879 127.99567 133.54614
## 156 156 38 Perempuan 151.2462 47.02513 102.34919 150.08360
## 157 157 48 Laki-laki 172.8800 80.12834 93.36908 119.94630
## 158 158 29 Laki-laki 169.7687 67.98542 105.56590 97.56260
## 159 159 41 Laki-laki 152.7387 49.62318 76.28817 108.47374
## 160 160 29 Perempuan 156.2225 67.64293 83.28212 126.12733
## 161 161 44 Perempuan 154.9969 66.27337 110.20547 148.50205
## 162 162 36 Laki-laki 174.5584 76.16456 93.33758 121.65014
## 163 163 52 Laki-laki 171.9164 76.16568 98.68078 137.10580
## 164 164 37 Laki-laki 177.1727 53.07898 97.69557 131.52122
## 165 165 36 Perempuan 152.8828 60.77269 86.98975 102.47863
## 166 166 46 Laki-laki 168.5314 79.67859 59.62623 117.43331
## 167 167 56 Perempuan 163.1979 45.21222 106.97670 139.57892
## 168 168 29 Laki-laki 163.3821 67.75039 115.23279 133.14144
## 169 169 39 Perempuan 158.1895 59.37969 74.22568 126.95694
## 170 170 32 Laki-laki 166.7727 84.87838 129.64805 127.15671
## 171 171 51 Laki-laki 186.9174 53.32072 107.70310 112.62892
## 172 172 28 Laki-laki 158.4427 65.63170 126.83281 100.20922
## 173 173 63 Perempuan 155.3096 48.01041 80.85659 139.43139
## 174 174 57 Perempuan 161.9224 51.18813 103.33563 98.69671
## 175 175 53 Laki-laki 173.5709 72.79628 97.99972 105.91656
## 176 176 50 Laki-laki 165.8736 88.77864 115.37015 129.43447
## 177 177 37 Perempuan 164.0395 53.60389 88.48281 101.06708
## 178 178 46 Laki-laki 171.0113 67.21546 99.79805 111.72194
## 179 179 63 Laki-laki 169.8998 74.74912 64.42682 102.25801
## 180 180 48 Perempuan 160.1566 61.17134 84.44757 129.30995
## 181 181 62 Laki-laki 170.2419 78.13400 102.50068 126.69470
## 182 182 34 Perempuan 159.3859 51.00317 85.87357 126.32827
## 183 183 55 Perempuan 152.9106 57.55624 99.12861 126.63697
## 184 184 32 Perempuan 162.9919 55.86592 90.64148 128.35869
## 185 185 49 Perempuan 153.7663 72.09916 112.13860 129.59035
## 186 186 43 Perempuan 158.6427 53.84412 123.36977 90.47008
## 187 187 32 Perempuan 162.2886 59.34330 83.54997 117.76775
## 188 188 47 Perempuan 155.2989 66.29707 93.85927 121.68696
## 189 189 65 Perempuan 163.4979 51.53128 128.79523 130.87014
## 190 190 65 Laki-laki 172.4227 63.46220 56.02153 102.18771
## 191 191 32 Perempuan 143.1414 65.40610 93.60324 112.50600
## 192 192 35 Laki-laki 154.8965 60.86434 141.29409 103.89536
## 193 193 69 Laki-laki 176.1898 78.86749 143.87180 135.85860
## 194 194 50 Laki-laki 164.1937 73.33370 103.13191 139.18609
## 195 195 67 Laki-laki 165.9851 68.29360 82.72782 131.81515
## 196 196 42 Laki-laki 180.5273 78.18828 103.30915 101.66395
## 197 197 39 Laki-laki 164.5810 73.88365 86.94451 126.77928
## 198 198 52 Laki-laki 175.9201 65.54065 129.05635 137.25674
## 199 199 26 Perempuan 167.0871 55.81907 83.87035 122.51911
## 200 200 48 Perempuan 171.1595 58.00647 107.45823 111.50836
## tekanan_diastolik kolesterol skor_kesehatan
## 1 69.13882 181.32930 100.00000
## 2 73.34697 209.69540 100.00000
## 3 87.14848 176.38007 88.52949
## 4 75.68339 172.18406 100.00000
## 5 82.27615 138.68861 100.00000
## 6 92.94946 183.71655 75.39378
## 7 85.78335 264.36237 80.21044
## 8 93.64673 219.69107 59.51184
## 9 62.98420 240.26716 76.40171
## 10 77.19324 217.44896 95.02224
## 11 80.65068 224.32788 48.51474
## 12 85.78589 217.08629 62.26762
## 13 68.30793 204.26177 96.82670
## 14 88.06185 172.52414 100.00000
## 15 83.07390 174.01196 100.00000
## 16 82.63806 141.97480 85.92333
## 17 85.08485 189.82547 100.00000
## 18 78.83642 216.98067 100.00000
## 19 89.25546 220.95768 90.72733
## 20 86.48230 192.85398 67.80169
## 21 78.49791 173.57117 94.09372
## 22 90.40377 288.71552 77.75112
## 23 82.92559 212.10057 85.65371
## 24 86.68751 232.61726 80.64646
## 25 74.05822 179.86958 100.00000
## 26 95.80432 188.86127 93.04345
## 27 79.96011 203.45821 76.98552
## 28 88.47843 240.29567 67.08839
## 29 78.99883 180.65576 87.27387
## 30 77.20370 215.60847 60.08132
## 31 87.84438 127.15556 100.00000
## 32 64.15383 174.78237 88.97758
## 33 84.78366 151.23973 100.00000
## 34 83.93566 223.40088 95.54148
## 35 53.04671 185.06641 91.28614
## 36 83.68377 178.28878 100.00000
## 37 58.31582 231.07300 78.69969
## 38 86.59804 223.48819 84.01331
## 39 75.46086 163.05936 90.56092
## 40 73.05063 202.83599 69.44558
## 41 79.93154 153.14666 100.00000
## 42 93.73052 175.73155 75.93673
## 43 73.64677 238.49733 81.59355
## 44 85.58103 233.50384 91.65975
## 45 83.41158 223.27056 87.91820
## 46 68.20481 172.87288 100.00000
## 47 62.58978 133.55706 100.00000
## 48 60.07414 154.72905 100.00000
## 49 85.51274 218.57670 45.44594
## 50 79.65258 181.28296 90.69250
## 51 98.50572 125.12176 99.78350
## 52 85.73675 184.59438 98.97290
## 53 88.49696 232.30718 75.01840
## 54 93.34384 209.30406 96.87835
## 55 74.99281 165.36224 86.55135
## 56 85.10098 143.62250 100.00000
## 57 88.68793 165.20358 100.00000
## 58 93.69352 191.03583 90.67423
## 59 87.62651 216.64221 83.79867
## 60 84.21147 131.80180 96.46025
## 61 71.31776 220.69605 68.50658
## 62 87.29560 190.16373 97.28383
## 63 85.00266 207.09337 78.62644
## 64 86.34250 140.40233 100.00000
## 65 84.23645 170.00037 100.00000
## 66 77.98162 176.55297 100.00000
## 67 79.23134 221.31674 90.30077
## 68 86.87364 220.84522 69.50376
## 69 81.71632 203.05271 87.39251
## 70 71.69891 238.12637 53.51686
## 71 77.09841 174.53766 91.99147
## 72 66.80874 220.37612 92.00174
## 73 70.32968 188.92180 100.00000
## 74 78.55389 169.97974 100.00000
## 75 62.01867 217.70140 88.37807
## 76 63.11458 231.43301 78.60337
## 77 91.02565 216.34751 84.13958
## 78 74.23381 174.71790 97.46217
## 79 61.48308 175.90637 100.00000
## 80 78.87137 231.33028 96.88081
## 81 93.21069 200.58479 74.94486
## 82 86.62254 214.88722 86.99939
## 83 84.41383 179.83894 98.63909
## 84 91.83746 227.83105 100.00000
## 85 72.28499 165.73735 100.00000
## 86 87.29689 208.76055 100.00000
## 87 74.12914 165.48475 100.00000
## 88 80.00764 116.12275 100.00000
## 89 102.14465 149.71127 100.00000
## 90 89.69434 194.08886 100.00000
## 91 87.68008 216.48768 71.93331
## 92 68.91672 137.46094 100.00000
## 93 72.13764 152.45727 96.15151
## 94 102.84116 242.93638 68.02514
## 95 69.06699 176.98302 97.35104
## 96 82.14479 205.17100 88.01014
## 97 88.92571 174.19194 94.20821
## 98 90.18758 181.04251 96.06106
## 99 90.89112 192.61733 87.49844
## 100 78.36871 190.32886 87.53790
## 101 71.79013 184.22319 94.46348
## 102 76.92743 175.90611 95.88734
## 103 70.97902 98.56417 100.00000
## 104 86.27069 246.05967 88.18862
## 105 91.20355 243.71273 79.28644
## 106 101.27214 156.96755 100.00000
## 107 83.66114 184.95677 100.00000
## 108 71.25219 231.25826 85.76841
## 109 90.24475 219.94870 100.00000
## 110 89.04759 228.29805 87.17492
## 111 77.61751 157.84759 88.14031
## 112 64.42145 267.31804 73.44250
## 113 87.61310 155.99620 80.16160
## 114 91.29144 212.61749 100.00000
## 115 77.04892 194.23828 81.77373
## 116 85.36243 177.88869 79.76589
## 117 77.24110 178.61753 94.47592
## 118 86.82315 160.25810 100.00000
## 119 78.82709 238.67979 65.12971
## 120 76.55324 192.68540 100.00000
## 121 81.11620 197.77654 100.00000
## 122 77.16595 196.28898 100.00000
## 123 74.08983 178.74488 64.11414
## 124 76.84063 155.97936 85.34060
## 125 79.91848 197.61179 99.28702
## 126 82.07495 127.19082 76.14837
## 127 95.32424 147.44299 96.40854
## 128 66.42002 157.70810 100.00000
## 129 78.00381 157.63963 100.00000
## 130 86.31523 193.21566 100.00000
## 131 97.62021 237.95463 84.84621
## 132 84.26014 144.54028 100.00000
## 133 79.86247 203.01028 86.68373
## 134 76.92443 216.98634 96.66257
## 135 84.14308 160.31403 100.00000
## 136 89.89058 188.41602 98.51579
## 137 78.16142 214.70833 92.40607
## 138 81.63761 182.33473 91.56964
## 139 82.16936 183.37947 86.22689
## 140 87.29278 199.23180 89.48931
## 141 91.11380 188.19960 98.40598
## 142 82.79161 173.33041 97.92177
## 143 79.23829 185.84155 93.74989
## 144 93.94663 246.48519 80.02805
## 145 81.64534 216.21006 95.43306
## 146 95.77852 162.56209 100.00000
## 147 79.38077 152.65247 100.00000
## 148 86.13923 179.20053 85.38529
## 149 64.53911 229.86324 93.77802
## 150 78.87608 198.78037 85.45402
## 151 79.78205 168.95484 96.11934
## 152 72.41655 216.46704 97.54007
## 153 69.64107 185.99889 98.94197
## 154 89.48159 156.37965 96.80100
## 155 89.14159 203.83577 71.20314
## 156 67.01268 235.72428 74.48061
## 157 84.24379 203.03405 90.45487
## 158 68.87455 195.76001 100.00000
## 159 69.48927 170.31271 100.00000
## 160 85.25412 207.05196 90.62093
## 161 73.13976 157.88288 82.25335
## 162 89.93480 140.40553 100.00000
## 163 80.38524 188.69942 87.74158
## 164 85.36149 188.96219 87.39012
## 165 74.76373 260.95167 86.60551
## 166 68.48779 153.50958 100.00000
## 167 89.14752 195.12719 78.65485
## 168 82.38071 214.15159 75.20394
## 169 77.60932 221.51779 99.23040
## 170 80.69235 189.67827 65.83611
## 171 93.25908 167.70232 90.70285
## 172 73.01833 188.02648 85.38622
## 173 72.50592 248.19268 84.35429
## 174 73.80385 204.48217 96.85953
## 175 64.15009 128.66569 100.00000
## 176 88.19628 232.70377 57.96087
## 177 81.92370 206.21508 100.00000
## 178 82.07172 188.99285 100.00000
## 179 79.56653 189.46409 100.00000
## 180 74.89840 185.50631 100.00000
## 181 71.76581 197.69678 84.67545
## 182 88.51856 174.88399 100.00000
## 183 65.73815 198.31034 90.91384
## 184 84.40299 162.05932 100.00000
## 185 72.07388 196.00441 72.24570
## 186 82.82310 223.20512 88.64576
## 187 72.59309 205.27618 100.00000
## 188 74.76658 221.01249 83.77710
## 189 97.69366 157.27394 84.71513
## 190 86.68283 191.64378 100.00000
## 191 58.55103 208.51751 81.22331
## 192 81.26412 157.95985 85.99595
## 193 75.48187 236.97443 54.22224
## 194 68.63374 158.95576 89.39700
## 195 82.09786 194.93556 97.88776
## 196 81.29966 194.55497 99.33587
## 197 76.71493 193.65011 92.80241
## 198 99.72704 183.68726 79.65326
## 199 57.51310 203.49810 99.83833
## 200 88.38219 159.06507 100.00000
##Cek Missing Value
colSums(is.na(data_kesehatan))
## id umur jenis_kelamin tinggi_badan
## 0 0 0 0
## berat_badan gula_darah tekanan_sistolik tekanan_diastolik
## 0 0 0 0
## kolesterol skor_kesehatan
## 0 0
##Rata-rata tinggi laki-laki
rata_tinggi_laki <- mean(data_kesehatan$tinggi_badan[data_kesehatan$jenis_kelamin == "Laki-laki"], na.rm = TRUE)
print(paste("Rata-rata tinggi laki-laki adalah", rata_tinggi_laki, "cm"))
## [1] "Rata-rata tinggi laki-laki adalah 171.021544039084 cm"
##Jumlah responden yang memenuhi semua indikator sehat (gula <110, kolesterol <200, tekanan <130/85)?
data_sehat <- subset(data_kesehatan,
gula_darah < 110 &
kolesterol < 200 &
tekanan_sistolik < 130 &
tekanan_diastolik < 85)
jumlah_ressehat <- nrow(data_sehat)
print(paste("Jumlah responder yang memenuhi semua indikator sehat adalah", jumlah_ressehat, "orang"))
## [1] "Jumlah responder yang memenuhi semua indikator sehat adalah 48 orang"
##Rata-rata skor kesehatan per kelompok umur, <30, 30-50, dan >50 tahun secara berturut-turut
data <- data_kesehatan %>%
mutate(umur_kategori = case_when(
umur < 30 ~ "<30",
umur >= 30 & umur <= 50 ~ "30-50",
umur > 50 ~ ">50"
))
rata_rata <- data %>%
group_by(umur_kategori) %>%
summarize(rata_rata_skor = mean(skor_kesehatan, na.rm = TRUE))
print(rata_rata)
## # A tibble: 3 × 2
## umur_kategori rata_rata_skor
## <chr> <dbl>
## 1 30-50 89.4
## 2 <30 90.4
## 3 >50 89.5