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.
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, a difference this large would be unlikely if activity made no difference at all, so I treat the difference as real. Note what p does NOT say: it is not the probability that chance caused my result, and it says nothing about whether 25 bpm matters clinically.
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.
This model shows the level of evidence and organization needed to complete: Completes the Problem 2 statistics analysis: summary statistics per condition, a t-test result with interpretation, and reproducible step documentation.
- State the question and method.
- Present the observations and data with units.
- Explain the result, limitations, and next investigation.
Keep the structure. Replace the question, facts, measurements, and evidence. Then recheck units, vocabulary, and whether the conclusion goes beyond the evidence.
Also due today: Submit your completed statistical analysis spreadsheet on Schoology by end of period.
Turn in: Spreadsheet statistical analysis: summary statistics per condition, t-test result with interpretation, and reproducible step documentation.
Go to Schoology to turn this in.
Submit one PDF. Schoology attaches your name to your upload; on the page itself, write your period and code. Name the file: FirstName LastName - Assignment Title - YYYY-MM-DD.pdf.
Open Schoology PDF upload helpIf you cannot get in, see Mr. Mendoza. Do not skip the work.
Claim ceiling: D1 and M1 are invented arithmetic practice. Calculated significance under stipulated assumptions cannot establish any participant outcome, causal effect, clinical importance or official completion.
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.
It builds this reusable test skill: Interpreting a t-test p-value against the 0.05 cutoff.
- Name the concept or data pattern being tested.
- Cross out choices that violate that rule or the evidence.
- Justify the best remaining choice before checking the answer.

