Top Menu
This website is organized in the following parts, corresponding to the items in the top menu, from left to right:
- Home: overview of the Real Statistics Using Excel platform
- Free Download: free download of software tools and worksheet examples.
- Main content (Basics, Distributions, ANOVA, Miscellaneous, Regression, Multivariate) describing how to perform a variety of statistical tests using Excel
- Appendices that provide additional background information
- Blogs that provide announcements of new software releases and other useful information
- Tools: description of the functions and data analysis tools in the free software pack
- Contact Us: method of communicating with the website administrator
- Search: means for finding additional information about any topic on the website
Free Download
In order to maximize the usefulness of the website, readers can click on Free Download to access the following capabilities:
- Real Statistics Resource Pack: Contains additional statistical functions and data analysis tools not supplied with Excel (see Real Statistics Functions and Real Statistics Data Analysis Tools for information about how to access and use these supplemental resources).
- Excel Examples Workbooks: The fourteen Real Statistics Examples workbook files contain all the Excel worksheets that are used in the examples found on this website (see Real Statistics Excels Workbooks for information about how to access these workbooks).
- Donation: Provides a way for users of the website’s free resources to make a small, optional donation to help offset the costs of running the website
The bulk of the website is organized into the following sections:
Basics
- Introduction
- Excel environment
- Real Statistics environment
- Probability functions (including queueing theory)
- Descriptive statistics
- Hypothesis testing
- General properties of distributions
Distributions
- Normal distribution
- Sampling distributions
- Binomial and related distributions
- Student’s t distribution
- Chi-square and F distributions
- Other key distributions
- Distribution fitting
- Order statistics
- Testing for normality and symmetry
ANOVA (Analysis of Variance)
- One-way ANOVA
- Factorial ANOVA
- ANOVA with random or nested factors
- Design of experiments
- ANOVA with repeated measures
- Analysis of covariance (ANCOVA)
Miscellaneous
- Correlation
- Reliability
- Non-parametric tests
- Time series analysis
- Panel data models
- Survival analysis
- Bayesian statistics
- Winning at Wordle
- Handling missing data
Regression
- Linear regression
- Multiple regression
- Logistic regression
- Multinomial logistic regression
- Ordinal logistic regression
- Poisson regression
- Log-linear regression
Multivariate
- Descriptive statistics
- Multivariate normal distribution
- Hotelling’s T-square
- MANOVA
- Repeated measures tests
- Box’s test
- Factor analysis
- Cluster analysis
- Discriminant analysis
- Correspondence analysis
Appendices
- FAQs – frequently asked questions
- Mathematical notation – reviews the mathematical notation used in this website
- Excel capabilities – contains additional Excel concepts and a summary of all the relevant standard Excel functions and data analysis tools
- Matrices and iterative procedures – provides a review of matrix and related concepts used in this website
- Linear algebra and advanced matrix topics – provides information about additional matrix topics required for multivariate statistical analysis
- Other mathematical topics – e.g. roots of a polynomial, infinite series, complex numbers, derivatives, integrals, finding maxima/minima, etc.
- Statistical tables – provides useful statistical tables. Although most statistical tests used are accessible via Excel functions some require tables.
- Bibliography
- Author – brief biography of the website’s author
- Citation – how to reference the website and Real Statistics Resource Pack in publications
Blogs
- Announcements of new software releases and additional information in the form of blogs.
Tools
- Real Statistics Functions Overview – provides a description of how to use the worksheet functions provided by the Real Statistics Resource Pack free software.
- Distribution Functions – provides a list of all the univariate distribution functions in the Real Statistics Resource Pack with a brief description of each function
- Nonparametric Test Functions – provides a list of all the non-parametric testing functions in the Real Statistics Resource Pack with a brief description of each function
- Descriptive Statistics and Reformatting Functions – provides a list of all the descriptive statistics, reformatting, and sorting functions in the Real Statistics Resource Pack with a brief description of each function
- Regression and ANOVA Functions – provides a list of all the regression and analysis of variance functions in the Real Statistics Resource Pack free software, with a brief description of each function
- Correlation and Reliability Functions – provides a list of all the correlation, reliability, and test analysis functions in the Real Statistics Resource Pack, with a brief description of each function
- Multivariate Functions – provides a list of all the multivariate functions in the Real Statistics Resource Pack free software, with a brief description of each function
- Time Series Analysis Functions – provides a list of all the time series analysis functions in the Real Statistics Resource Pack free software, with a brief description of each
- Missing Data Functions – provides a list of all the missing data functions in the Real Statistics Resource Pack free software, with a brief description of each
- Mathematical Functions – provides a list of all the functions that support various mathematical concepts such as linear algebra, complex numbers, prime numbers, equation solving, derivatives/integrals, etc. in the Real Statistics Resource Pack, with a brief description of each
- Data Analysis Tools – provides a list of all the data analysis tools in the Real Statistics Resource Pack free software, with a brief description of each analysis tool
- YouTube Videos – provides links to videos created by Real Statistics users in multiple languages to explain concepts described on this website