Skip to content
View all projects
Data SolutionsPROJECT

When the result has to survive being challenged

There is research where a wrong number does not cost money. It costs the credibility of everything else, and that you do not get back.

When the result has to survive being challenged — illustrative image

The images on this page are indicative of the kind of work involved. They are not screenshots of what was delivered and do not represent the study's data or results.

100%
checked twice
2
calculation engines
97.9%
agreement across tests
22
reproducible routines
01

The Challenge

A research study had taken its survey to several hundred people, and the data reached us raw: one enormous spreadsheet, every question in its own column, everything spelled out in words and nothing calculated. There were also two standardised scales in the mix, the kind that are validated and used in research worldwide and that, for that very reason, only produce comparable results when applied exactly as they were designed. The questions the research set out to answer were of three kinds. Would there be differences between groups of people? Would certain measures move together, rising and falling as one? And out of everything that had been asked, what actually helped explain the rest? Turning that data into an analysis capable of answering those questions was the job. But the real objective was a harder one: that every step of that analysis could be defended in front of people who know the subject. Getting to the right numbers was not enough. We had to be able to explain why those responses went in and not others, why that test was applied and not another, and have the reasoning written down long before anyone came asking for it.
02

The Solution

We worked the way we always work, with one important difference: nothing here was taken on trust. Everything that was calculated was calculated twice, in two different programs, and then compared value by value.
2.1Preparation

Before you analyse, you tidy up

Of the several hundred responses the research had collected, we kept a little over 250. The bar was deliberately high: only the people who had answered everything got through. We could have estimated the missing values, which is what is usually done in these cases, and we would have ended up with a larger sample. But every estimated value leaves an opening for anyone who wants to contest the work, and here we could not leave a single one.

2.2Measures

Questions become numbers

More than a hundred questions had to go from text to number, one by one. Some of them were worded back to front on purpose, to catch people answering on autopilot, and those had to be reversed before they could count. Only once all of that was done could the scales be summed. And before we used them, we measured how internally consistent each one was, because a scale that is not consistent ends up not measuring what it claims to measure.

2.3Analysis

Only then do you analyse

Before running any test at all, we checked whether its assumptions held. A test applied where it does not belong produces a good looking number worth nothing at all. Only then did we move on to the group comparisons, to the correlations and to a model that would tell us which, out of eighteen possible factors, actually carried weight. Eight did. The final model accounts for about a third of what the research set out to explain, which, in survey data, is a solid result.

Illustrative image: the kind of statistical output behind the conclusions, with the scatter, the distribution and the correlation matrix side by side.
2.4Verification

Everything calculated twice

This is where the work sets itself apart. We rebuilt the whole analysis in a second program, written from scratch and with no connection to the first, and compared the two sets of results value by value. Then we went further and ran 188 analyses down two different statistical routes, to see whether the conclusions held on both sides. They held on 184. On the ones that carry the core of the research, agreement was total.

Illustrative image: the same values computed by two independent programs and compared line by line.
2.5Trail

Every decision with its reason

Every methodological decision was written down, and each one can be followed back to the exact line of data it came from. There are twenty-two routines, and any one of them can be run again from the beginning to give exactly the same result. This is not bureaucracy. It is what lets you answer a hard question months later with the answer already at hand, instead of having to reconstruct it from memory.

Illustrative image: the methodological decisions recorded and linked to one another, and the routines printed and tabbed.
2.6Audit

We went looking for our own mistakes

Before delivering, we went back over the whole thing looking for mistakes of our own. We found two, a badly parameterised calculation and a set of dispersion values, and corrected them. Better that we find them than someone else. What went out for delivery did not have a single value left unconfirmed.

03
Services used

The path we walked, from day one to final delivery.

01

Discovery Session

We listened carefully to understand the research, the data that already existed, and the level of scrutiny it would have to withstand.

02

ADDS Roadmap

We mapped the plan before touching the data: which entry criteria to adopt, which test to apply to each question, and in what order to proceed.

03

ADDS Create

We ran the plan end to end, from preparation to the final analyses, with independent verification, robustness testing and all the supporting documentation.

04
Technologies
IBM SPSS StatisticsPythonpandaspyreadstatscipystatsmodelsnumpy

In the end, what remained was not just a set of results. It was the assurance that any one of them holds up to the hardest question of all: and how exactly did you get there?

What this case does not say, and why

It does not say the client's name. It is fair to ask whether a case with no name is an invented one. It is not. What is missing here is not the client, it is their permission to name them. We do not have it, and without it the name does not appear. Nothing else is missing: the work is what was done and the numbers are what was measured. And if the discretion looks like a flaw in a case study, consider that it is exactly what you will want when the case is yours.

NEXT STEP

Have a project in mind?

Let's have a 30-minute conversation with no strings attached and see if it makes sense to work together.

Book a Discovery Session
Not sure where to start?