Abdi, H. (2009). The Greenhouse-Geisser correction. In Neil Salkind (Ed.), Encyclopedia of research design. Sage. Thousand Oaks, CA.

Abdi, H. (2010) Coefficient of variation. Encyclopedia of Research Design. Sage. Thousand Oaks, CA

Abdi, H. & Molin, P. (2007) Lilliefors/Van Soest’s test of normality. Encyclopedia of measurement and statistics. Neil Salkind (Ed.). Sage, Thousand Oaks, California

Aczel, A. & Sounderpandian, J. (2009). Complete business statistics (7th ed.). McGraw Hill.

Affective Computing, MIT Media Lab (2011) Single sample Kolmogorov-Smirnov goodness-of-fit hypothesis test.

Agresti, A. (2002) Categorical data analysis, Wiley & Sons

Answorth, A. (2004) MANOVA basics, Lecture 10, Psy 524, Applied multivariate statistics, California State University.

Arthur, D. and Vassilvitskii, S. (2007). kmeans++: the advantages of careful seeding (PDF). Proceedings of the eighteenth annual ACM-SIAM symposium on Discrete algorithms. Society for Industrial and Applied Mathematics Philadelphia, PA, USA. pp. 1027–1035.

Azur, M. J., Stuart, E. A., Frangakis, C., and Leaf, P. J. (2012) Multivariate imputation by chained equations: what is it and how does it work? Int J Methods Psychiatr Res. Mar 1, 2011; 20(1): 40–49.

Barabesi, L. and Greco, L. (2002) A note on the exact computation of the Student t, Snedecor F and sample correlation distribution functions. Journal of the Royal Statistical Society. Series D (The Statistician). Vol 51. N. 1. pp 105-110.

Baraldi, A. N. and Enders, C. K. (2010) An introduction to modern missing data analyses, Journal of School Psychology 48, 5–37.

Benoit, K. (2012) Multinomial and ordinal logistic regression, ME104: Linear Regression Analysis, London School of Economics and Political Science. 

Benton, T. (2013) An empirical assessment of Guttman’s Lambda 4 reliability coefficient. International Meeting of the Psychometric Society, Arnhem, July 2013

Berk, K. N. & Carey, P.M. (2010). Data analysis with Microsoft Excel. Brooks/Cole, Cengage Learning

Black, K. (2014) Calculating the power of a test. Clarkson University

Bland, J. M. & Altman, D. G. (1986) Statistical methods for assessing agreement between two methods of clinical measurement. Lancet, 1986 pp 307-310

Bland, J. M. (2008). Cohen’s Kappa. Course notes: Measuring health and disease. University of York.

Bonett, D. G. (2002) Sample size requirements for testing and estimating coefficient alpha. Journal of Educational and Behavioral Statistics, Vol 27, No 4, 335-340.

Brannick, M. T., Regression (2007) University of South Florida

Buro, K. (2014) Stat 378 – Applied regression analysis, MacEwan University

Cardillo, G. (2009). Algorithm for Fleiss’s kappa, MATLAB

Cherry, S. (1999) ANOVA course notes. University of Montana

Chinn, S. (2000) A simple method for converting an odds ratio to effect size for use in meta-analysis. Statistics in Medicine 2000, 19:3127-3131.

Choong, J. (2012) Powerful forecasting with MS Excel

Clark, M. (2009) MANOVA, Dig It!, Psyc 6810, University of North Texas.

Clarke, G. M. & Cooke, D. (1998). A basic course in statistics (4th ed.). Arnold.

Cohen, J. (1988). Statistical analysis for the behavioral sciences (2nd ed.). Lawrence Erlbaum Associates.

Collet, D. (2003) Modeling survival data in medical research 2nd Ed. Chapman & Hall/CRC,%202004)(ISBN%201584883251).pdf

Cormen, T. H., Leiserson. C.E. & Rivest, R.L. (1992). Introduction to algorithms. MIT Press.

Cronquist, O. (2009) Get digital help website

Czepiel, S. A. (2002) Maximum likelihood estimation of logistic regression models: theory and implementation.

Dahyot, R. (2007) Jackknife. Trinity College Dublin

de Groen, P.  (1998) An Introduction to total least squares. Nieuw Archief voor Wiskunde, Vierde serie, deel 14, 1996, pp. 237-253.

