Optimize Lab Report: Excel Calculations & Graphs

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