Excel provides formulas for most of the common tests and distributions (as described in Built-in Statistical Functions). Excel doesn’t provide formulas for some tests, especially for non-parametric tests. For these, we use statistical tables, as described below.
Tables
- Wilcoxon Rank-Sum Table
- Mann-Whitney Table
- Wilcoxon Signed-Ranks Table
- Runs Test Table
- Shapiro-Wilk Tables
- One-Sample Kolmogorov-Smirnov Table
- Two-Sample Kolmogorov-Smirnov Table
- Studentized Range q Tables
- Spearman’s Rho Table
- Kendall’s Tau Table
- Durbin-Watson Table
- Lilliefors Table
- One-Sample Anderson-Darling Test Table
- Two-Sample Anderson-Darling Test Table
- Pearson’s Correlation Table
- Dunnett’s Table
- Augmented Dickey-Fuller Table
- Engle-Granger Table
Observations
Also, see Interpolation for a description of how interpolation is done for values between those found in these tables.
The Real Statistics Resource Pack provides a variety of worksheet functions (e.g. LCRIT, QCRIT, DCRIT, ADCRIT, etc.) that can be used for the lookup of values in these tables. These functions will usually provide any necessary interpolation.
References
Howell, D. C. (2010) Statistical methods for psychology (7th ed.). Wadsworth, Cengage Learning.
https://labs.la.utexas.edu/gilden/files/2016/05/Statistics-Text.pdf
Kanji, G. K. (2006) 100 Statistical tests. 3rd Ed. SAGE
https://methods.sagepub.com/book/100-statistical-tests
Lee, P. M. (2005) Statistical tables. University of York
https://www.york.ac.uk/depts/maths/tables/
Zar. J. H. (2010) Biostatistical analysis 5th Ed. Pearson
https://www.pearson.com/us/higher-education/program/Zar-Biostatistical-Analysis-5th-Edition/PGM263783.html
i am wondering if you can share Statistics Tables as pdf
I plan to release a book in a couple of month which will contain the statistics tables. You will be able to get the book as a pdf.
Charles
Hi charles,
I am still waiting for the book that contain the statistics tables.
Thank you.
Hello Arko,
Sorry, but the book keeps getting delayed. I expect to publish the book by September.
Charles
This is, by far, my favorite statistics site. Thank you fo much for your efforts and your explanations!
Greetings from the Caribbean.
Jazzy,
Nice to hear. Thanks for your comment and support.
Charles
Hi Charles,
Thanks for providing these amazing resources especially for people who can’t afford to buy Minitab or other statistical software. Your instructions are very simple and well written. Do you any plans in the future to add MSA (Attribute and Continuous) analysis as well?
Hi Jas,
Thank you very much for your kind remarks.
I already provide support for Gage R&R. See
Gage R&R.
Charles
Hello Charles,
I was wondering if there existed a table for Pearson’s correlation coefficients. (ones similar to the spearman and kendall tables)
Also, is it still appropriate to use the one-sample correlation function on excel if the data is binary.
For example, linking gender (Males=0, Females=1) with whether or not they lived past the age of 100 (/=100 = 1) in a sample size of 50 people.
Connie,
Tables for Pearson’s correlation coefficient do exist. I am planning to add such a table to the website.
With binary data the normality assumption for the one-sample correlation test won’t be met. You can use the CORREL function, but the correlation test won’t be valid. You can use the chi-square test for independence if it meets your needs.
Charles
Many many thanks for your wonderful and exhaustive service, which is really amazing. I find your explanation and add on so very helpful. It would be wonderful, if you could kindly add time-series analysis and cluster analysis, as well.
I am glad that you like the site. I already have time-series analysis and cluster analysis in the list of future enhancements. I hope to get to these after the summer.
Charles