Basic Statistics Assignment Solution 1.Analyze the data set. For this part, if you are male, use the male variable; if you are female, use the female variable. Using Microsoft Excel, complete the following: 1. Determine the measures of centre for the data (mean, median, and mode). The mean, mode and median for the given variables are given as below: MALE Mean Median Mode 10078.5 7191 #N/A MAL E DIAS 73.22 5 75 81 Mean Median Mode 2. AGE HT WT WAIST PULSE 35.475 32.5 20 68.33 5 68.3 68.3 172.55 169.95 #N/A 91.28 5 91.2 87.7 69.4 66 64 CHOL BMI LEG ELBO W 395.225 282.5 265 25.997 5 26.2 23.8 42.572 5 42.65 40.2 7.295 7.3 7.5 WRIS T 5.8 5.8 6 SYS 118.9 117 125 ARM 32.387 5 32.05 31.9 Determine measures of variation (range, standard deviation, and variance). The measures of variation for the given variables are given as below: MALE Variance Standard Deviation DIAS CHOL HT WT WAIST PULSE SYS 30839 56744511.64 10 Range AGE 56 193.948 1 117.6 693.119 5 33.5 97.256 2 40 127.630 8 58 109.476 9 7532.8953 13.9265 14.9 9.117 7 3.019 6 26.3272 9.8619 11.2974 10.4631 ELBO W WRIS T ARM BMI LEG 43 83.409 6 1221 85504.64 04 13.6 11.770 0 9.1329 292.4118 3.4307 3. 12.4 8.454 9 2.907 7 1.8 0.204 1 0.451 7 1.5 0.125 6 0.354 5 15.2 9.087 8 3.014 6 Determine the quartiles and the IQR (Inner Quartile Range). The inter quartile ranges for the given variables are given as below: Minimum First Quartile Median Third Quartile Maximum IQR 4. MALE 1391 3607 7191 16768 32230 13161 AGE 17 25 32.5 46 73 21 HT 61.3 66.3 68.3 70.3 76.2 4 WT 119.5 151.8 169.95 191.1 237.1 39.3 WAIST 75.2 82.5 91.2 102.9 108.7 20.4 PULSE 56 60 66 76 96 16 SYS 95 110 117 125 153 15 DIAS 44 66 75 81 87 15 Explain the method of determining outliers in the data and list any outliers. We can determine the outliers in the data by plotting the box plot. If there are outliers exists in the given data for the given variables, then we can easily determine the outliers in the data. 5. Create the modified box plot of the data showing any outliers. (You may need to draw this using MS Word tools.) Make sure that your box plot has a proper scale. The box plots for the different variables are given as below: 6. Using Excel, group the data into 6 to 10 groups and create a histogram for the data. (Excel uses bins to group the data. See the attached worksheet for instructions on how to create histograms using Excel.) The histograms for the given variables are given as below