Dobson, A. J. (2002) An introduction to generalized linear models. 2nd ed. Boca Raton, FL: Chapman & Hall/CRC.

Doros, G. and Lew, R. (2010) Design based on intra-class correlation coefficients, American Journal of Biostatistics 1 (1): 1-8.

Dunnett, C.W. (1964) New tables for multiple comparisons with a control, Biometrics Vol. 20, No. 3. 482-491

El Ghaoui, L. (2012) Optimization models and application

Eliason, S. (2010) Review of binary, ordered, & multinomial logit model, University of Arizona.

Enders, C. (2006) Analyzing structural equation models with missing data,  Arizona State University.

Eshel, G. (2009) The Yule Walker Equations for the AR Coefficients. Financial Time Series and Computational Statistics. Wharton School.

Evans, W. M. (2013) Durbin Watson tables, ECON 30331/Econometrics (lecture notes), University of Notre Dame

Expert Health Data Programming (2015) What is Jenks Natural Breaks?

Faculté des Sciences, Juidiques, Economiques, et Sociales – Fes. (2014) Liste non-exhaustives des tests statistiques

Fagerland, M., Hosmer, D. and Bofin, A. (2008) Multinomial goodness-of-fit tests for logistic regression models, Statistics in Medicine, Wiley Interscience

Faul, F., Erdfelder, E., Buchner, A., & Lang, A. G. (2009). Statistical power analyses using G*Power 3.1: Tests for correlation and regression analyses. Behavior Research Methods, 41, 1149-1160.

Feldt, L. S., Woodruff, D. J., and Salih, F. A. (1987) Statistical inference for coefficient alpha. Applied Psychological Measurement, Vol 11, No. 1, 93-103.

Field, A. (2009) Discovering statistics using SPSS. 3rd Ed. SAGE

Fleiss, J. L. (1971) Measuring nominal scale agreement among many raters. Psychological Bulletin, Vol 76 No. 5, 378-382.

Fleiss, J. L., Nee, J. C. M., and Landis, J. R. (1979) The large sample variance of kappa in the case of different sets of raters. Psychol. Bull., 86, 974-977.

Fox, J. (2005). Maximum-likelihood estimation of the logistic regression model. UCLA/CCPR Notes.

Freund, J. E. (1962). Mathematical statistics. Prentice Hall.

Gander, W. (1980) Algorithms for the QR-Decomposition. Seminar fuer Angewandt Mathematik Eidgenoessische Technische Hochschule, Zurich

Garbin, C. (2014) Cochran’s Q Test, Bivariate statistics hand-computation cache, University Nebraska Lincoln

Gardener, M. (2015) Using R for statistical analyses – Non-parametric stats. GardenerS own website

Gibilisco, S. (2004). Statistics demystified, McGraw Hill.

Goel. M.K., Khanna, P., and Kishore, J. (2010) Understanding survival analysis: Kaplan-Meier estimate. Int J Ayurveda Res. 2010 Oct-Dec; 1(4): 274–278.

Gould, R. (2002) Bootstrap Hypothesis Test, Stats 110A, UCLA

Gravetter, F. & Wallnau, L. (2008). Essentials of statistics for the behavioral sciences (6th ed.). Thomas Wadsworth.

Gujarati, D. & Porter, D. (2009) Basic econometrics. 5th Ed. McGraw Hill

Güner, B.G. & Johnson, J.T. (2007) Comparison of the Shapiro-Wilk and kurtosis tests for the detection of pulsed sinusoidal radio frequency interference

Halim, L. (2015) Survival analysis with Kaplan-Meier curves, Data analysis with Excel website

Hanlon, B. and Larget, B. (2011) Power and sample size determination, University of Wisconsin, Madison

Harter, H. L. (1960) Tables of range and Studentized range. Ann. Math. Statlist. Vol. 31 No. 4. 1122-1147.

Heij, De Boer, Franses, Kloek, and Van Dijk (2004) Econometric methods with applications in business and economics, Oxford University Press.

Hesterberg, T., Monaghan, S. et al (2003) Bootstrap methods and permutation tests, Chapter 18 of The practice of business statistics, W.H. Freeman and Company.

