All the webpages on this website that provide Excel examples contain a link to an Excel workbook with those examples. This link is located towards the bottom of the webpage. You can click on that link to download the examples workbook.
Synchronization
Before you use any of the workbooks for the first time, you need to make sure that it is synchronized with the Real Statistics Resource Pack, the Excel Add-In, as described next.
After you download one of these Real Statistics examples workbooks, but before you open the workbook for the first time, you should make sure that the Real Statistics Resource Pack has been installed (see Real Statistics Resource Pack Installation).
When you open an examples workbook for the first time you may receive the following message:
“This workbook contains links to other data sources”
If you receive this message, click here to determine how to proceed. If you don’t receive this message then simply use the workbook as you would any Excel spreadsheet.
Alternatively, you may see the following message below the ribbon and above the Name Box (see Excel User Interface).
“Security Warning: Automatic update of links has been disabled”
In this case, click on the Options box and then click on Enable Content. From this point on you proceed as described above.
References
Schmuller, J. (2009) Statistical analysis with Excel for dummies.
https://www.oreilly.com/library/view/statistical-analysis-with/9780470454060/
Howell, D. C. (2010) Statistical methods for psychology (7th ed.). Wadsworth, Cengage Learning.
https://labs.la.utexas.edu/gilden/files/2016/05/Statistics-Text.pdf
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