The Open Door Web Site |
|||||||
|
ICT IN BIOLOGY USING EXCEL AS A DATA BASE CONTINUED DATABASE OF FEMALE REPRODUCTIVE HORMONES Exercise Start with the
complete database. Now click on the arrow in line E1 and select Custom
When the pop-up box appears, enter “is greater than or equal to” and “10”
12 records are filtered Now click on the arrow in column F1 and select Sort Descending
This allows you to compare the oestradiol levels (pg/ml) with high prolactin levels (≥ 10 ng/ml) during day 8 of the menstrual cycle from the 20 volunteers. Questions How many volunteers show progesterone levels greater than 1ng/ml on day 9 of menses? Which volunteer shows FSH levels over 10UI/L during 5 days. Are these days consecutive? Try first and then look at method on the next page |
© Paul Billiet and Shirley Burchill 2009 |
|||||