Biology

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...