Using Excel software to calculate Bayesian factors: taking goodness of fit test (Chi-square test) as an example

TL;DR

This paper demonstrates how to calculate Bayesian factors using Excel software through an example of the Chi-square goodness of fit test, comparing results with JASP software.

Contribution

It introduces a method for calculating Bayesian factors in Excel, providing an accessible alternative to specialized software like JASP.

Findings

Excel calculations are accurate within a specific sample rate range.

Differences between Excel and JASP are not statistically significant.

Excel can be used effectively for Bayesian analysis in goodness of fit tests.

Abstract

Taking the goodness of fit test (Chi test) as an example, this paper attempts to calculate the Bayesian factor BF10 of n-fold Bernoulli test by the Excel software (using JASP software as the evidence). The results showed that in the range of 0.15-0.55 (the rate of samples which are all "true"), the calculated results of Excel were more accurate, and the differences between the two (Excel and JASP) were not statistically significant (P>0.3).