Accompanying this website are the following fourteen Excel workbooks which contain all the examples described in the rest of the website. In parentheses is a list of the Real Statistics website main menu topics covered in each examples workbook.
- Basics (Basics menu plus Mathematical Notation and Concepts, Excel Capabilities)
- Distributions (Distributions menu except for Testing for Normality and Symmetry)
- Non-parametric Tests Part 1 (first six Non-parametric Tests from the Miscellaneous menu)
- Non-parametric Tests Part 2 (other Non-parametric Tests from the Miscellaneous menu)
- Goodness of Fit (Testing for Normality and Symmetry from the Distributions menu and Goodness of Fit from the Non-parametric Tests on the Miscellaneous menu)
- Correlation and Reliability (Correlation and Reliability from the Miscellaneous menu)
- Anova Part 1 (One-way ANOVA and Factorial ANOVA from the ANOVA menu)
- Anova Part 2 (Topics from the ANOVA menu not included in Anova Part 1)
- Regression Part 1 (Linear Regression and Multiple Regression from the Regression menu)
- Regression Part 2 (Topics from the Regression menu not included in Regression Part 1, plus Survival Analysis and Handling Missing Data from the Miscellaneous menu
- Multivariate Analysis (Multivariate menu)
- Time Series Analysis (Time Series and Panel Data from the Miscellaneous menu)
- Bayesian Analysis (Bayesian Statistics from Miscellaneous menu)
- Mathematical Topics (Roots of a Function, Max/Min, Matrices, Iterative Processes, Linear Algebra, Complex Numbers/Matrices, Prime Numbers, Differentiation, Integration, Surface Charts, etc.)
These workbooks can be downloaded for free by clicking on Download Examples Workbook.
Accessing Examples Worksheets
Once you have download and installed any of the examples workbooks, you can click on any tab to access the various examples found on this website. Two tables of contents are provided to help you find the desired example.
The second worksheet in the workbook (labeled TOC) is the table of contents for the rest of the workbook. Clicking on any of the entries takes you to the specific example described in the corresponding part of this website. The entries in the TOC correspond to the various pages on this website. In this way, you can follow along with any of the topics on the website in Excel.
There is a more concise table of contents, which may be found in the first worksheet (labeled TOC0). Clicking on any of these entries takes you to the first entry in TOC for that general topic. The entries in TOC0 correspond to the menu items in the Content Menu (that appears on the right sidebar of this website).
References
Schmuller, J. (2009) Statistical analysis with Excel for dummies. Wiley
https://www.wiley.com/en-us/Statistical+Analysis+with+Excel+For+Dummies%2C+3rd+Edition-p-9781118464311
I’m starting to get the hang of Real Statistics functions. I have one question about making the worksheet examples more usable. At this time I can open the TOC and get to the example I am interested in by clicking in the appropriate link. No problem and it works as advertised.
I would like to make use of individual workbook examples (worksheets) outside of the multi example workbook. For example, supposing I wanted to copy #584, Multiple correlation coefficient (example 1) and work on it in a separate worksheet. Or alternatively perform two separate different analyses such as multiple correlation and resampling. If I want to use the workbook I have to shuffle through a number of tabs.
Copying and pasting an individual worksheet doesn’t seem to work since the underlying links aren’t there (unless I am doing something wrong?). I could just enter the formulas, but I would prefer to use the existing layout of the worksheet and not have to retype the formula. In other words extract the two example worksheets, along with perhaps the TOC and work from there.
I know, I probably seem a little lazy, but I’m an engineer and was raised that way. Any simple way to accomplish what I’m trying to do would be appreciated.
Thanks.
Joel,
I copy worksheets from the Worksheet Examples workbook all the time. The number of links to other worksheets is fairly limited, and so when there is such a link I either manually copy the linked data value or copy the linked worksheet as well. This hasn’t proven to be much of a problem. The main caution is that when you copy a chart it refers to the original data values, and so I am usually forced to delete the chart and regenerate it.
Charles
Hi Charles,
I am brand new to your very comprehensive set of workbooks. I can’t see an obvious trail to a worksheet that will help me learn about resampling. Can you signpost the quick path?
Many thanks,
Robert R.
Hello Robert,
See https://real-statistics.com/non-parametric-tests/resampling-procedures/
Charles
Problem with graphing function
Hi Charles
I am using the RealStats program in Excel 7. The first few months I was using it, the graphing functions, e.g. boxplots were working great. Then they stopped working and and I would get an error message: “A runtime error has occurred. The analysis tool will be aborted. Application-defined or object-define error”. IT staff removed the Excel program and then reloaded it. I downloaded the RealStats program for Excel 7 and installed it again. The same error message occured. I’m stumped. Any suggestions?
Thank you
Patricia Olson
Patricia,
I’m not sure what has caused this problem. I just issued a new bug-fix release of RealStats program today (Release 3.6.1). I have tested the box plots capability and it works properly on my computer with Excel 2007. The only change that I have made to this feature in the past few months is to grey out the ability to use the .EXC versions of QUARTILE functions (since Excel 2007 doesn’t support this version). Please let me know whether the new version works properly.
Charles
hi Charles, I thought you had a routine for computing Huber-white robust standard errors. Am I wrong? let me know. best wishes, Richard
Richard,
The software doesn’t yet calculate Huber-White robust errors. I plan to add this capability in a future release.
Charles