The Open Door Web Site

Biology
 

 

ICT IN BIOLOGY

USING EXCEL AS A DATA BASE CONTINUED

DATABASE OF FEMALE REPRODUCTIVE HORMONES

Exercise

Start with the complete database.
Filter day 8 from B1

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

> ICT in Biology

ICT in Biology Index

© The Open Door Team
Any questions or problems regarding this site should be addressed to the webmaster

© Paul Billiet and Shirley Burchill 2009