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
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
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
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
Basic Concepts Given n subjects, each of whom is given two treatments, where the result of each treatment is assigned one of k categories (including the case where there is only one treatment, but each subject is in one of k categories prior to treatment and one of the same categories after the treatment). This … Read More
I am pleased to announce Release 6.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, 365 in Windows and Mac environments. The Basics, Distribution, Non-parametric, Regression 1, Multivariate and Time Series examples workbooks have also been revised for compatibility with … Read More
After a significant result from the Chi-square independence test, as described at Independence Testing Follow-up, you can perform follow-up tests to pinpoint the source of the significant result. The approaches used are somewhat similar to the use of contrasts after ANOVA. Post-hoc worksheet functions The following Real Statistics array function is available to assist in … Read More
Basic Concepts When the chi-square test of independence produces a significant result, indicating that it is unlikely that the two variables are independent, it is often desirable to pinpoint which components of the two variables are responsible for the significant result. This can often be done by using additional chi-square tests of independence based on … Read More
I am pleased to announce Release 6.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 Windows users The version for Excel 2013, 2019 and 365 Mac users will be available shortly. The Basic, Distribution, Non-parameter and Time Series examples workbooks have … Read More
Data Analysis Tool Real Statistics Data Analysis Tool: The two types of independence tests for contingency tables with ordered row an column categories can be performed using the Chi-square Test for Independence data analysis tool. To use this tool for Example 1 of Ordered Independence Testing, press Ctrl-m and select Chi-square Test for Independence from … Read More