id 64.471 exerciseProgray sex 1 Metabolic F 2 Metabolic M 3 Metabolic F 4 Muscle Matters F 5 Metabolic F 6 Muscle Matters F 7 7 Metabolic F 8 Metabolic F 9 Metabolic M 10 Muscle Matters M 11 Bone Health F 12 Metabolic F 13 Bone Health F 14 Metabolic F F 15 Metabolic M 16 Metabolic M 17 Resiliency M 18 Muscle Matters F 19 Muscle Matters M 20 Muscle Matters F height_1 weight_1 fatMass_1 fatFreeMargripStrengtgripStrength_leftAve_1 height_2 weight_2 fatMass_2 fatFreeMargripStrength_rightA gripStrength_leftAvr_2 160.4 87.76 38.598 49.162 29.33 31 160.4 85.494 36.43 49.064 32 32 172.72 87.067 23.895 63.172 35.33 43.67 172.72 86.91 26.785 60.126 34 31 179.07 76.731 29.252 47.479 16.33 20 179.07 78.165 27.509 50.656 19.33 18.33 168.5 54.102 13.417 40.685 18.33 16.5 168.5 53.353 15.267 38.086 23.67 19.33 158 67.577 30.544 37.033 14.67 11.33 158 66.972 31.21 35.762 13 13 159 59.02 22.207 36.813 20.33 17.67 159 58.466 22.892 35.574 18.83 14.5 156 55.09 20.242 34.849 16.67 14.67 154.9 56.215 21.5BS 34.513 21 16 157 66.768 29.882 36.886 16.33 19.67 157 28.886 35.585 21.3 21.3 183.5 94.173 25.856 68.317 31.33 36.33 182.88 95.67 24.53 71.18 46.33 40.67 173 81.959 31.099 50.859 25.33 27 172.7 78.812 25.936 52.876 22.5 24.83 159 59.472 23.98 35.492 20.33 19 159 59.834 22.797 37.037 20.33 19.66 165.5 74.465 36.235 38.23 16.67 16.33 165.5 76.15 33.372 42.779 18 18.66 149.7 55.436 21,871 33.565 19 18 149.7 54.85 19.58 35,27 21.66 19.66 164.5 74.688 29.539 45.149 24 21.33 164.5 75.963 30.422 45.541 25 23.66 181 105.794 41,257 64.537 48.33 41.33 181 106,882 43.501 63.381 51 43.33 173.5 81.849 31.071 50.777 23.67 26.44 173.5 77.811 30.584 47.227 26.33 28.33 175.3 100,742 32.993 67.75 41.83 38.67 175 99,543 32,764 66.779 49.7 44.5 156.6 63.908 32.092 31.816 20.67 18.5 156.6 63.346 29.357 33.989 16.66 11 186 103.479 40.385 63.094 39.33 35.33 182.7 99.978 41.301 58.677 36.33 36.33 159.4 77.945 35.3 42.644 18.5 15.67 159.4 79.11 40.585 38.524 19.66 13.66 Hacker Assignment #2: Real Exercise Science Data! Due next Thursday by 11:59m. Please upload it to BB. (Using the 6035_ENHI_subset.xlsx spreadsheet): 1. In Word, create a table of each mean and sd for all appropriate numeric variables. Give the table a title and label your rows and columns. A screenshot of Rstudio console output is NOT ok. 2. Create a table of counts/frequencies for all the character data. A screenshot of the console is fine. 3. Recode "sex" as O=Male, 1=Female 4. Recode the exercise programs as 1, 2, 3, 4 5. Rerun the frequencies of those recoded variables. Screenshot the console output of the frequencies. 6. Put all info/screenshots in labeled Word document (your name, your section (number and day) assignment name. id 64.471 exerciseProgray sex 1 Metabolic F 2 Metabolic M 3 Metabolic F 4 Muscle Matters F 5 Metabolic F 6 Muscle Matters F 7 7 Metabolic F 8 Metabolic F 9 Metabolic M 10 Muscle Matters M 11 Bone Health F 12 Metabolic F 13 Bone Health F 14 Metabolic F F 15 Metabolic M 16 Metabolic M 17 Resiliency M 18 Muscle Matters F 19 Muscle Matters M 20 Muscle Matters F height_1 weight_1 fatMass_1 fatFreeMargripStrengtgripStrength_leftAve_1 height_2 weight_2 fatMass_2 fatFreeMargripStrength_rightA gripStrength_leftAvr_2 160.4 87.76 38.598 49.162 29.33 31 160.4 85.494 36.43 49.064 32 32 172.72 87.067 23.895 63.172 35.33 43.67 172.72 86.91 26.785 60.126 34 31 179.07 76.731 29.252 47.479 16.33 20 179.07 78.165 27.509 50.656 19.33 18.33 168.5 54.102 13.417 40.685 18.33 16.5 168.5 53.353 15.267 38.086 23.67 19.33 158 67.577 30.544 37.033 14.67 11.33 158 66.972 31.21 35.762 13 13 159 59.02 22.207 36.813 20.33 17.67 159 58.466 22.892 35.574 18.83 14.5 156 55.09 20.242 34.849 16.67 14.67 154.9 56.215 21.5BS 34.513 21 16 157 66.768 29.882 36.886 16.33 19.67 157 28.886 35.585 21.3 21.3 183.5 94.173 25.856 68.317 31.33 36.33 182.88 95.67 24.53 71.18 46.33 40.67 173 81.959 31.099 50.859 25.33 27 172.7 78.812 25.936 52.876 22.5 24.83 159 59.472 23.98 35.492 20.33 19 159 59.834 22.797 37.037 20.33 19.66 165.5 74.465 36.235 38.23 16.67 16.33 165.5 76.15 33.372 42.779 18 18.66 149.7 55.436 21,871 33.565 19 18 149.7 54.85 19.58 35,27 21.66 19.66 164.5 74.688 29.539 45.149 24 21.33 164.5 75.963 30.422 45.541 25 23.66 181 105.794 41,257 64.537 48.33 41.33 181 106,882 43.501 63.381 51 43.33 173.5 81.849 31.071 50.777 23.67 26.44 173.5 77.811 30.584 47.227 26.33 28.33 175.3 100,742 32.993 67.75 41.83 38.67 175 99,543 32,764 66.779 49.7 44.5 156.6 63.908 32.092 31.816 20.67 18.5 156.6 63.346 29.357 33.989 16.66 11 186 103.479 40.385 63.094 39.33 35.33 182.7 99.978 41.301 58.677 36.33 36.33 159.4 77.945 35.3 42.644 18.5 15.67 159.4 79.11 40.585 38.524 19.66 13.66 Hacker Assignment #2: Real Exercise Science Data! Due next Thursday by 11:59m. Please upload it to BB. (Using the 6035_ENHI_subset.xlsx spreadsheet): 1. In Word, create a table of each mean and sd for all appropriate numeric variables. Give the table a title and label your rows and columns. A screenshot of Rstudio console output is NOT ok. 2. Create a table of counts/frequencies for all the character data. A screenshot of the console is fine. 3. Recode "sex" as O=Male, 1=Female 4. Recode the exercise programs as 1, 2, 3, 4 5. Rerun the frequencies of those recoded variables. Screenshot the console output of the frequencies. 6. Put all info/screenshots in labeled Word document (your name, your section (number and day) assignment name