In: Statistics and Probability
11. Brian was bitten during the last attack on the compound. He was rushed to the field hospital where his vitals were measured immediately and every 30 minutes thereafter. Create a scatter graph (with line) in MS Excel of the following data. Determine which of the variables is independent (for the X axis) and which is dependent (Y axis). Copy & paste the excel graph below. (10 pts)
Patient heart rate (BPM) after infection.
Time (minutes) |
Heart Rate (beats per minute) |
0 |
73 |
30 |
78 |
60 |
89 |
90 |
92 |
120 |
95 |
150 |
110 |
180 |
130 |
210 |
155 |
240 |
180 |
270 |
0 |
The data provided is:
Time(minutes) | Heart Rate (beats per minute) |
0 | 73 |
30 | 78 |
60 | 89 |
90 | 92 |
120 | 95 |
150 | 110 |
180 | 130 |
210 | 155 |
240 | 180 |
270 | 0 |
The independent variable is Time (X-axis)
The dependent variable is Heart Rate (Y-axis)
Just go to insert -> Scatter to create the required plot:
If satisfied, please
do upvote! Let me know in the comments if anything is unclear. I
will reply ASAP