Hoel, P. (1943) On indices of dispersion. The Annals of Mathematical Statistics. Vol. 14, No. 2 pp. 155-162.

Hoel, P. (1962) Introduction to mathematical statistics, 3rd Ed. John Wiley and Sons

Hole, G. (2013) Deciding the statistical significance of nonparametric tests with large sample sizes, University of Sussex.

Horst, P. (1950) Estimating total test reliability from parts of unequal of unequal length. Educational Testing Service

Howell, D. (2007) Resampling statistics: Randomization and the bootstrap

Howell, D. C. (2010). Statistical methods for psychology (7th ed.). Wadsworth, Cengage Learning.

Howell, D. C. (2011). Confidence intervals on effect size

Howell, D. C. (2012). Treatment of missing data – part 2

Huang, H. (2006) Jacknife and Bootstrap University of California, Berkeley

IBM SPSS Statistics,

Ing, C-K, Multivariate normal distributions, Institute of Statistical Science, Academia Sinica

Irwin, M. (2006) Course notes, generalized linear models. Harvard University.

Kingman, A. (2011) Assessing examiner agreement: why reporting kappa is not enough, 16th Congress of The European Association of Dental Public Health

Klotz, J. (2004) A computational approach to statistics. University of Wisconsin at Madison

Kirchner, J (2001) Hodges-Lehmann estimators. Analysis of environmental data. University of California Berkeley

KMPK, Fundamentals of biostatistics. Course notes.

Kumar, R. (2002) Numerical analysis: Bairstow’s method. Indian Institute of Technology

Laerd Statistics (2013)

Lakens, D. (2013) Calculating and reporting effect sizes to facilitate cumulative science: a practical primer for t-tests and ANOVAs. Front. Psychol.

Larsen, P. V. (2006). Regression and analysis of variance. Course notes.

Lehnen, A. (2014) Excel comparison of linear regression to total least squares fit. Madison Area Technical College

León, R. (2004) Nonparametric tests and bootstrapping, Statistics 571: Statistical Methods, University of Tennessee

Lewis, A. (2013) Statistics for Engineers (course), University of Sussex

Lewis, J. P. & Traill, A. (1999). Statistics explained. Addison-Wesley.

Lilliefors, H. W. (1967) On the Kolmogorov-Smirnov Test for Normality with Mean and Variance Unknown, Journal of the American Statistical Association, Vol. 62, No. 318, pp. 399-402.

Lin, C. F. (2006). Analysis of three-way contingency table.

Lipsitz, S. R., Parzen, M. and Zhao, L. P. (2001) A degrees-of-freedom approximation in multiple imputation. J. Statist. Comput. Simul., 2002, Vol. 72(4), pp. 309–318.

Little, R. J. A. & Rubin, D. B. (1987) Statistical analysis with missing data. John Wiley & Sons.

Lockhart, R. (2008) STAT 350 Diagnostics, Linear models in applied statistics, Simon Fraser University

Lowry, R. (2012) Concepts & applications of inferential statistics.

Maathuis, M. (2011) Cox proportional hazards model and its characteristics. ETH

Macdonald, P. (1997) Confidence intervals for the mean of a Poisson distribution

Maitra, R. (2012) Box M test algorithm. Iowa State University

Mann, H. & Whitney (1947). On a test of whether one of two random variables is stochastically larger than the other. Annals of Mathematical Statistics, 18, p50-60.

MathWorks (2014)

Matthews, J. (2012) Survival analysis, Course in medical statistics, Newcastle University

MedCalc manual (2013)

Miguez, J. (2015) MTH6139 – Time Series, University of London

Minitab technical papers (2016)

MITOpenCourseware (2004) Statistical methods in brain and cognition lecture notes

Miwa, T. (2015) Probability distribution calculators

Molin, P. & Abdi, H. (1998) New table and numerical approximations for Kolmogorov-Smirnov/Lilliefors/Van Soest normality test. Technical report, University of Bourgogne.

Mong-Na Lo Huang (2011) Durbin-Watson test, National Sun Yat-sen University, Taiwan

Moore, D., McCabe G. and Craig, B. (2006) Chapter 15 (Non-parametric tests) of Introduction to the practice of statistics,  6th Ed. WH Freeman

Morrow, J. (2013) Nonsymmetric Eigenvalue Problems, University of Washington

