Real Statistics Examples Workbooks

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.4.5), although the latest examples workbooks can only be downloaded from the webpage containing the example.

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 

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).

258 thoughts on “Real Statistics Examples Workbooks”

  1. 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

    Reply

  2. 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

    Reply

  4. 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?

    Reply

    • 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

      Reply

  5. 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!

    Reply

  7. 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

    Reply

  8. 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!

    Reply

    • 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

      Reply

  11. 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.

    Reply

  12. 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

    Reply

  13. 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

    Reply

  15. 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

    Reply

  16. 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

    Reply

    • 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

      Reply

      • 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

        Reply

  17. 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?

    Reply

    • 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

      Reply

  18. 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?

    Reply

  19. 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

    Reply

    • 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

      Reply

Leave a Comment