Abdi, H. (2009). The Greenhouse-Geisser correction. In Neil Salkind (Ed.), 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). k-means++: 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.

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 etc.

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.

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 (course notes)

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.

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

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

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

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.

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

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 document (2013)

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/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

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.

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), at505/

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.

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

Wessel, P. (2014) Critical values for the two-sample Kolmogorov-Smirnov test (2-sided), University Hawaii at Manoa (SOEST).

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.

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 *