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 with t-test interpretation
Go to Schoology to turn this in.
Submit one PDF. Put your first and last name in the document header. 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: Today's evidence supports a classroom claim about statistics lab analysis. It cannot prove causation, diagnose a real patient, or justify action outside this room.
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.