Read the following scenario and plot a graph based on the data provided:

Observation:

You noticed there are some physical differences between males and females.

Question:

Are there any physiological differences between males and females, too?

Hypothesis:

Hormones affect how human bodies grow, and the types and ratios of hormones produced in males and females are different. Therefore, they should show some physiological differences, too.

Experiment:

Student A asked her classmates to participate in the experiment and they all agree to do so.
There are 11 female students and 8 male students in this class.
Jumping jacks was selected for the exercise, and Student A demonstrated how to do Jumping Jacks.
To promote consistency and coordination, all students were instructed to perform Jumping Jacks at the same pace and with uniform intervals. This was accomplished by having them follow the lead of a designated student, Student A.
After a few practices, everyone took 10 minutes break.
After the break, they all counted the heartbeats, converted it to "heartbeats per minute (bpm)," and recorded the result as "Heart Rate (bpm) before Exercise."
After recording the data, all students did Jumping Jacks for 1 minute.
Right after the exercise, they calculated their "heartbeats per minute (bpm)" and recorded the result as "Heart Rate (bpm) after Exercise."
Student A collected all data and recorded the data in the table below.
Heartrate (bpm)
Sex Before Exercise After Exercise
Female 108 150
Female 84 108
Female 60 120
Male 78 126
Male 90 126
Male 84 168
Female 78 132
Female 74 102
Male 78 126
Female 78 120
Male 66 138
Female 108 168
Male 72 126
Female 102 180
Male 66 120
Female 81 124
Female 96 192
Female 84 132
Male 72 108


With Excel (or any spreadsheet software/App), plot the collected data on a graph that illustrates the "difference in the average change of heart rate due to exercise between males and females.".

Here is the direction:

Use the data provided above.
Note) You need to do some calculations first. See the instructions under "the dependent variable is ..." described below.
Decide which type of graph you should use (bar graph or scatter graph with smooth line).
Make a graph
The independent variable is the gender
The dependent variable is the average heart rate changes before and after an exercise
The data in the columns provided above show the "gender," the "heart rate before an exercise," and the "heart rate after an exercise." So, you need to calculate the change for each individual first.
After you obtain a change for each individual, calculate the average of the changes; one for males and the other one for female
Enter the calculated data into Excel (or any spreadsheet software). If you forgot how to enter data, review what you learned in Week 1 or visit Information Technology Lab to seek help.
If you would like me to check whether you enter your data correctly or not, contact me during the Student-Support Hours via MS Teams (chat) or visit me at my office during Student-Support Hours. Then, I can provide feedback.
Be sure to include the following in the table
Appropriate title of this bar graph
Appropriate x-axis title and y-axis title
Appropriate units if needed
Appropriate legends if needed
Once you made a graph, copy and paste the graph into a Word document