Real Statistics Release 9.8

I am pleased to announce Release 9.8 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, 2024, and 365 Windows and Mac environments. I would like to thank everyone who made suggestions or identified errors in the website or … Read More

Length of a Curve

Basic Concepts An integral is used to calculate the area under a curve, namely An integral can also be used to calculate the length of a curve, namely Just as for the area, we divide the curve into n small segments, as shown in Figure 1 Figure 1 – Decomposing the curve Here, we use … Read More

Boschloo Exact Test

Objective We now explore the Boschloo Exact Test, another exact test for 2 × 2 contingency tables. We start by reviewing the Fisher Exact Test for 2 × 2 contingency tables. Fisher’s Exact Test A 2 × 2 contingency table takes the following form Here, we assume that n11 is the smallest of the four shaded … Read More

Real Statistics Bayesian Analysis Functions

The following is a summary of worksheet functions provided in the Real Statistics Resource Pack that support Bayesian statistical analysis. These functions are organized into the following categories: Bayesian Analysis using Grids Bayesian Beta Testing Bayesian Binomial/Proportion Testing Bayesian T Tests Bayesian Signed-Rank Test Bayesian Mann-Whitney Test Bayesian Contrasts Bayesian Independence Test Bayesian Correlation Test … Read More

Real Statistics Release 9.5

I am pleased to announce Release 9.5 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, 2024, and 365 Windows and Mac environments. Over the next few days the website will be updated for compatibility with the new … Read More

Bayesian Gamma Test

Introduction Goodman and Kruskal’s Gamma Test is described in Gamma Measure of Association. Here we show how perform the Bayesian version of this non-parametric test in Excel.  Essentially this entails using the Bayesian version of Kendall’s tau test. Example Example 1: Repeat Example 1 of Gamma Measure of Association using a Bayesian approach (the data is … Read More

Bayesian Independence Testing Support

Objective We describe worksheet functions and data analysis tools that can be used to perform Bayesian independence testing in Excel. These capabilities implement the approach described in Bayesian Independence Testing and are provided by the Real Statistics Resource Pack. Worksheet Functions The Real Statistics Resource Pack provides the following worksheet array function in support of … Read More

Bayesian Independence Testing

Objective We describe the Bayesian approach to determining whether the two variables defined by a contingency table are independent. This is the Bayesian equivalence to the chi-square test of independence or Fisher’s exact test. See also Bayesian Hypothesis Testing. Terminology We assume that we have an m × n contingency table X = [xij] and … Read More

Real Statistics Release 9.1

I am pleased to announce Release 9.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, 2021, and 365 Windows and Mac environments.  I want to thank everyone who has made suggestions or has identified errors in the website … Read More

Real Statistics Release 8.7

I am pleased to announce Release 8.7 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 primary focus of this release is the addition of new non-parametric tests. . The … Read More