Real Statistics Release 8.1.6

Announcing a minor bug-fix release of the Real Statistics software, Rel 8.1.6.  This release is now available for free download for both Windows and Mac environments. This release corrects the following bugs: The AdjRes and AdjResTest functions previously produced an error value when the number of rows in the contingency table was not equal to … Read More

Real Statistics Non-Parametric Test Functions

The following is a summary of worksheet functions provided in the Real Statistics Resource Pack that support non-parametric tests.  These functions are organized into the following categories: Chi-square tests Other non-parametric tests Other non-parametric tests (array functions) Runs tests Power and sample size for non-parametric tests Kolmogorov-Smirnov and Lilliefors functions Anderson-Darling test Other Goodness-of-Fit tests … Read More

Correlation and Reliability Functions

The following is a summary of the correlation and reliability functions worksheet functions provided in the Real Statistics Resource Pack. These functions are organized into the following categories: Covariance and Correlation Correlation Testing Association Interrater Reliability Internal Consistency Reliability Partitioning Bradley-Terry Model Testing Theory (Item Analysis and Item Response) Statistical Power Sample Size Covariance and … Read More

Cochran-Armitage Test

Objective The Cochran-Armitage test is used to test whether there is a linear trend when the response is binary. This test is used with data in the form of a contingency table, such as that described in Independence Testing, where there are only two data rows and we suspect (or hope) that the columns are … Read More

Real Statistics Release 7.4

I am pleased to announce Release 7.4 of the Real Statistics Resource Pack. The new release is now available for free download at Download Resource Pack for Excel 2010, 2013, 2016, 2019 and 365 in both Windows and Mac environments.  The Basics, Regression 1, Distributions, Multivariate examples workbooks are being updated for compatibility with the new … Read More

Simulation Chi-square Test

Basic Concepts In cases where the Fisher exact test is desirable, but where the exact test is not feasible, you can use an approach based on Monte Carlo simulation. We will call this a quasi-exact test. In addition to obtaining an estimated p-value, you can also obtain a standard error and confidence interval. The basic … Read More

Real Statistics Release 7.3

I am pleased to announce Release 7.3 of the Real Statistics Resource Pack. The new release is now available for free download at Download Resource Pack for Excel 2010, 2013, 2016, 2019 and 365 in both Windows and Mac environments.  The Basics, ANOVA 1,  ANOVA 2, Correlation/Reliability and Distributions examples workbooks have also been updated for … Read More

Real Statistics Release 7.2

I am pleased to announce Release 7.2 of the Real Statistics Resource Pack. The new release is now available for free download at Download Resource Pack for Excel 2010, 2013, 2016, 2019 and 365 in both Windows and Mac environments.  Over the course of the next several days, the website will be updated for compatibility with … Read More

Nominal-Ordinal Chi-square Test

In Independence Testing, we describe how to perform testing for contingency tables where both factors are nominal. In Ordered Chi-square Testing for Independence, we describe how to perform similar testing when both factors are ordinal. On this webpage, we consider the case where one factor is nominal and the other is ordinal. Example Example 1: … Read More

Real Statistics Release 7.1

I am pleased to announce Release 7.1 of the Real Statistics Resource Pack. The new release is now available for free download at Download Resource Pack for Excel 2010, 2013, 2016, 2019 and 365 in both Windows and Mac environments.  Over the course of the next several days, the website will be updated for compatibility … Read More