Real Statistics Release 9.1.1

by

I am pleased to announce Release 9.1.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 or software. Your help has improved the utility and accuracy of Real Statistics.This is a bug fix release, although there is the following new feature:

New LAMBX function

The existing LAMB function essentially codes a multvariate function of form f(X) where X has up to 10 variables. E.g. the function f(x, y) = x^2 + y is coded as =#£#£0^2+#£#£1. If you define the function h(x) as f(x,4) then the coding is =#£#£0^2+(4). This is what =LAMBX(“=x^2 + y”, 4) produces.

Using this new function you can define F(x) = ∫ t^(x-1) * exp(-t) dt (where the limits of the integral are 0 to ∞) by =INTEGRAL(LAMBX(“$t^($x-1)*exp(-$t)”,A1),0) where cell A1 contains the value of $x. This addresses a comment from Antony.

Bug Fixes

  • Improved the accuracy of the BNORMSDICT, BNORMDIST and BNORMRECT worksheet function when using the Genz option. Thanks to help from Antony.
  • Fixed an error in df factor values from the Taguchi DOE analysis tool when there are replications and averages are used instead of the S/N Ratio
  • Corrected an error in the formula that outputs the total number of outliers when using the Outliers and Missing Data option of the Descriptive Statistics and Normality data analysis tool.
  • Fixed an error to MDistSq that was inadvertently introduced in Rel 9.1.