Muelaner, J. (2015) Gage Repeatability and Reproducibility (Gage R&R) in an Excel Spreadsheet

National Institute of Standards and Technology (2012) Engineering statistics handbook

Nau, R. (2014) Forecasting with moving averages. Duke University–Robert_Nau.pdf

NCSS (2016) Deming regression

NCSS/PASS (2015) Confidence intervals for coefficient alpha. Sample size documentation

Newbold, P., Carlson, W. L., Thorne, B. (2010). Statistics for business and economics, 7th Ed., Pearson

Nietfeld, J. (2013) Introduction to reliability, North Carolina State University

North Carolina School of Science and Mathematics (2007) Hypothesis Testing and Power with the Binomial Distribution

Nydick, S.W.  (2012) The relationship between Spearman-Brown and Cronbach’s alpha

Ovais, M. (2012) AnaStats: Excel spreadsheet for Shapiro-Wilk

University of Oxford (2002) Introduction to statistical modelling: Applications of generalized linear models.

Pace, L. (2011). Statistical analysis using Excel 2007. Pearson Educational, Prentice Hall.

Panchecko, D. (2006) Statistics for applications, MIT Open Courseware

Park, T. (2003) A note on terse coding of Kaiser’s Varimax rotation using complex number representation.

Patil, V. and Kulkarni, H. (2012) Comparison of confidence intervals for the Poisson mean: some new aspects. REVSTAT Statistical Journal, Vol 10. No. 2. June 2012. 211-227

Peduzzi, P., Concato, J., Kemper, E., Holford, T., Feinstein, A. (1996) A simulation study of the number of events per variable in logistic regression analysis. Journal of Clinical Epidemiology 49:1373-1379.

Peltier Technical Services

Penn State University (2013) STAT 504: Analysis of discrete data (course notes),

Penn State University (2013) STAT 505: Applied multivariate statistical analysis (course notes),

Penn State University (2014) STAT 501: Regression methods (course notes)

Perry, W. (2006) Linear algebra (course notes). Texas A&M University.

Pollock, D. S (1996) Mathematical statistics. University of Leicester

Quick, C. (2013) Multivariate multiple regression with applications to powerlifting data, University of Minnesota Duluth

Ratitch, B., Lipkovich, I., O’Kelly, M. (2013) Combining analysis results from multiply imputed categorical data, PharmaSUG 2013 – Paper SP03

Rencher, A.C. (2002) Methods of multivariate analysis (2nd Ed). Wiley-Interscience, New York.

Roscoe, J. (1975). Fundamental research statistics for the behavioral sciences (2nd ed.). Holt, Reinhart and Winston.

Ross, S. (2015) What are some of the uses of the coefficient of variation (COV)? Investopedia

Royston, J. P. (1992) Approximating the Shapiro-Wilk W-test for non-normality, Statistics and Computing, vol. 2, pp. 117-119.

Runté, R. (2001) How to write tests, Education 3604, University of Lethbridge

SAS (2015) SAS documentation

Schafer, J.L. and Olsen, M.K. (1998) Multiple imputation for multivariate missing-data problems: a data analyst’s perspective, Penn State University

Seber, G.A.F. (1984) Multivariate observations. Wiley, New York.

Shapiro, S.S. & Wilk, M.B. (1965) An analysis of variance for normality (complete samples). Biometrika, Vol. 52, No. 3/4.

Shrout, P .E. and Fleis, J. L. (1979) Intraclass correlations: Uses in assessing rater reliability. Psychol. Bull., 86: 420-428.

Sloop, R. (2009) Understand Gage R&R, Quality Magazine

SOCR Statistics (2007) General Advance-Placement (AP) Statistics Curriculum – Gamma Distribution, UCLA

Statistics Online Computational Resource (SOCR) (2007), Alternative tests of variance homogeneity

Stanford University (2012) Critical values for the Durbin-Watson test, Econometric benchmarks

STATA power and sample size reference manual release 13 (2015)

StatLib (1995) Applied statistics algorithm for Shapiro-Wilk

Steier, J. F. and Fouladi, R. T. (1997) Noncentrality interval estimation and the evaluation of statistical models

Stephens, L. J. (2004). Advanced statistics demystified, McGraw Hill.

