Discussion/Lab Report (Work on this in class) ** Paste the Graphs and Tables into the Word/Google Document ** Submit your Excel Sheet. 1. Submit the signed PAR-Q or E-medx form - You will turn this in class. 2. Convert the following variables into metric units. Show your work. Make sure to round up using significant figures. Don’t round until you get your final answer. a. 6.20 mph to m/min b. 3.5 mph to m/s c. 250 kg/m/min to Watts d. 72.5 Inches to cm e. 3.5 LO 2 to kcal f. 178 lb to kg 3. Throughout the semester, you will be using excel. One way excel can help you is by doing calculations for you. This can save you a lot of time. There are many different formulas that are premade but you can also create your own. Below is a set of data. Do the following calculations in excel. a. Find the average of weight for all the subjects.

b. Find the standard deviation of the heart rates for all subjects. c. Fill in the column for the VO2 max of each individual using the following formula. i. VO2 max = 132.853 - (0.0769*your weight in pounds) - (0.3877*your age) + (6.315*Sex (1 = male or 0 = female) - (3.2649*your walking time) - (0.1565*your heart rate at the end of the test) Subject Age (yrs) Sex Weight (lbs) Walking Time (minutes) H (b 1 21 1 145 18.5 2 18 0 115 17.4 3 19 1 180 15.4 4 23 1 200 20 5 22 0 130 16.7 6 19 0 155 16 7 21 1 176 15 8 25 0 166 17 9 20 1 176 14.4 10 19 0 120 14 Subjec t Age (yrs) Sex Weigh t (lbs) Walkin g Time (minut es) Heart Rate (bpm ) VO (m n) 1 21 1 145 18.5 130 2 18 0 115 17.4 125 3 19 1 180 15.4 150 4 23 1 200 20 140 5 22 0 130 16.7 125 6 19 0 155 16 120 7 21 1 176 15 140 8 25 0 166 17 135 9 20 1 176 14.4 140 10 19 0 120 14 133

6 1 51 5. Create a line graph using the following data. a. Workload should be on the X-axis and Heart Rate should be on the Y- axis. b. Label the Y and X axis with appropriate names and units. c. Include a line that connects each data point. d. Make each data point a round dot that is easy to see. Workloa d (Watts) Heart Rate (bpm) 50 110 100 132 125 144 150 165 175 178 200 198 50 100 125 150 175 200 0 50 100 150 200 250 Heart Rate (bpm) Workload (Watts) Heart Rate (bpm) 6. Create a Scatterplot using the following data.

a. Put BMI on the X-axis and Body fat % on the Y-axis. b. Make sure to include a trendline or line of best fit in your graph. c. Include the R 2 value. d. Label the Y and X-axis with the appropriate names and units. e. (Hint: Do not select the subject column data when making the graph.) Subject Body Fat % BMI (kg/m2) 1 23 21 2 45 32 3 6 26 4 19 22 5 34 28 6 21 25 7 15 21 0 5 10 15 20 25 30 35 40 45 50 0 5 10 15 20 25 30 35 R² = 0.47 BMI (kg/m2) Body Fat %