Skip to main content
Log in

Mendel: a simple excel workbook to compare the observed and expected distributions of genotypes/phenotypes in transgenic and knockout mouse crosses involving up to three unlinked loci by means of a χ2 test

  • Technical Report
  • Published:
Transgenic Research Aims and scope Submit manuscript

Abstract

The analysis of transgenic and knockout mice always involves the establishment of matings with individuals carrying different loci, segregating independently, whose presence is expected among the progeny, according to a Mendelian distribution. The appearance of distorted inheritance ratios suggests the existence of unexpected lethal or sub-lethal phenotypes associated with some genotypes. These situations are common in a number of cases, including: testing transgenic founder mice for germ-line transmission of their transgenes; setting up heterozygous crosses to obtain homozygous individuals, both for transgenic and knockout mice; establishing matings between floxed mouse lines and suitable cre transgenic mouse lines, etc. The Pearson’s χ2 test can be used to assess the significance of the observed frequencies of genotypes/phenotypes in relation to the expected values, in order to determine whether the observed cases fit the expected distribution. Here, I describe a simple Excel workbook to compare the observed and expected distributions of genotypes/phenotypes in transgenic and knockout mouse crosses involving up to three unlinked loci by means of a χ2 test. The file is freely available for download from my laboratory’s web page at: http://www.cnb.csic.es/~montoliu/Mendel.xls.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Fig. 1

References

  • Cochran WG (1954) Some methods for strengthening the common [chi-squared] tests. Biometrics 10:417–451

    Article  Google Scholar 

  • Dickson MC, Martin JS, Cousins FM, Kulkarni AB, Karlsson S, Akhurst RJ (1995) Defective haematopoiesis and vasculogenesis in transforming growth factor-beta 1 knock out mice. Development 121:1845–1854

    PubMed  CAS  Google Scholar 

  • Iwanaga A, Wang G, Gantulga D, Sato T, Baljinnyam T, Shimizu K, Takumi K, Hayashi M, Akashi T, Fuse H, Sugihara K, Asano M, Yoshioka K (2008) Ablation of the scaffold protein JLP causes reduced fertility in male mice. Transgenic Res 17:1045–1058

    Article  PubMed  CAS  Google Scholar 

  • Langa F, Codony X, Tovar V, Lavado A, Giménez E, Cozar P, Cantero M, Dordal A, Hernández E, Pérez R, Monroy X, Zamanillo D, Guitart X, Montoliu L (2003) Generation and phenotypic analysis of sigma receptor type I (sigma 1) knockout mice. Eur J Neurosci 18:2188–2196

    Article  PubMed  Google Scholar 

  • Montagutelli X (1990) GENE-LINK: a program in PASCAL for backcross genetic analysis. J Hered 81:490–491

    PubMed  CAS  Google Scholar 

  • Montoliu L, Umland T, Schütz G (1996) A locus control region at −12 kb of the tyrosinase gene. EMBO J 15:6026–6034

    PubMed  CAS  Google Scholar 

  • Moreira PN, Pozueta J, Pérez-Crespo M, Valdivieso F, Gutiérrez-Adán A, Montoliu L (2007) Improving the generation of genomic-type transgenic mice by ICSI. Transgenic Res 16(2):163–168

    Google Scholar 

  • Rijkers T, Peetz A, Rüther U (1994) Insertional mutagenesis in transgenic mice. Transgenic Res 3:203–215

    Article  PubMed  CAS  Google Scholar 

  • Suiter KA, Wendel JF, Case JS (1983) LINKAGE-1: a PASCAL computer program for the detection and analysis of genetic linkage. J Hered 74:203–204

    PubMed  CAS  Google Scholar 

  • Thomas AD, Murray JD, Oberbauer AM (2005) Transgene transmission to progeny by oMt1a-oGH transgenic mice. Transgenic Res 14:441–448

    Article  PubMed  CAS  Google Scholar 

  • Whitelaw CB, Springbett AJ, Webster J, Clark J (1993) The majority of G0 transgenic mice are derived from mosaic embryos. Transgenic Res 2(1):29–32

    Google Scholar 

  • Yates D, Moore D, McCabe G (1999) The practice of statistics. W.H. Freeman, New York

    Google Scholar 

Download references

Acknowledgments

The author thanks Thomas J. Fielder for critically reviewing this manuscript, and Laura Barrios and Carlos O. Sanchez-Sorzano for professional advice on statistics. This work was supported by MEC funds BIO2003-08196 and BFU2006-12185 and MICINN project BIO2009-1297 to LM.

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Lluís Montoliu.

Rights and permissions

Reprints and permissions

About this article

Cite this article

Montoliu, L. Mendel: a simple excel workbook to compare the observed and expected distributions of genotypes/phenotypes in transgenic and knockout mouse crosses involving up to three unlinked loci by means of a χ2 test. Transgenic Res 21, 677–681 (2012). https://doi.org/10.1007/s11248-011-9544-4

Download citation

  • Received:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s11248-011-9544-4

Keywords

Navigation