Need help with school project on excel. (Hardy-weinberg problem)

**auditiya** · 03-24-2014, 01:54 PM

Hi, attached is a school project that I need help on. I need the columns T-Z fluctuate in length according to the total population in row O. Also the population in the next generation needs to change according to the people alive and dead due to the disease (The disease is homozygous recessive so all "BB"s die). All of the subsequent generations after must fluctuate as well like mentioned in the second sentence.
Can you PLEASE HELP?!?!?! I will answer any questions about the attached doc because I realize that my question isn't in depth enough.

Hardy-Weinberg Problem.xlsx

**Bernie Deitrick** · 03-24-2014, 03:01 PM

There is no "Row O" - there is a column O, but you don't have any values in it, just two labels.

When does a BB die? That is, do BBs reproduce or are they simply removed from the gene pool? How many offspring does each member have - do earlier generations continue to reproduce or not?

If may be as simple as changing this

=IF(RAND()<=P$1,"A","B")

to this

=IF(ROW(A1)<=Population of reproducers, IF(RAND()<=P$1,"A","B"), "")

and then copying down beyond what you actually expect.

Need help with school project on excel. (Hardy-weinberg problem)

LinkBack

Thread Tools

Rate This Thread

Display

Need help with school project on excel. (Hardy-weinberg problem)

Re: Need help with school project on excel. (Hardy-weinberg problem)

Thread Information

Users Browsing this Thread

Similar Threads

Need your help: Excel file needs to be sorted for a school project.

[SOLVED] Mathematical modeling hardy weinberg equilibrium in Excel!

O/T: Help with B-school project

school project ..please help

school project ..please help

Bookmarks

Bookmarks

Posting Permissions