I am pleased to announce Release 5.0 of the Real Statistics Resource Pack. The new release is now available for free download at Download Resource Pack for Excel 2007, 2010, 2013 and 2016 (Windows version) environments.

I am still working on Release 5.0 for the Mac, and I expect this to be available in June.

The Examples Workbook Part 1 has now been split into two files: Examples Workbook Part 1A and Examples Workbook Part 1B. These files as well as Examples Workbook Part 2 have been updated for compatibility with Release 5.0. The reliability examples, except for the ICC examples, can now be found in Workbook Part 1B and not Workbook Part 2.

The Real Statistics website will be updated over the course of the next several days to reflect the new capabilities in Release 5.0.

My apologies to all of you who have been waiting for the Real Statistic book. The revised timeframe for *Real Statistics using Excel – Fundamentals* is now September 2017.

Also thanks to all of you who have given donations to help sustain the Real Statistics project. This is most appreciated as are the countless number of people who have identified errors and who have made suggestions to improve the software and website.

The following is a summary of the new features in Release 5.0.

**Krippendorff’s Alpha**

Support for Krippendorff’s Alpha, another approach to inter-rater reliability, has been added. This approach has the advantage that it supports categorical, ordinal, interval and ratio type data and also handles missing data.

New functions have been added (**KALPHA, KTRANS, KRIP_SES, KRIP_SER, KRIP**) to support Krippendorff’s Alpha as well as a new data analysis tool.

**Gwet’s AC2**

Support for Gwet’s AC2 has also been added. Gwet’s AC2 is yet another approach to inter-rater reliability which is similar to Krippendorff’s Alpha

New functions have been added (**GWET_AC2, GWET_SES, GWET_SER, GTRANS, GWET**) to support Gwet’s AC2, as well as a new data analysis tool.

**Reliability data analysis tools**

The Reliability data analysis tool has been replaced by the following three data analysis tools:

**Internal Consistency Reliability**: Cronbach’s Alpha and Split Half / Guttman’s**Interrater Reliability**: Cohen’s Kappa, Weighted Kappa, Kendall’s W, Bland-Altman, Intraclass Correlation, Krippendorff’s Alpha and Gwet’s AC2**Item Analysis**: Discrimination Index, Difficulty Index, Point Biserial Correlation

**Distribution Fitting Capabilities**

The goal of these new capabilities is to determine how to fit various distributions to sample data. In particular, new functions have been added to estimate the parameters of these distributions using the method of moments (**WEIBULL_FITM, GAMMA_FITM, BETA_FITM, UNIFORM_FITM**), maximum likelihood (**WEIBULL_FIT, GAMMA_FIT, BETA_FIT, UNIFORM_FIT**) and regression (**WEIBULL_FITR**).

**Anderson-Darling Test**

The Anderson-Darling Test is a way of determining whether a specified distribution is a fit for a given sample. This test is now provided for the following distributions: normal, exponential, Weibull, gamma and generic (i.e. any distribution with no unknown parameters).

New functions have been added (**ANDERSON, ADTEST, ADCRIT, ADPROB**) to support the Anderson-Darling Test, as well as a new data analysis tool.

**Chi-square Goodness of Fit Test**

New distribution-specific capabilities have been added to complement the existing **FIT_TEST** function. The following distributions are initially supported: normal, exponential, Weibull, gamma, beta and uniform. The new **GOFTESTExact** function can be used when the distribution parameters are known and the new **GOFTEST** function can be used when the distribution parameters are not known. In addition these tests can be performed via a new data analysis tool.

**Non-parametric data analysis tools**

The Non-parametric data analysis tool has been split into the following two data analysis tools:

**Non-parametric Tests**: Friedman’s Test, Runs Tests, Cochran’s Q Test, Moods’ Test**Goodness of Fit Tests**: Two Sample Kolmogorov-Smirnov Test, One Sample Anderson-Darling Test, Chi-square Goodness of Fit Test

**Changes to the User Interface**

Upon pressing **Ctrl-m** (or an equivalent) you have access to the various data analysis tools via the original interface or the newer MultiPage interface. A new **Corr** tab has been added to the MultiPage interface that provides access to the following data analysis tools: Correlation Tests, Polychoric Correlation as well as the three reliability data analysis tools described above.

A new **Reliability** option has been added to the original interface, which gives access to the three reliability data analysis tools described above. Also a **Goodness of Fit** option has been added.

**Improved Box Plots**

The existing **Box Plot** and **Box Plot with Outliers** data analysis capabilities have been revised to better handle negative data elements. In such cases, you should refer to the labels for the y axis shown on the right side of the chart. Big thanks to Bob who explained how to make this improvement!

In addition, the **Box Plot** now shows the mean for each group (via an × on the chart)

**Statistical Tables**

A **Two Sample Kolmogorov-Smirnov** table of critical values has been added as well as **One Sample Anderson-Darling** tables of critical values.

The **One Sample Kolmogorov-Smirnov** table of critical values has also been revised. This also improves the accuracy of the **KSCRIT** and **KSPROB** functions. Errors in the **KSCRIT**,** KSPROB** and **KINV** functions have also been fixed.

**Two Sample Kolmogorov-Smirnov Test**

A new **KS2CRIT** function has been added which automatically performs the lookup of values in the Two Sample Kolmogorov-Smirnov table of critical values. In addition, the new **KS2PROB** function estimates the p-value for the Two Sample KS test based on interpolation between values in the Two Sample Kolmogorov-Smirnov table of critical values.

**Polygamma Function**

The **POLYGAMMA** worksheet function has been added to calculate the **digamma** and **trigamma** functions.

**Bug Fixes**

- Fixed the
**LCRIT**and**LPROB**functions for*n*> 50 - Fixed the
**LogitSelect**function, which did not work properly - Fixed the
**Three Factor ANOVA using Regression**(totals were not calculated) - Fixed the
**VAR_POWER**function (roles of the two parameters were reversed) - Fixed
**Chi-square Independence Test**data analysis tool when the standard format was used without headings