Assignment: Tables & Graphs in Excel

You want to determine if doing Jumping jacks dally will lower resting heart rate. You have eight participants in your study. Four of them are randomly selected to do $25$ Jumping jacks every day for a month. The other four do not do jumping jacks at all. These are your results:

Resting Heart Rate $($Doing Jumping Jacks$)-60bpm,80bpm$;$74bpm,70bpm$

Resting Heart Rate $($Not doing Jumping Jacks$)-100bpm,80bpm,90bpm,88bpm$

Variables

Identify the experimental variables below:

a$.$ Independent variable $=$

b$.$ Dependent variable $=$

Data

$2.$ Use Excel to calculate the median, mean, and standard deviation for each condition. Write the values in the table below.

$\backslash$table$[[,$Median,Mean,Standard Deviation$],[$Doing Jumping Jacks,E$,,],[$Not Doing Jumping Jacks,F$,,]]$

Tables

$3.$ Make a table in Excel representing the data. Your table should show each replicate and the averages. Copy your table to the space below.

Graphs

$4.$ Make a graph in Excel representing only the average data. Your graph must include error bars. Copy your graph to the space below.