Cystic Fibrosis

Back to Excel Models

What does this Model Represent?

This model is a study of dominant and recessive genes. Some diseases, like Cystic Fibrosis, are carried in a recessive gene. Only when both parents have the recessive gene can the disease be passed on. If one or both of them have the dominant gene, the disease will not be passed on.

What are the elements of this Model?

This model simulates a random sampling of eight couples. Each couple is represented by a row, where one parent is in column A, and the other is in column B. The verdict determining whether it is safe for them to have more kids is in column C.

How do I use this Model?

This model is very simple. Push [Ctrl] [=] every time you want to get a new random sample of couples. There are no places to input new values.

What should I expect?

If parent A and parent B both have the recessive gene, then column C will say “Stop.” Otherwise, column C will say “More Kids.” Try several rounds and watch for patterns. What is the probability that a couple will need to stop having kids?

Download the model file.