Organization of the Website

Top Menu

This website is organized in the following parts, corresponding to the items in the top menu, from left to right:

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 Supplemental Functions and Supplemental Data Analysis Tools for information about how to access and use these supplemental resources).
  • Excel Examples Workbooks: The Real Statistics Examples Workbook and Real Statistics Multivariate Examples files contain all the Excel worksheets that are used in the examples in this website (see Excel Worksheet Examples for information about how to access these two workbooks).

The bulk of the website is organized into the following sections:

Basics

  • Introduction
  • Excel environment
  • Probability functions
  • Descriptive statistics
  • Hypothesis testing
  • General properties of distributions

Distributions

  • Normal distribution
  • Sampling distributions
  • Binomial and related distributions
  • Student’s t distribution
  • Chi-square distribution
  • Other key distributions
  • Testing for normality and symmetry
  • Non-parametric tests

ANOVA (Analysis of Variance)

  • One-way ANOVA
  • Factorial ANOVA
  • ANOVA with repeated measures
  • Analysis of covariance (ANCOVA)

Correlation

  • Correlation
  • Reliability

Regression

  • Linear regression
  • Multiple regression
  • Logistic regression
  • Multinomial and ordinal logistic regression
  • Log-linear regression

Multivariate

  • Multivariate Descriptive Statistics
  • Multivariate Normal Distribution
  • Hotelling’s T-square
  • MANOVA
  • Box’s Test
  • Factor Analysis

Appendices

  • Mathematical notation – reviews the mathematical notation used in this website
  • Excel capabilities – contains additional Excel concepts and summary of all the relevant built-in and supplemental functions and data analysis tools
  • Matrices – provides a review of matrix and related concepts used in this website
  • Linear algebra and advanced matrix topics – provides additional matrix topics required for multivariate statistical analysis
  • Statistical tables – provides useful statistical tables. Although most statistical tests used are accessible via Excel functions some require tables.
  • Bibliography
  • Author

Blogs

From time to time we will provide announcements and some additional information in the form of blogs.

Tools

  • Real Statistics Functions – provides a list of all the univariate functions in the Real Statistics Resource Pack free software, 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
  • 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

Leave a Reply

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