The follicle ruptures about 36 hours after the LH peak.
Sample the database and plot the levels of LH against time.
Inspect the graphs and determine the lowest concentration that LH rises to in the peaks.
Select LH, Number Filters, "greater or equal to" and enter your figure. Press Enter.
You should now have a list of the volunteers whose level of LH went above your selected value.
If you have two or more values from the same volunteer you will need to raise the value that you are using.
You will probably find that some of the volunteers are missing after filtering. Why should this be? It might be worth looking at them.
The peaks for LH will occur on a particular day in the menstrual cycle. Ovulation occurs 36h later.
Cut the Days from mensis data and paste it under the data base.
Add 1.5 to the days column to determine the point of ovulation.
Establish the mean and standard deviation for the day of ovulation for this set of volunteers.
Establish the mean and standard deviation for the day
of ovulation for this set of volunteers.
MS Excel: Using it as a Calculator: Creating your own Functions
MS Excel: Using it as a Calculator: Using Preset Functions
The rhythm method is a method of contraception which relies on calculating the "safe period". This is the period when there is no viable
oocyte in the fallopian tube. Oocytes are receptive to sperms for about 24h after ovulation and then die after 3 days. Authorities vary in their estimations of how
long sperm cells remain viable in the uterus. Figures for sperm viability vary from as little as 1 day to as long as 7 days inside the woman after ejaculation.
From the evidence from this data base evaluate this method of contraception.
There are a number of interactions between hormones in the cycle:
Negative feedback controls FSH levels after they stimulate oestradiol secretion.
There is a positive feedback between LH levels and oestradiol levels
Testosterone is a precursor of oestradiol (testosterone is made by cells in the ovary then converted to oestradiol).
Prolactin is a hormone that milk secreting which inhibits progesterone secretion.
Chose one of these interactions and sample the data base to see what evidence there is for them
If one hormone stimulates another there should be a positive correlation between their levels.
To create a random sample you may use
Random Integer Generator