Submitted by: Submitted by manyi0525
Views: 363
Words: 2108
Pages: 9
Category: Science and Technology
Date Submitted: 09/22/2011 07:00 AM
BIO270 Lab 1: Statistics and Graphing Worksheet
Instructions: In Excel input data as seen here. Results and Figures will be pasted into this document which will printed out and turned in. Please try as hard as possible to minimize the number of pages by shrinking graphs, tables, etc.
Name: Sandy (Huiting) Zhang
Part I is to be done with your group during lab time. Make sure your lab instructor checks your answers before leaving the lab. Parts II, III, IV, and V are to be done INDIVIDUALLY for the lab report.
I. Finding Means and Standard Deviations using Excel:
Bill and Jill exercised for 7 days. Below is a measure of their heart rates (Beats/min) for each day before and after their exercise routine.
| |Bill (pre-exercise) |Jill (pre-exercise) |Bill (post-exercise) |Jill (post-exercise |
|Day 1 |73 |54 |95 |115 |
|Day 2 |65 |58 |98 |121 |
|Day 3 |63 |62 |101 |118 |
|Day 4 |72 |55 |90 |125 |
|Day 5 |69 |60 |92 |123 |
|Day 6 |71 |56 |100 |119 |
|Day 7 |70 |53 |97 |118 |
a. Find the...