Graphing
and Discussion
This lab activity has a value of 15 points. Please complete
for full credit.
1. (5 pts) Excel Graphing – Your Instructor will let you know which hormone data to graph. Title 1 pt, Correct Y axis and legend 3 pts, Correct X axis and legend 3 pts. See Data on Page 2 of handout.
2. (4 pts) Your Lab Instructor will assign one of the following topics. Links to the topics are available under “Lab Assignments”. You can also use your Textbook and other Internet Sources.
3. (6 pts) Formulate 6 essay questions for Exam 3 Chapters 15-21 and email questions and answers to your Lab Instructor.
Excel Graphing Data: The following data was collected and analyzed during this lab experience. Please check with Lab Instructor as to which Hormone you are to graph.
Concentrations of Hormones
|
||||
|
|
FSH |
Estrogen |
LH |
Progesterone |
|
1 |
9 |
30 |
9 |
0.6 |
|
2 |
11 |
40 |
12 |
0.8 |
|
3 |
13 |
50 |
16 |
1.0 |
|
4 |
14 |
70 |
18 |
1.0 |
|
5 |
15 |
80 |
19 |
1.0 |
|
6 |
14 |
100 |
16 |
1.0 |
|
7 |
14 |
130 |
12 |
1.2 |
|
8 |
15 |
140 |
19 |
1.2 |
|
9 |
13 |
180 |
15 |
1.3 |
|
10 |
11 |
200 |
16 |
1.5 |
|
11 |
9 |
220 |
20 |
1.5 |
|
12 |
18 |
230 |
30 |
1.6 |
|
13 |
13 |
220 |
75 |
1.8 |
|
|
9 |
200 |
58 |
2.0 |
|
15 |
9 |
180 |
30 |
2.3 |
|
16 |
8 |
150 |
14 |
3.7 |
|
17 |
8 |
120 |
10 |
5.8 |
|
18 |
8 |
100 |
9 |
8.3 |
|
19 |
8 |
50 |
7 |
10.4 |
|
20 |
7 |
30 |
5 |
12.0 |
|
21 |
7 |
25 |
3 |
12.0 |
|
22 |
6 |
25 |
3 |
11.8 |
|
23 |
5 |
25 |
2 |
10.3 |
|
24 |
5 |
25 |
3 |
7.2 |
|
25 |
6 |
20 |
3 |
4.0 |
|
26 |
7 |
20 |
4 |
3.0 |
|
27 |
7 |
25 |
5 |
1.5 |
|
28 |
8 |
25 |
7 |
0.8 |
Source: www.askthegnomes.com/files/12_-_Menstrual_Cycle_Graphing_Lab.doc