Search
Biological ESTEEM
Excel Simulations and Tools for Exploratory, Experiential Mathematics (ESTEEM) is a project of the members of the BioQuest Curriculum Consortium.
Birthday Problem & Class Phenotypic Probabilities
A Biological ESTEEM module in the Genetics Category. This Excel workbook as two related applications, the Birthday Problem and Class Phenotypic Probabilities.
Deme 2.0
A Biological ESTEEM module in the Genetics Category. This worksheet simulates the population genetics of a single gene with two alleles.
Linkage Analysis
A Biological ESTEEM module in the Genetics Category. This workbook simulates a linkage analysis problem with up to four alleles.
Operon
A Biological ESTEEM module in the Genetics Category. This workbook models lac operon function in a partial diploid E. coli.
ORF Finder
A Biological ESTEEM module in the Genetics Category. This workbook performs six-frame translation on a short user-input nucleotide sequence and highlights the position of stop codons.
Digital Classroom Resources
show printer friendly
send to a friend
ABO Blood Group Frequencies
From the Biological ESTEEM collection
ESTEEM Category
Genetics
Description
The purpose of this Excel workbook is to compare several methods for calculating allele frequencies for ABO blood groups. The methods used are the standard textbook approach, the quadratic formula, and the EM algorithm. The user enters the observed numbers of each phenotype. The workbook then uses these to calculate estimates of allele frequencies in Hardy-Weinberg equilibrium for each method. The user can view the formulas used to calculate frequencies through informational buttons. Four forms of graphical output are used to compare each method. Output includes histograms of chi-square values and observed vs. expected phenotype frequencies, as well as a ternary plot of the allele frequencies for each method. Users can also examine a dataset of blood group frequencies for different ethnic groups from Bloodbook.com.
Go to ABO Blood Group Frequencies module in a new window