Real Statistics Regression/ANOVA Functions

The following is a summary of the Regression and ANOVA worksheet functions provided in the Real Statistics Resource Pack. These functions are organized into the following categories: Linear Regression Heteroskedasticity Autocorrelation Regression Power and Sample Size Stepwise Regression Exponential Regression Polynomial Regression Least Absolution Deviation (LAD) Regression Deming Regression Total Least Squares Regression Passing-Bablok Regression … Read More

CMH Example

Example Example 1: A study was conducted to see whether there was a difference in the rate of lung cancer between people who smoked one pack of cigarettes a day and those who regularly smoked an electronic cigarette. In the study, the confounding effect of the pollution level in the city where the smoker resided … Read More

CMH Test Basic Concepts

The Cochran-Mantel-Haenszel (CMH) test is used to test multiple 2 ⨯ 2 contingency tables across different values of a confounding variable. The test determines whether there is a significant difference between the odds ratios across the different values of the confounding variable. We represent each of the k 2 ⨯ 2 contingency as shown in … Read More

Cochran-Mantel-Haenszel

The Cochran-Mantel-Haenszel (CMH) test is used to test multiple 2 × 2 contingency tables across different values of a confounding variable. The test determines whether there is a significant difference between the odds ratios across the different values of the confounding variable. Topics Basic Concepts Example Real Statistics Support References PennState (2017) Cochran-Mantel-Haenszel test https://online.stat.psu.edu/stat504/lesson/5/5.3/5.3.5 SAS … Read More

Real Statistics Release 5.3

I am pleased to announce Release 5.3 of the Real Statistics Resource Pack. The new release is now available for free download at Download Resource Pack for Excel 2013 and 2016 (Windows version) environments. The resource pack for Excel 2007 and 2010 environments will be available later today or tomorrow. The resource pack for Excel 2011 and 2016 … Read More

Real Statistics Release 5.1

I am proud to announce Release 5.1 of the Real Statistics Resource Pack, which is loaded with a lot of new features. The new release is now available for free download at Download Resource Pack for Excel 2013 and 2016 (Windows version) environments. The resource pack for Excel 2007 and 2010 environments will be available within the next … Read More

CA Data Analysis Tool

Worksheet Functions Real Statistics Functions: The Real Statistics Resource Pack contains the following array functions where R1 is an array containing an m × n contingency table, R2 is an mm × n array containing supplementary row profiles and R3 is an m × nn array containing supplementary column profiles. None of these arrays include row … Read More

Correspondence Analysis Basic Concepts

Overview Correspondence analysis plays a role similar to factor analysis or principal component analysis for categorical data expressed as a contingency table (e.g. as described in the chi-square test of independence). For a 10 × 10, a complete description of the associations between row elements and column elements requires nine dimensions. Unfortunately, it is difficult … Read More

Correspondence Analysis

Correspondence analysis plays a role similar to factor analysis or principal component analysis for categorical data expressed as a contingency table (e.g. as described in the chi-square test of independence). Essentially, correspondence analysis decomposes the chi-square statistic of independence into orthogonal factors. This approach is valid even when the cell sizes in the contingency table … Read More

Polychoric Correlation Tool

Worksheet Functions Real Statistics Functions: The Real Statistics Pack provides the following worksheet functions: TCORREL(R1, lab, opt, alpha): outputs a column array containing the tetrachoric correlation coefficient for the 2 × 2 contingency table in range R1 (without headings), standard error, z statistic, p-value, and the lower and upper limits of the 1 – alpha … Read More