Real Statistics Release 9.5.5

Over the next few days the website will be updated for compatibility with the new release. [This has now been completed]

I want to thank everyone who made suggestions for new features.

I also want to express my appreciation to all of you who have donated to Real Statistics. These donations help offset the costs of maintaining the website. If you are getting value from the Real Statistic website or software, I would appreciate your donation by going to Please Donate.

Bayesian Non-parametric Tests

This release adds support for the Bayesian versions of the Sign Test and Median Test. This is done via the new worksheet functions BayesSign and BayesMedian.

See More Bayesian Non-parametric Tests for more details.

Bayesian Contrasts

This release adds new contrast support for Bayesian analysis. The new worksheet function CONTRAST2 provides post-hoc support for interactions in two-factor ANOVA and related non-parametric tests. See Bayesian Contrasts for more details.

The release also adds the CONTRAST3 and CONTRAST4 functions, which provide support for post-hoc analysis for two-factor ANOVA with one within-subjects factor and one-between subjects factor and related non-parametric tests. See Bayesian Mixed-Model Contrasts for more details.

Two Sample Correlation Testing

This release adds support for the power and sample size required for two-sample correlation tests. This is done via the CORREL2_POWER and CORREL2_SIZE worksheet functions.

See Power and Sample Size for Two-Sample Correlation Testing for more details.

Multi-sample Correlation Testing

This release adds support for testing whether three or more sample pairs come from populations (or a single population) with the same correlation coefficient. This is supported using the new MCORREL_TEST function.

In case of a significant result, the following functions can be used for post-hoc testing: MCORREL_TUKEY, MCORREL_DUNNETT, or MCORREL_CONTRAST.

If the test is not significant, the following function can be used: MCORREL_TEST0.

See Multi-sample Correlation Test Support for more information.

Differential Equations

This release adds a new worksheet function DiffEq that finds numerical solutions to differential equations that can be expressed as

y′ = f(x, y(x))          y(x₀) = y₀

This function supports the following methods: Euler’s (forward and backward), Trapezoid, and Runge-Kutta. See Numerical Differential Equations for more information.

Partial Derivatives

The new release adds the functions DERIVXX, DERIVYY, and DERIVXY to calculate the partial derivatives ∂²f(x,y)/∂x∂x, ∂²f(x,y)/∂y∂y, and ∂²f(x,y)/∂x∂y, respectively.

See Numerical Differentiation for more details.

Minor Changes

A new optional argument has been added to the SmallExact(R1, k, prec) function. Previously, any value of k < 1 or k > n where n = the # of elements in R1 would return an error. Now any k in the range 1-prec ≤ k < 1 is treated like k = 1 and any k in the range n < k ≤ n+prec is treated like k = n. 

For the Mardia skewness test for normality, I have not been able to determine definitely whether the denominator for the small sample correction should be n(n+1)(k+1)-6, as in the current version, or n((n+1)(k+1)-6). Until I resolve this issue, I have added a new optional argument to the function MSKEWTEST(R1, lab, correct1) to allow the user to select between these approaches. If correct1 = TRUE (default), then the current approach is used; otherwise the revised approach is used.