What is Real Statistics Using Excel?
Real Statistics Using Excel is a practical guide for how to do statistical analysis in Excel plus free statistics software which extends Excel’s built-in statistical capabilities so that you can more easily perform a wide variety of statistical analyses in Excel.
What does Real Statistics Using Excel consist of?
Real Statistics Using Excel is comprised of the following four components:
Real Statistics Resource Pack: an Excel add-in which extends Excel’s standard statistics capabilities by providing you with advanced worksheet functions and data analysis tools so that you can more easily perform a wide variety of practical statistical analyses.
Real Statistics Website (i.e. this site):
- Lets you download a free copy of the Real Statistics Resource Pack
- Provides descriptions of how to perform a variety of statistical analyses using built-in Excel capabilities as well as supplemental capabilities provided by the Real Statistics Resource Pack
- Presents numerous examples in the form of Excel worksheets which you can download to your computer
For the student and the novice, the Real Statistics website is an excellent tutorial for learning the basic concepts of statistics and how to do statistical analysis. For all users, it provides a step-by-step guide for how to do statistical analysis in the Excel environment and the tools necessary to carry out these analyses.
Real Statistics Examples Workbooks: five Excel files which contain all the examples contained on the website. These examples files can be downloaded for free. Each example focuses on a specific statistical concept and has been designed to demonstrate simple concepts before moving on to more complicated topics.
You can use this website to learn how to perform statistical analyses in Excel even without using the Real Statistics Resource Pack, but we recommend that you download the resource pack so that you can have access to its powerful capabilities.
Real Statistics Community: each webpage has a Comments section where you can make suggestions, identify errors, or ask questions to others in the community or request their advice.
How do I get started?
Step 1: If you elect to use the Real Statistics Resource Pack or would like a copy of the examples used throughout the website, click on the following icon and you will be given the opportunity to download and install for free the Real Statistics Resource Pack and/or the Examples Workbook.
Once you have downloaded and installed the Real Statistics Resource Pack, you will be able use the supplemental capabilities from the copy of Excel that you run on your computer as described throughout the rest of the website and summarized in Real Statistics Functions, Real Statistics Multivariate Functions, Time Series Analysis Functions, Missing Data Functions, and Real Statistics Data Analysis Tools.
If you choose not to download the resource pack or examples now, you can do so later at any time.
Step 2: Browse through the website to to learn how to perform a wide range of statistical analyses in Excel using standard built-in as well as supplemental capabilities. We suggest that you begin by clicking on the Website Introduction (and especially Organization of the Website) for further information about how to navigate the website to get the information you need to run any specific statistical test or learn about any particular topic.
Why do statistical analysis in Excel?
The reasons for choosing Excel are as follows:
- It is widely available and so many more people know how to use it
- It is not necessary to incur the cost of yet another tool
- It is not necessary to learn new methods of manipulating data and drawing graphs
- It already contains some basic statistics functions and data analysis tools
- It is much easier to see what is going on since unlike the more popular statistical analysis tools very little is hidden from the user
- It provides the user with a lot of control and flexibility
This makes Excel an ideal tool for learning statistical concepts and performing some basic statistical analyses, but unfortunately its built-in statistics capabilities are limited, and so it is often easier to use statistical tools such as SPSS or SAS for carrying out more advanced statistical analyses.
It is to address Excel’s shortcomings that we have created the Real Statistics Resource Pack. This software package contains various supplemental tools that enable you to carry out a wide range of advanced statistical analyses without leaving the Excel environment. You can download the Real Statistics Resource Pack free of charge from this website (as described above).