Somers’ d Measure of Asymmetric Association

Basic Concepts Somers’ d statistic is a measure of (asymmetric) association. d takes values between -1 and 1. A value of 1 or -1 means that the independent variable perfectly predicts the dependent variable: +1 when the relationship is positive and -1 when the relationship is negative. A value of 0 means that there is … Read More

Lambda Coefficient

Basic Concepts The lambda coefficient is a measure of (asymmetric) association that reflects the proportional reduction in error (PRE) when values of the independent variable are used to predict values of the dependent variable. Lambda takes values between 0 and 1. A value of 1 means that the independent variable perfectly predicts the dependent variable. … Read More

Gamma Measure of Association

Basic Concepts Goodman and Kruskal’s gamma statistic is a measure of (symmetric) association between two ordinal variables. Gamma takes values between -1 and 1. A value of 1 or -1 means that the variables have a perfect association: +1 when the relationship is positive and -1 when the relationship is negative. A value of 0 … Read More

Real Statistics Release 8.3

I am pleased to announce Release 8.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, 2021, and 365 in both Windows and Mac environments. The Real Statistics website will be modified in the next few days to explain the … Read More

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 (includes Fisher’s and Boschloo’s exact 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 … 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 determine 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 label 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 approach … Read More