Stevens, J. (2002) Applied multivariate statistics for the social sciences (4th edition). Lawrence Erlbaum Associates. Mahwah, NJ

Taboga, M. (2010) Lectures on probability and statistics,

Takahashi, S. (2011) Heteroskedasticity (Lecture 10), International University of Japan

Tan, P., Steinbach, M. and Kumar, V. (2006) Introduction to Data Mining, Chapter 8, Pearson

Teixeira, A., Rosa, A. and Calapez, T. (2009) Statistical power analysis with Microsoft Excel: Normal tests for one or two means as a prelude to using non-central distributions to calculate power. Journal of Statistics Education.

Telke, S. (2013) Chi-square test and McNemar’s test. Pub H6414: Biostatistical Methods I, University of Minnesota

Templin, J. (2005) MANOVA, Lecture 5

Templin, J. (2015) Jonathan Templin’s website

Thorne, J. & Giesen, J.M. (2003). Statistics for the behavioral sciences (4th ed.). New York: McGraw Hill.

Tijms, H. (2007). Understanding probability: chance rules in everyday life (2nd ed.). Cambridge: Cambridge University Press.

Timm, N. H. (2002). Applied multivariate analysis. Springer.

Tsay, R. (2008) Lecture 2: Arma models

Tukey, J. (1949). Comparing individual means in the analysis of variance. Biometrics, 5, 99-114.

Uebersax, J. (2006). Intraclass correlation and related methods.

Uebersax, J. (2010) Statistical methods for rater and diagnostic agreement

UNISTAT (2015) Kruskal-Wallis One-way ANOVA

Wald, A. & Wolfowitz, J. (1940) On a test whether two samples are from the same population. Ann. Math Statist. 11, 147-162.

Walkenbach, J. (2007). Microsoft Office Excel 2007 Bible. Wiley.

Walkenbach, J. (2010). Microsoft Office Excel 2010 Bible. Wiley.

Walkenbach, J. (2007). Microsoft Office Excel 2007 Charts. Wiley.

Warren, H. (2007) Forecast Time Series within Excel

Weber, R. (2007) Time Series, Cambridge University

Westfall, P. (2014) Kurtosis as peakedness, 1905 – 2014, R.I.P. Am. Stat. 2014; 68 (3), 191-195.

Wikipedia (2012)

Williams, R. (2004), Standardized coefficients, Sociology Graduate Statistics 1, University of Notre Dame.

Wolverton, S. (2009) Chi-square tests of independence and goodness of fit. Department of Geography and the Environment, University of North Texas

Wuensch, K. (2012) Principal component analysis – SPSS

Wuensch, K. (2015) Biserial correlation coefficients

Yamano, T. (2010) Lecture 4: Multivariate Regression Model in Matrix Form, Lecture Notes on Advanced Econometrics

Zar. J. H. (2010) Biostatistical analysis 5th Ed. Pearson

Zaiontz, C. (2016) Real statistical analysis using Excel.

Zaiontz, C. (2016) Real multivariate statistical analysis using Excel.

Zaiontz, C. (2016) Real time series statistical analysis using Excel.

4 Responses to Bibliography

  1. Erik Gribbin says:

    Thanks very much for developing such great resources (website and realstats.xlam)!! I was looking up some of the sources in your bibliography and I noticed that the following source is not longer available:

    [La] Larsen, P. V. (2006). Regression and analysis of variance. Course notes.

    There is a link to this directory from , but the st111 directory itself, no longer seems to exist.

    Thanks again!

    Erik Gribbin

    • Charles says:

      Thanks for your kind remarks about the Real Statistics software pack.
      Unfortunately webpages and files that are interesting may be removed at any time. This is one of the realities of the Internet.

  2. stephan van straaten says:

    In relation to one of my previous comments.

    I assume you would prefer it as you have referenced it, ” Zaiontz, C. (2013) Real statistical analysis using Excel.”

    Again thank you

    • Charles says:

      That seems fine, but I will make the following suggestions:
      – Since I make changes all the time to the website and add-in probably it is best to change the date to 2014
      – If you want to specifically reference the add-in you should probably use the release number. The current release number is Rel 2.17.1.

Leave a Reply

Your email address will not be published. Required fields are marked *