This collection of workbooks has tools for: 1. Linear regression through the origin 2. Linear regression not through the origin 3. Polynomial fit 4. A simple chi-square analysis to test whether a data set is in Hardy-Weinberg Equilibrium; the user may enter his or her own data set or use one of the included sets. Tools 1-3 can be inserted into a toolbar into any Excel application that you build.

Source

Author(s):
Tony Weisstein, Truman State University
Rama Viswanathan, Beloit College
Sheldon Gordon, Framingham State College
Jennifer A Spangenberg, Beloit College

Pearson, K. 1956. Karl Pearson's Early Statistical Papers. Cambridge University Press.

Pearson, K. 1900. On the criterion that a given system of deviations from the probable in the case of a correlated system of variables is such that it can be reasonably supposed to have arisen from random sampling. Philosophical Magazine 50:157-175.

Popular Text Citations

Zar, J. H. 1998. Biostatistical Analysis, fourth edition. Prentice Hall.

Research Articles

Young, G. A.; Smith, R. L. 2006. Essentials of Statistical Inference by G.A. Young and R.L. Smith. Biometrics 62.

Kneib, T.; Fahrmeir, L. 2005. Structured Additive Regression for Categorical Space–Time Data: A Mixed Model Approach. Biometrics 62.

Schill, W. 2006. Categorical Data Analysis Using the SAS System by M.E. Stokes, C.S. Davis and G.G. Koch. Biometrics 62.

May, S. 2006. Advanced Excel® for Scientific Data Analysis by R. De Levie. Biometrics 62.

Kendziorski, C. M.; Chen, M.; Yuan, M.; Lan, H.; Attie, A. D. 2006. Statistical Methods for Expression Quantitative Trait Loci (eQTL) Mapping. Biometrics 62.

Chernoff H, Lehmann E.L. The use of maximum likelihood estimates in χ2 tests for goodness-of-fit. The Annals of Mathematical Statistics 1954; 25:579-586.

Liu, L. C.; Hedeker, D. 2005. Mixed-Effects Regression Model for Longitudinal Multivariate Ordinal Data. Biometrics 62.

Guan, Y. 2005. Tests for Independence between Marks and Points of a Marked Point Process. Biometrics 62.

Zhiying, P.; Lin, D. Y. 2005. Goodness-of-Fit Methods for Generalized Linear Mixed Models. Biometrics 61.

Weisstein Tony , Viswanathan Rama , Gordon Sheldon , Spangenberg Jennifer A () Biostatistical Tools. A module of the Biological ESTEEM Collection, published by the BioQUEST Curriculum Consortium. URL: http://bioquest.org/esteem/esteem_details.php?product_id=219