Skip to main content
Health and Quality of Life Outcomes logoLink to Health and Quality of Life Outcomes
letter
. 2021 Apr 5;19:113. doi: 10.1186/s12955-021-01745-5

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’

Abdelghafour Marfak 1,2,, Ibtissam Youlyouz-Marfak 2
PMCID: PMC8022376  PMID: 33820569

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’.

Supplementary Information

The online version contains supplementary material available at 10.1186/s12955-021-01745-5.

Keywords: Improved RIDIT, EQ-5D, Quality of life, Absolute Risk Reduction, Absolute Risk Increase, Odds ordinal

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. 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. 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. 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. 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. Once data entry is complete, the results are displayed on the same sheet under using (MO, SC, UA, PD and AD).

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

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

Supplementary Information

12955_2021_1745_MOESM1_ESM.xlsx (5.2MB, xlsx)

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

12955_2021_1745_MOESM2_ESM.xlsx (5.2MB, xlsx)

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

Acknowledgements

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

Abbreviations

ARR

Absolute Risk Reduction

ARI

Absolute Risk Increase

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.

Funding

No funding was received.

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).

Declarations

Ethics approval and consent to participate

Not applicable.

Consent for publication

Not applicable.

Competing interests

The authors declare that they have no competing interests.

Footnotes

Publisher's Note

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

Contributor Information

Abdelghafour Marfak, Email: ab.marfak@gmail.com.

Ibtissam Youlyouz-Marfak, Email: ibtissam.marfak@uhp.ac.ma.

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. doi: 10.1186/s12955-020-01313-3. [DOI] [PMC free article] [PubMed] [Google Scholar]
  • 2.Holm S. A simple sequential rejective multiple test procedure. Scand J Stat. 1979;6:65–70. [Google Scholar]

Associated Data

This section collects any data citations, data availability statements, or supplementary materials included in this article.

Supplementary Materials

12955_2021_1745_MOESM1_ESM.xlsx (5.2MB, xlsx)

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

12955_2021_1745_MOESM2_ESM.xlsx (5.2MB, xlsx)

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

Data Availability Statement

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).


Articles from Health and Quality of Life Outcomes are provided here courtesy of BMC

RESOURCES