‹ Tutorials

Understanding your excel data tables

Data tables are a great way to show your data broken down into lots of different audience groups - but lots of numbers and columns can look confusing at first.

Sapio Research were a pleasure to work with, Jane was quick to pick up on our specific needs and turn around our complex, multi-national, small business research in a matter of days. We look forward to having the opportunity of working with her and the wider Sapio Research team again in the near future.

Michael Stovell
Commercial Manager
BCSG

In need of insights?

Success story

DocuSign

Demonstrating DocuSign’s thought leadership and ability to aid global Digital Transformation by helping them understand what consumers expect.

Read more

Data tables are a great way to show your data broken down into lots of different audience groups – but lots of numbers and columns can look confusing at first.

This is Sapio’s guide to help you quickly understand your tables.  Here are a couple of examples.

Single codes questions

This is when response only have the option of giving one answer, so the total will be no higher than 100%.

Single coded question

Looking across the rows you can see how one audience group responds compared to another. In this example we see our older respondents are less likely to have gone skiing than youger respondents.

Multi coded questions

When there is more than one possible answer to a question, the responses don’t have to add up to 100% because each participant can give more than one response.  

Mutli coded question

Statistical calculations: Mean

The Mean Score is the same as the Average.  It typically takes the mid point of each of the bands for the calculation.

Statistical calculations: Standard Error

We also sometimes see the Standard Error on the tables.  This doesn’t not mean that there is a problem with the data. It is instead a way of judging the representativeness of the mean score.  It indicates the variation levels within the data. 

The results from a survey are usually based on a sample rather than the population – to do the full population would be prohibitively expensive. If we interviewed everyone in the population though we might get a result that is slightly different from our survey. But how different?  The standard error gives us an indication of this. It shows the amount of variation in our answers that we might reasonably expect to see if we were to interview everyone or repeat the survey again.

In the example below we can see a mean of £784.96 in our total universe column of 2006 on the left. The standard error is 18.69 (i.e. + or – £18.69 in this case). The law of statistics suggests that if we interviewed everyone we would probably find that the true mean figure is most likely to fall between £766.27 and £803.65.

So our sample is subject to a potential margin of error of +/- £18.69, which is an other way of saying standard error.

Means and standard errors

The standard error figure highlighted in the second column shows that smaller base numbers are subject to much higher variations, in this case +/- £106.50.

Get topical tips, insights and more delivered to your inbox

Be the first to know about the latest international business sentiments, behaviors and plans so you can stay one step ahead of your competition.