Analyzing Your Life Effectiveness Questionnaire Data

Analyzing your LEQ data

There are several options for analyzing your data, however, none are foolproof and all take some initiative and effort on your part.  The first step in each case is entering the data.

1. Auto-calculation Spreadsheet - This allows you to enter your data and get automatic results and graphs.

2. Microsoft EXCEL - Use the available MS Excel data entry templates.  You can then analyze the data yourself in EXCEL, however, this option requires you to write your formulae.

3. SPSS (Statistical Package for the Social Sciences).  This option best suits those who have access and are familiar with SPSS.  Enter data into either the Excel or SPSS data entry templates and then run the relevant SPSS Syntax files.  The output file should produce composite scores, descriptive statistics, effect sizes, and confidence intervals for changes in LEQ factors over time.  Of course, you can also conduct your own analyzes.

   • SPSS Syntax for LEQ-H-24 Short-term (Time 1 to 2) data

   • SPSS Syntax for LEQ-H-24 Long-term (Time 0, 1, 2, 3) data

4. A commercially available automated data-entry and report generation using MS Access has been developed by Karim Haddad (Forecast Systems).  The system can create pre-formatted reports on short-term outcomes in terms of effect sizes, broken down by group.

5. If you want help or advice regarding analysis of your data, contact the eGroup or James Neill.

Recommended reading

• Why use Effect Sizes instead of Significance Testing for Program Evaluation

• Technical notes on effect sizes & the LEQ