Organization of the Website | Real Statistics Using Excel

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

Reference

Howell, D. C. (2010) Statistical methods for psychology (7^th ed.). Wadsworth, Cengage Learning.
https://labs.la.utexas.edu/gilden/files/2016/05/Statistics-Text.pdf