Examples Workbooks
Fourteen Excel workbooks can be downloaded for free which contain worksheets that implement the various tests and analyses described in the rest of this 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.)
All fourteen of these files are compatible with the latest release of the Real Statistics Resource Pack (Release 9.2.2).
Note
Over time, the webpages on the Real Statistics website are being updated so that you will be able to download an Excel file with any of the examples found on that particular webpage. We are only at the early stages of this transformation. The examples workbooks listed above may have older versions of the examples than the ones that can be downloaded from individual webpages.
DownloadÂ
- Click on Real Statistics Examples: Basics to download the Basics examples workbook. 1/22
- Click on Real Statistics Examples: Distributions to download the Distributions examples workbook. 5/22
- Click on Real Statistics Examples Non-Parametric 1 to download the Non-parametric Tests examples workbook. 6/20
- Click on Real Statistics Examples Non-Parametric 2 to download the Non-parametric Tests examples workbook. 12/20
- Click on Real Statistics Examples Goodness of Fit to download the Goodness of Fit examples. 5/22
- Click on Real Statistics Examples Correlation-Reliability to download the Correlation and Reliability examples workbook. 11/21
- Click on Real Statistics Examples ANOVA 1 to download the Anova 1 examples workbook. 3/22
- Click on Real Statistics Examples ANOVA 2 to download the Anova 2 examples workbook. 2/22
- Click on Real Statistics Examples Regression 1 to download the Regression 1 examples workbook. 4/21
- Click on Real Statistics Examples Regression 2 to download the Regression 2 examples workbook. 5/22
- Click on Real Statistics Examples: Multivariate to download the Multivariate examples workbook. 3/22
- Click on Real Statistics Examples: Time Series to download the Time Series examples workbook. 3/22
- Click on Real Statistics Examples Bayes to download the Bayes Analysis examples workbook. 12/21
- Click on Real Statistics Examples Math Topics to download the Mathematical Topics examples workbook. 11/21
Downloading any of these workbooks means that you accept the Real Statistics License Agreement. The date listed is the date that the workbook was last updated.
Installation
Before you use any of these 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 the Real Statistics Examples Workbook, 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). You should close any Excel workbooks that are open and then open the Real Statistics Examples Workbook.
When you open the Real Statistics Examples Workbook for the first time you may receive the following messages:
“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.
Using the Examples Workbooks
Once you have downloaded and installed one or both 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).
Dear Charles
I’m seeking help with the Bairstow’s Method of Polynomial Root Extraction. Could you please assist me with:
1. A step-by-step explanation of the method
2. Implementing it in a spreadsheet
3. Solving 5 polynomials (degree 7) using the method, including complex roots
Please provide:
– A table summarizing results
– Step-by-step solutions and calculations
I’d appreciate any guidance or resources to help me understand and apply the Bairstow’s Method.
-Jhai
Dear Jhai,
See https://real-statistics.com/other-mathematical-topics/roots-of-a-polynomial/bairstows-method/
Charles
Hi
I’m Ana Gonzalez, a geology student from Universidad Industrial of Santander in Colombia. I’m currently working on my thesis, which involves calculating many hydrology parameters (lots of statistics) and findind your page and your tools just saved my life, thanks for sharing your knowledge to the world.
I would like to know if you could help me with this. I need to apply a goodness of fit test (chi square) to find which distribution (normal, lognormal or Gumbell) is the best fit for my precipitation data. I downloaded your example workbooks, but there’s many sheets that use chi square. Which one do you think would suit me the best in my case?
Thanks again for your work
Dear Charles:
I deeply thank you for your efforts and nice methods you teach.
Cheers.
Dr Ali Arminian
Ilam University, Iran.
Hello Ali,
Glad that I could help.
Charles
Real-Statistics-Multivariate-Examples.xlsx
Page : Factor
B44=-B31:B39
All other columns don’t have minus
C44=C31:C39
etc…
What am I missing?
Hello,
I am not sure why I flipped the signs for the first factor, but in any case, you can flip the signs of any of the columns, although you must change the signs of all the elements in that column. The reason for this is that the columns correspond to eigenvectors. If X is an eigenvector then so is -X.
Charles
Dear Charles,
I can’t help but congratulate you on a job well done with your statistics website. You make things very simple to understand by using useful examples. I always recommend to my students that they consult your website for assistance. Your user-friendly website makes it simple for people to understand things.
Keep the great work up!
Thank you very much.
Charles
Thank you very much ! You are awesome.
Hey Charles,
I want to perform PCA dimesnionality reduction, are there any videos to demonstrate how it is performed, i saw example workbook and unsure how i read the output, appreciate your help !!
Thanks
Praveen
Hello Praveen,
I haven’t made a video on this subject, but it is explained at
https://www.real-statistics.com/multivariate-statistics/factor-analysis/determining-number-of-factors/
You may need to read other webpages on this subject first. See
https://www.real-statistics.com/multivariate-statistics/factor-analysis/
Charles
I’ve just installed the add-in. Works fine, HOWEVER…
the yellow balloon tips for various options are behind the dialog box and cannot be fully read.
Hopefully this can be addressed in the next build. I’d attach the screenshot, but cannot.
Good luck!
If this happens, click on the Help button and then on the OK button on the help dialog box. The tooltips will now appear properly.
Charles
I Just want to say thank you for your kindness.
iam a student for my internship i need free stata latest version for monitoring and Evaluation
Leila,
I don’t have access to a free version of Stata. Many of the statistical analyses can be performed by Real Statistics. It is free.
Charles
This web page really helps a lot but I need a more comprehensive explanation of factor analysis with extraction method: orthogonal specifically. Kindly share the link to the above-related reference I mention.
I would start with
Factor Analysis
Charles
Dear,
Mr. Charles
I can’t speak more… your webs, so awesome.
now, i can teach my students more clearly by your helped.
I just want to say….Thanks You so much.
God Bless you Mr Charles
Glad I could help.
Charles
Hi Charles,
I am just update the version of RealStatistics for Excel2019 but after run the program for Cohen Kappa I found the message shown as below please suggest me how deal with it?
“Complie error in hidden module: Correlation, the version, platform, or architechture of this application”
Thank you in advance
Thanawat
See Compile Error in Hidden Module
Charles
Dear Charles,
I already check add in on my computer and it was installed. Then, I uninstall the old version and download the new one place on the same folder but still error. Please suggest me.
BR,
Thanawat
I you send me an Excel file with your data, I will see whether omething else is causing this problem.
Charles
If you email me an Excel file with your data, I will see whether something else is causing this problem.
Charles
You are invaluable, this is an amazing library Charles.
Thank you for your efforts and your wisdom!
Dear Charles ,
you are super excellent data analyzer one ,
actually , many one Got useful from your website
my appreciation and respect ,
I am looking for help in one issue , I need to make a comparison of two set data of instruments machine ?( Numerical values ) .
what I need is a ready forms / template for Bland Altman to fill it direct and to see to see the agreements between the results ? i read from your website but I am not good in data analysis .
sincerely
Hello Suhaib,
See Bland Altman
Charles
Dear Charles,
first of all congratulations for Real Statistics. It is a very nice tools set indeed!
I am trying to connduct a Mann-Kendall Test & Sen’s Slope using a long time series, containing 1154 terms, but the the application does not seem to work. Is there any limitation on the number of terms in the time series? If so, how can I tackle this?
Regards
Jorge
Jorge,
When you say that the application does not seem to work, does this mean that you get an error message? You should be able to use these tests for a time series with 1154 terms. If you email me an Excel file with your data and results, I will try to figure out what wrong.
Charles
Hi Charles,
no, the application does not give any error message but neither provides the expected results. I am sending you an excel file with the time series included. I hope it works!
Kind regards
Jorge
Jorge.
See the email that I sent you. I have just issued a new bug-fix release (Rel 7.5.1) that resolves this problem.
Charles
Dear Charles,
I am trying to do Kruskal Wallis, but you don’t have a tab with in both the non parametric excel files containing Kruskal Wallis. Can you tell me where i can find this excel sheet that contains it. I have seen texts on the site that there is something out there.
Greetings,
Ger
Dataset
ICU Beds Hospital
6 1
37 1
3 1
17 1
11 1
30 1
15 1
16 1
29 1
25 1
5 1
34 2
28 2
41 2
13 2
40 2
31 2
9 2
32 2
39 2
27 2
31 2
13 3
35 3
19 3
4 3
29 3
0 3
7 3
5 3
33 3
17 3
24 3
This is what i want to get as a result for my K-W:
Hospital N Median Mean Rank Z-Value
1 11 16 14,0 -1,28
2 11 31 23,3 2,65
3 11 17 13,7 -1,37
Overall 33 17,0
Method DF H-Value P-Value
Not adjusted for ties 2 7,05 0,029
Adjusted for ties 2 7,05 0,029
Hope you can help out….BTW Is your K-W producing output like this?
Ger,
See Kruskal-Wallis
The KW tool can be found as an option of the One-way ANOVA data analysis tool.
You can find the examples of the KW test on the ANOVA 1 examples workbook.
Yes, the output will be similar to what you have shown.
Charles
Your website, examples, and vb code are awesome!
Question: Is it possible to do robust standard errors on weighted least squares using Excel? If so, how?
Benjamin,
Thank you for your kind words about Real Statistics.
Real Statistics doesn’t provide an approach for robust errors on weighted least squares, but I am sure that it is possible.
The following is a reference, although it is not in Excel:
https://stats.stackexchange.com/questions/90785/using-weighted-least-squares-with-robust-standard-errors
Charles
Hello Charles,
I don’t have any specific question but i just wanna thank you for sharing with the world this little statistic treasure.
You did a wonderful job, i am sure it is also your passion.
Thank you so much
Where do I find Huber’s method?
Stan,
Are you referring to the approach described at
https://www.real-statistics.com/multiple-regression/robust-standard-errors/
You can find this on the Regression Part 1 workbook.
Charles
I am trying to do ADF Testing, have installed the package in the folder mentioned, but ADFTEST Formula does not seem to work.
Hello Akhil,
Is this the same problem that you identified in your other comment? If so, see my previous reply. If not, please provide additional information about the problem so that I can help you.
Charles