Statistics lab analysis
Fri, Mar 12, 2027 · Week 8 · Biotechnology for Health (Biomedical Innovations)
Today's goal: Analyze your physiology dataset using descriptive statistics and a comparison test.
What a finished product looks like
This is a model of the work you should turn in today. Use it to check your own: match the structure and the level of detail, do not copy it. Your data and wording should be your own.
Research question: Is the after-activity heart rate significantly higher than resting?
Summary statistics (from my spreadsheet):
- Rest: mean 72.0 bpm, SD 1.6, n = 5
- Activity: mean 97.6 bpm, SD 2.7, n = 5
Comparison test: two-sample t-test on rest vs activity means.
Result: t was large and the p-value was about 0.0001, well below 0.05.
Interpretation: Because p is less than 0.05, the difference is statistically meaningful: the after-activity mean is higher by an amount unlikely to be due to chance.
Reproducible steps (so a classmate could repeat it):
1. Enter the five rest and five activity readings in two columns.
2. Use AVERAGE and STDEV on each column.
3. Use the T.TEST function (two-tailed, two-sample) on the two columns.
4. Compare the returned p-value to 0.05.
Also due today: Submit your completed statistical analysis spreadsheet to the Schoology lab assignment by end of period.
WebXam problem for today's skill
One exam-style question that uses exactly what you practiced today. Try it before you reveal the answer, then read why each choice is right or wrong.
Tap an answer to see the full explanation. Nothing is recorded or graded.