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

The spreadsheets for all the examples used on the Real Statistics website, including those related to the new Release 4.3 features) are available for free download (Download Examples Workbooks). These are now contained in **three** Excel files (i.e. workbooks): Examples Workbook Part 1, Examples Workbook Part 2 and Multivariate Examples. See Workbook Examples for a description of which examples are contained in which files.

The Real Statistics website is in the process of being updated to reflect the new features. These changes will be made over the few days.

Release 4.3 contains the following new features:

**Survival Analysis**

There is a new** Survival Analysis** data analysis tool which provides access to the following capabilities:

**Kaplan-Meier**procedure: one and two sample versions, survival curves, log-rank test, hazard ratio, etc.**Cox Regression**: regression analysis

In addition there are the following new array functions

**COXEST**: similar to Excel’s LINEST function (for multiple regression), but for Cox regression.

**COXPRED**: predicts the hazard ratio between two subject profiles based on a Cox regression model

**LOGRANK**: calculates the log-rank related statistical tools to determine whether two survival curves are statistically different.

**Step Chart Data Analysis Tool**

Enables you to create charts of step functions

**Confidence and Prediction Intervals for Multiple Regression**

The new **RegPRED** array function lets you to calculate the confidence and prediction intervals for multiple regression.

**New Sort Functions**

In addition to the existing **QSORTRows** function that enables you to sort a range by rows based on one key, there are now two new functions that allow you to sort by rows using a primary and secondary key.

**QSORT2Rows**: sorts the rows in ascending or descending order

**QSORT2RowsMixed**: sorts the data in ascending or descending order of the primary key, but in case of a tie it sorts the secondary key in the opposite order

**Matrix Merge Function**

The following new array function has been added

**MERGE**(R1, R2): outputs an *m* × *n*1+*n*2 range which contains the values in the *m*2 × *n*2 range R2 adjoined to the right of the *m*1 × *n*1 range R1, where *m* = max(*m*1, *m*2) and any missing values are filled with empty cells

**Shapiro-Wilk**

In calculating the p-value for the original version of the Shapiro-Wilk test, harmonic interpolation is now used for values in Shapiro-Wilk table. If you prefer using linear interpolation, you can specify that *h* = FALSE in the following functions.

**SWPROB**(*n, W, b, h*) = p-value for the Shapiro-Wilk test**SWTEST**(R1*, b, h*) = p-value for the Shapiro-Wilk test

**Checking assumptions for Two Factor ANOVA**

To make it easier to check the normality and homogeneity of variance assumptions for two factor ANOVA, a new **Reformat** option has been added to the **Two Factor Anova** data analysis tool. This option converts data in two factor Anova Excel format to one factor Anova Excel format. In this format, you can use the **Descriptive Statistics and Normality** (esp. **Shapiro-Wilk**) and** Levene’s test** data analysis tool capabilities to check for normality, outliers and homogeneity of variances.

**Multiple Linear Regression**

The **RegCoeff** function and the **Linear Regression** data analysis tool will now support more than 64 independent variables. Actually they will support as many variables as the the size of the largest matrix that can be inverted using the MINVERSE function.

**Bug Fixes**

**ANCOVA**data analysis tool: the SSBet value in the output has been corrected, which impacts the values of other cells in the output.**Two factor repeated measures ANOVA**data analysis tool: The F-crit value for the Rows factor has been corrected.