• Letter to the Editor
• Open access
• Published:

# An Excel program for calculating statistics presented in Marfak et al.’s article ‘Improved RIDIT statistic approach provides more intuitive and informative interpretation of EQ-5D Data’

## Abstract

The objective is to present and share an Excel program that we have developed to perform statistical analyses based on the Improved RIDIT approach of Marfak et al.’s article ‘Improved RIDIT statistic approach provides more intuitive and informative interpretation of EQ-5D Data’.

## Introduction

In our article ‘Improved RIDIT statistic approach provides more intuitive and informative interpretation of EQ-5D data’ [1], we presented the theoretical bases of the Improved RIDIT method as well as its application for studying the effect of a disease or a treatment on the quality of life evaluated by the EQ-5D instrument.

Herein, we present and share with the scientific community in the field of health and quality of life an Excel program consisting of two separate files for performing the Improved RIDIT calculation and interpretation for both EQ-5D-3L (file: ‘ImprovedRIDIT-Calculation-EQ-5D-3L.xlsx’) and EQ-5D-5L (file: ‘ImprovedRIDIT-Calculation-EQ-5D-5L.xlsx’) versions. Each of the two Excel files comprises 7 sheets. The first sheet (Explanation & Interpretation) shows how to use the Improved RIDIT Excel program and how to interpret the results. Five sheets named MO, SC, UA, PD and AD for calculating the Improved RIDIT statistics for mobility, self-care, usual activities, pain/discomfort and anxiety/depression dimensions, respectively. The sheet (Summary Statistics) presents graphical and numerical distributions of responses obtained from the two EQ-5D samples. Also, this sheet summarizes the results of the five dimensions in a table, which can be used for results publishing. The p-values are corrected for multiple testing by the Bonferroni-Holm procedure [2]. The following steps show how to use the Improved RIDIT Excel program:

1. 1.

First, if data come from the EQ-5D-3L version, use the Additional file 1: ‘ImprovedRIDIT-Calculation-EQ-5D-3L.xlsx’ file; else use Additional file 2: ‘ImprovedRIDIT-Calculation-EQ-5D-5L.xlsx’ file if data come from the EQ-5D-5L version.

2. 2.

In each MO, SC, UA, PD and AD sheet in the Excel file, remove all data in the columns ‘Expected to be in better health’ and ‘Expected to be in worse health’ used for demonstration.

3. 3.

In the column ‘Expected to be in better health’ enter your own data from the sample that you expect individuals to be in better health status.

4. 4.

In the column ‘Expected to be in worse health’ enter your own data from the sample that you expect individuals to be in worse health status.

5. 5.

Once data entry is complete, the results are displayed on the same sheet under using (MO, SC, UA, PD and AD).

6. 6.

Do steps 1–3 for the five sheets (MO, SC, UA, PD and AD).

7. 7.

Finally, to use the ‘Summary Statistics’ sheet, copy results and past in a word file.

## Availability of data and materials

The Excel program presented in this letter is available in supplementary materials as two separate files: ‘ImprovedRIDIT-Calculation-EQ-5D-3L.xlsx’ file (for the EQ-5D-3L version) and ‘ImprovedRIDIT-Calculation-EQ-5D-5L.xlsx’ file (for the EQ-5D-5L version).

## Abbreviations

ARR:

Absolute Risk Reduction

ARI:

Absolute Risk Increase

## References

1. Marfak A, Youlyouz-Marfak I, El Achhab Y, Saad E, Nejjari C, Hilali A, Turman J. Improved RIDIT statistic approach provides more intuitive and informative interpretation of EQ-5D data. Health Qual Life Outcomes. 2020;18(63):1–14. https://doi.org/10.1186/s12955-020-01313-3.

2. Holm S. A simple sequential rejective multiple test procedure. Scand J Stat. 1979;6:65–70.

## Acknowledgements

We would like to thank Mss Asmaa Azizi and Mss Doha Achak for carrying out the tests of the program.

## Author information

Authors

### Contributions

MA developed the Excel program and wrote the manuscript, Y-M I designed the program and analyzed the output. MA and Y-M I read and approved the final manuscript.

### Corresponding author

Correspondence to Abdelghafour Marfak.

## Ethics declarations

Not applicable.

Not applicable.

### Competing interests

The authors declare that they have no competing interests.

### Publisher's Note

Springer Nature remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.

## Supplementary Information

Excel program for calculating Improved RIDIT statistics for EQ-5D-3L data.

Excel program for calculating Improved RIDIT statistics for EQ-5D-5L data.

## Rights and permissions

Reprints and permissions

Marfak, A., Youlyouz-Marfak, I. An Excel program for calculating statistics presented in Marfak et al.’s article ‘Improved RIDIT statistic approach provides more intuitive and informative interpretation of EQ-5D Data’. Health Qual Life Outcomes 19, 113 (2021). https://doi.org/10.1186/s12955-021-01745-5