Exercise, Target Heart Rates, and Excel

Now that you know how to find your pulse and you know your target heart rate zone, let's see how close your pulse is to your THR zone after one minute of exercise.

Step 1: Find your resting heart rate and record on a sheet of paper. (Note: This is your heart rate at time = 0.)

Step 2: Perform jumping jacks for one minute. Take your pulse again. (Note: This is your heart rate at time = 1.)

Step 3: Open Microsoft Excel.

Step 4: Enter your data as shown below.

Step 5: Click on cell A-1 and drag the mouse to cell B-3.

Step 6: Now we are ready to graph. Click on the chart wizard icon.

Step 7: In the window that appears, we are going to plot the points. Click XY-Scatter and hit Next.

Step 8: In the Data Range tab, choose Series in: Columns. Click Next.

Step 9: Click the Titles tab, and input:

Step 10: Click on the Data Labels tab and select Show Value. Click Finish.

Sample graph:

We have now plotted the points for our graph. Now, it's time to draw a line through the two points.

Step 11: Right-click on one of the data points. Choose Add Trendline...

Step 12: In the window that appears, choose Linear and hit OK. Your graph is now complete.

Questions to Answer

1. Was your exercise heart rate in your target heart rate zone? If not, what does this mean?

2. Do you think athletes take longer to reach their target heart rates compared to a regular person? Why or why not?

Back