This data set contains information related to medical charges to insurances. age: age of primary beneficiary .bmi: Body mass index, providing an understanding of body weights that are relatively high or low relative to height, objective index of body weight (kg/m^2) using the ratio of height to weight, ideally 18.5 to 24.9 .children:nr. of children in the family -region: the beneficiary's residential area in the US, northeast, southeast, southwest, northwest. .charges: Individual medical costs billed by health insurance 1. Make a general analysis of the data: age, gender, region, etc. 2. Analyze the charges for different categories: gender • region 3. Analyze the BMI for the two genders. 3. Is there indication that the charges are related to age or BMI? Please explain the relationship. Based on plots and tables 4. Check whether the charges differ per region (base your answer on descriptive statistics and box plots) 5. Analyze the distribution of the charges for different region. 6. Give 95% CI for the mean and variance of the charges for two regions of your choice. Explain why you are allowed to use the normal ort distribution to construct these confidence intervals. Instructions: • Explain the meaning of the terminology used (e.g. the median is equal to ..., which means that 50% of the data .... And the other 50% ....) • Number ALL the graphs/tables used in the project and refer to them in the text. • For the CI, you can take the data from the descriptive statistics tables Follow the structure in the general project instructions on BB
age gender 47 female 19 male 22 female 59 male 51 female 40 female 54 male 30 male 55 female 52 female 46 male 46 female 63 female 59 female 52 male 28 female 29 male 25 male 22 female 25 male 18 male 19 male 47 male 31 male 19 female 18 male 28 male 33 male 32 male 31 female 46 female 37 female 37 male 60 female 25 male 62 female 23 male 56 female 27 male 19 male 52 female 23 male 56 male 30 male 60 female 30 female bmi children region charges 26.6 2 northeast 9715.841 20.615 2 northwest 2803.698 24.3 O southwest 2150.469 31.79 2 southeast 12928.79 21.56 1 southeast 9855.131 28.12 1 northeast 22331.57 40.565 3 northeast 48549.18 27.645 1 northeast 4237.127 32.395 1 northeast 11879.1 31.2 O southwest 9625.92 26.62 1 southeast 7742.11 48.07 2 northeast 9432.925 26.22 O northwest 14256.19 36.765 1 northeast 47896.79 26.4 3 southeast 25992.82 33.4 O southwest 3172.018 29.64 1 northeast 20277.81 45.54 2 southeast 42112.24 28.82 O southeast 2156.752 26.8 3 southwest 3906.127 22.99 O northeast 1704.568 27.7 O southwest 16297.85 25.41 1 southeast 21978.68 34.39 3 northwest 38746.36 27.9 O southwest 16884.92 33.77 1 southeast 1725.552 33 3 southeast 4449.462 22.705 O northwest 21984.47 28.88 O northwest 3866.855 25.74 O southeast 3756.622 33.44 1 southeast 8240.59 27.74 3 northwest 7281.506 29.83 2 northeast 6406.411 25.84 O northwest 28923.14 26.22 O northeast 2721.321 26.29 O southeast 27808.73 34.4 O southwest 1826.843 39.82 O southeast 11090.72 42.13 O southeast 39611.76 24.6 1 southwest 1837.237 30.78 1 northeast 10797.34 23.845 O northeast 2395.172 40.3 O southwest 10602.39 35.3 O southwest 36837.47 36.005 O northeast 13228.85 32.4 1 southwest 4149.736
18 male 34 female 37 male 59 female 63 female 55 female 23 male 31 male 22 male 18 female 19 female 63 male 28 male 19 male 62 female 26 male 35 male 60 male 24 female 31 female 41 male 37 female 38 male 55 male 18 female 28 female 60 female 36 male 18 female 21 female 48 male 36 male 40 female 58 male 58 female 18 male 53 female 34 female 43 male 25 male 64 male 28 female 20 female 19 female 61 female 40 male 40 female 34.1 31.92 28.025 27.72 23.085 32.775 17.385 36.3 35.6 26.315 28.6 28.31 36.4 20.425 32.965 20.8 36.67 39.9 26.6 36.63 21.78 30.8 37.05 37.3 38.665 34.77 24.53 35.2 35.625 33.63 28 34.43 28.69 36.955 31.825 31.68 22.88 37.335 27.36 33.66 24.7 25.935 22.42 28.9 39.1 26.315 36.19 O southeast 1137.011 1 northeast 37701.88 2 northwest 6203.902 3 southeast 14001.13 O northeast 14451.84 2 northwest 12268.63 1 northwest 2775.192 2 southwest 38711 O southwest 35585.58 O northeast 2198.19 5 southwest 4687.797 O northwest 13770.1 1 southwest 51194.56 O northwest 1625.434 3 northwest 15612.19 O southwest 2302.3 1 northeast 39774.28 O southwest 48173.36 O northeast 3046.062 2 southeast 4949.759 1 southeast 6272.477 2 southeast 6313.759 1 northeast 6079.672 O southwest 20630.28 2 northeast 3393.356 O northwest 3556.922 O southeast 12629.9 1 southeast 38709.18 O northeast 2211.131 2 northwest 3579.829 1 southwest 23568.27 O southeast 37742.58 3 northwest 8059.679 2 northwest 47496.49 2 northeast 13607.37 2 southeast 34303.17 1 southeast 23244.79 2 northwest 5989.524 3 northeast 8606.217 4 southeast 4504.662 1 northwest 30166.62 1 northwest 4133.542 O northwest 14711.74 O southwest 1743.214 2 southwest 14235.07 1 northwest 6389.378 O southeast 5920.104
28 male 27 female 31 male 53 female 58 male 44 male 57 male 29 female 21 male 22 female 41 female 31 male 45 female 22 male 48 female 37 female 45 male 57 female 56 female 46 female 55 female 21 female 53 female 59 male 35 male 64 female 28 female 54 female 55 male 56 male 38 male 41 female 30 male 18 female 61 female 34 female 20 male 19 female 26 male 29 male 63 male 54 male 55 female 37 male 21 female 52 male 60 male 23.98 24.75 28.5 28.1 32.01 27.4 34.01 29.59 35.53 39.805 32.965 26.885 38.285 37.62 41.23 34.8 22.895 31.16 27.2 27.74 26.98 39.49 24.795 29.83 34.77 31.3 37.62 30.8 38.28 19.95 19.3 31.6 25.46 30.115 29.92 27.5 28.025 28.4 30.875 27.94 35.09 33.63 29.7 30.8 35.72 32.205 28.595 3 southeast 17663.14 O southeast 16577.78 5 northeast 6799.458 3 southwest 11741.73 1 southeast 11946.63 2 southwest 7726.854 O northwest 11356.66 1 southeast 3947.413 O southeast 1532.47 O northeast 2755.021 O northwest 6571.024 1 northeast 4441.213 O northeast 7935.291 1 southeast 37165.16 4 northwest 11033.66 2 southwest 39836.52 2 northwest 21098.55 O northwest 43578.94 O southwest 11073.18 O northwest 8026.667 O northwest 11082.58 O southeast 2026.974 1 northwest 10942.13 3 northeast 30184.94 2 northwest 5729.005 2 southwest 47291.06 1 southeast 3766.884 3 southwest 12105.32 O southeast 10226.28 O northeast 22412.65 O southwest 15820.7 O southwest 6186.127 O northeast 3645.089 O northeast 21344.85 3 southeast 30942.19 1 southwest 5003.853 1 northwest 17560.38 1 southwest 2331.519 2 northwest 3877 304 O southeast 2867.12 O southeast 47055.53 1 northwest 10825.25 2 southwest 11881.36 O southwest 4646.759 O northwest 2404.734 3 northeast 11488.32 O northeast 30260
58 male 29 female 49 female 37 female 44 male 18 male 20 female 44 male 47 female 26 female 19 female 52 female 32 female 38 male 59 female 61 female 53 female 19 male 20 female 22 female 19 male 22 male 54 female 22 female 34 male 26 male 34 male 29 male 30 male 29 female 46 male 51 female 53 female 19 male 35 male 48 male 32 female 42 female 40 female 44 male 48 male 18 male 30 male 50 female 42 female 18 female 54 male 49.06 27.94 27.17 23.37 37.1 23.75 28.975 31.35 33.915 28.785 28.3 37.4 17.765 34.7 26.505 22.04 35.9 25.555 28.785 28.05 34.1 25.175 31.9 36 22.42 32.49 25.3 29.735 28.69 38.83 30.495 37.73 37.43 28.4 24.13 29.7 37.145 23.37 25.46 39.52 24.42 25.175 35.53 27.83 26.6 36.85 39.6 O southeast 11381.33 1 southeast 19107.78 O southeast 8601.329 2 northwest 6686.431 2 southwest 7740.337 O northeast 1705.625 O northwest 2257.475 1 northeast 39556.49 3 northwest 10115.01 O northeast 3385.399 O southwest 17081.08 O southwest 9634,538 2 northwest 32734.19 2 southwest 6082.405 O northeast 12815.44 O northeast 13616.36 2 southwest 11163.57 O northwest 1632.564 O northeast 2457 211 O southeast 2155.682 O southwest 1261.442 O northwest 2045.685 3 southeast 27322.73 O southwest 2166.732 2 northeast 27375.9 1 northeast 3490.549 2 southeast 18972.5 2 northwest 18157 88 3 northwest 20745.99 3 southeast 5138.257 3 northwest 40720.55 1 southeast 9877.608 1 northwest 10959.69 1 southwest 1842.519 1 northwest 5125.216 O southeast 7789.635 3 northeast 6334.344 O northeast 19964.75 1 northeast 7077.189 O northwest 6943.701 O southeast 21223.68 O northeast 15518.18 O southeast 36950.26 3 southeast 19749.38 O northwest 21348.71 O southeast 36149.48 1 southwest 10450.55
32 female 37 male 47 male 20 female 32 female 19 female 27 male 63 male 49 male 18 male 35 female 24 female 63 female 38 male 54 male 46 female 41 female 58 male 18 female 22 male 44 female 44 male 36 male 26 female 30 female 41 female 29 female 61 male 36 female 25 male 56 female 18 male 19 male 39 female 45 female 51 female 64 female 19 female 48 female 60 female 27 female 46 male 28 female 59 male 35 male 63 female 40 male 29.8 29.64 28.215 37 33.155 31.825 18.905 41.47 30.3 15.96 348 33.345 37.7 27.835 29.2 28.9 33.155 28.595 38.28 19.95 26.41 30.69 41.895 29.92 309 322 3211 31.57 26.2 25.74 26.6 34.43 30.59 32.8 28.6 18.05 39.33 32.11 32.23 24.035 36.08 223 28.88 26.4 27.74 31.8 41.23 2 southwest 5152.134 O northwest S028.147 4 northeast 10407.09 S southwest 4830.63 3 northwest 6128.797 1 northwest 2719.28 3 northeast 4827.905 southeast 13405.39 O southwest 8116.68 northeast 1694,796 1 southwest S246.047 O northwest 2855.438 southwest 48824.45 2 northwest 6455.863 1 southwest 10436.1 2 southwest 8823.279 3 northeast 8538.288 O northwest 11735.88 O southeast 1631.821 3 northeast 4005.423 O northwest 7419.478 2 southeast 7731.427 3 northeast 43753.34 2 southeast 3981.977 3 southwest 5325.651 1 southwest 6775.961 2 northwest 4922.916 O southeast 12557.61 southwest 4883.866 O southeast 2137.654 1 northwest 12044.34 O southeast 1137.47 O northwest 1639.563 southwest 5649.715 2 southeast 8516.829 O northwest 9644.253 O northeast 14901 52 O northwest 2130.676 1 southeast 8871.152 O northwest 13012 21 O southeast 37133.9 southwest 7147.105 1 northeast 4337.735 O southeast 11743.3 2 northeast 20984.09 O southwest 13880.95 1 northeast 6610.11
20 male 40 male 24 male 34 female 45 female 41 female 53 female 27 male 26 female 24 female 34 female 53 female 32 male 19 male 42 male 55 male 28 male 58 female 41 female 47 male 42 female 59 female 19 female 59 male 39 male 40 female 18 female 31 male 19 male 44 male 23 female 33 female 55 female 40 male 63 female 54 male 60 female 24 male 19 male 29 male 18 male 63 female 54 male 27 male 50 male 55 female 56 male 33 30.875 28.5 26.73 30.9 37.1 26.6 23.1 29.92 23.21 33.7 33.25 30.8 34.8 24.64 33.88 38.06 41.91 31.635 25.46 36.195 27.83 17.8 27.5 24.51 22.22 26.73 38.39 29.07 38.06 36.67 22.135 26.8 35.3 27.74 30.02 38.06 35.86 20.9 28.975 17.29 32.2 34.21 30.3 31.825 25.365 33.63 1 southwest 1980.07 4 northwest 8162.716 2 northwest 3537.703 1 southeast 5002.783 2 southwest 8520.026 2 southwest 7371.772 O northwest 10355.64 O southeast 2483.736 1 southeast 3392.977 O southeast 25081.77 1 southwest 5012.471 O northeast 10564.88 3 southwest 5253.524 O southwest 34779.62 O southeast 19515.54 3 southeast 11987.17 O southeast 2689.495 O southeast 24227.34 1 northeast 7358.176 2 northeast 9225.256 1 northwest 7443.643 3 southeast 14001.29 O southwest 1727.785 1 southwest 12333.83 2 northwest 6710.192 2 southeast 19444.27 O southeast 1615.767 2 southeast 4463.205 O northwest 17352.68 1 southeast 7152.671 2 northeast 38511.63 1 northeast 5354.075 1 southwest 35160.13 3 southwest 7196.867 O northeast 29523.17 O northwest 24476.48 O southeast 12648.7 O southeast 1986.933 1 southwest 1832.094 1 northeast 4040.558 2 northeast 12829.46 2 southwest 47305 31 2 southeast 44260.75 3 southwest 4260.744 O northeast 41097.16 3 northeast 13047.33 O northwest 43921.18
38 female 51 male 19 male 58 female 20 female 52 male 19 male 53 female 46 male 40 male 59 female 45 male 49 male 18 male 50 male 41 male 50 male 25 male 40.15 24.415 31.92 25.2 26.84 24.32 36.955 38.06 42.35 19.8 32.395 30.2 25.84 29.37 34.2 37.05 27.455 27.55 O southeast 5400.981 4 northwest 11520.1 O northwest 33750.29 O southwest 11837.16 1 southeast 17085.27 3 northeast 24869.84 O northwest 36219.41 3 southeast 20463 3 southeast 46151.12 1 southeast 17179.52 3 northeast 14590.63 1 southwest 7441.053 1 northeast 9282.481 1 southeast 1719.436 2 southwest 42856.84 2 northwest 7265.703 1 northeast 9617.662 O northwest 2523.17
This data set contains information related to medical charges to insurances. age: age of primary beneficiary .bmi: Body
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
This data set contains information related to medical charges to insurances. age: age of primary beneficiary .bmi: Body
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!