Using Excel and the data previously collected compute the cross sectional area of the thigh muscles (CSAT) and the cross-sectional area of the upper arm muscles (CSAA). CSAT (cm2) = (4.68 * thigh cirumference) (2.09 * thigh skinfold) 80.99 – – CSAA (cm2) = 0.785 * [(arm circumference/3.14)-(tricep skinfold/10)]2 Where circumferences are in cm and skinfolds are in mm. Create a variable called arm 1 RM by averaging the values for the arm curl 1 RM and the arm extension 1 RM and then dividing by 2 (since we are just using the size of one arm we have to just use the strength of one arm). Create a second variable called arm reps by averaging the arm curl reps and the arm extension reps. Using Excel, determine the average for males and the average for females for each of the following variables: leg press 1RM, leg press reps, arm 1 RM, arm reps, Peak Watts, CSAT, CSAA Using Excel, compute correlations (CORREL) between each of the following variables for males and females separately: CSAT and Leg Press 1RM; CSAT and Leg Press Reps., CSAT and Peak Watts CSAA and arm 1 RM; CSAA and Arm Reps. Leg Press 1 RM and Leg Press Reps Arm 1 RM and Arm Reps Last Name(s): Lab Section: Fill in the charts below with the appropriate means and correlation coefficients. Varialbles Means Means Females Males CSAT CSAT Peak Watts Arm 1RM
Using Excel and the data previously collected compute the cross sectional area of the thigh muscles (CSAT) and the cross-sectional area of the upper arm muscles (CSAA). CSAT (cm2) = (4.68 * thigh cirumference) – (2.09 * thigh skinfold) – 80.99 CSAA (cm2) = 0.785 * [(arm circumference/3.14)-(tricep skinfold/10)]2 Where circumferences are in cm and skinfolds are in mm. Create a variable called arm 1 RM by averaging the values for the arm curl 1 RM and the arm extension 1 RM and then dividing by 2 (since we are just using the size of one arm we have to just use the strength of one arm). Create a second variable called arm reps by averaging the arm curl reps and the arm extension reps. Using Excel, determine the average for males and the average for females for each of the following variables: leg press 1RM, leg press reps, arm 1 RM, arm reps, Peak Watts, CSAT, CSAA Using Excel, compute correlations (CORREL) between each of the following variables for males and females separately: CSAT and Leg Press 1RM; CSAT and Leg Press Reps., CSAT and Peak Watts CSAA and arm 1 RM; CSAA and Arm Reps. Leg Press 1 RM and Leg Press Reps Arm 1 RM and Arm Reps Last Name(s): Lab Section: Fill in the charts below with the appropriate means and correlation coefficients. Varialbles Means Females Means Males CSAT CSAT Peak Watts Arm 1RM