Leaders in Innovative Research Solutions

Blog

How much do cross tabulations cost?

how much do crosstabs cost

We like to be open our pricing. This article is aimed at helping you understand what things will affect the price of handling a cross tabulation project for you. Here’s the big five things that have the biggest impact on 90% or more of the projects we handle for clients. As we have handled crosstab projects ranging from £50 to £25,000, here are the key indicators.

1) Is the data easy to use?

ASCII data

Most research and commercial can be supplied to us in ASCII format using codes to represent each answer. ASCII data can be edited or viewed in most editors, including free tools such as Notepad. This is easy for us to work with and, provided that a map of the data is available, it will be easy to navigate. ASCII data that contains all or much of the data as text fields will be harder to work with.

Triple-S or SPSS format

Triple-S or SPSS are two other standard formats that make it easy for us to import the data into our software so that we can start to prepare your cross tabulations. As long as they are annotated properly, they are easy to work with.

Excel data

Data supplied in Excel format or as a CSV file are usually easy to work with. The same conditions for ASCII data apply to Excel data – data as codes is easier to work with than free texts.

What will cost more to work with?

For all the above, it is easy for us to work with your data. However, if data is provided in some proprietary format or is difficult to understand without a lot of questions, costs will start to increase. You can minimise these costs by providing concise, clear documentation.

Data structure will impact costs

Some projects will have more complex data. Most data sets in market research have one record per respondent, but more complex data structures are sometimes used. Examples of these would be:

  • Hierarchical data – where there is one record for the respondent data and one record for each occasion, e.g. one record for each supermarket visit, one record for each television programme watched, a number of patients reported for a responding doctor.
  • Different data sources - e.g. there is a data file of 1000 survey respondents and a file containing 250000 customers of which 1000 were surveyed.
  • Use of look up data – e.g. where data needs to be looked up in a separate Excel, Access, ASCII file - for example, a file that contains distances between two airports in the survey data.

All of these types of data issues will add cost to the project. On a small project, they can represent a significant percentage of the total project cost. On a larger project, they will impact less.

2) Are the texts available without the need to re-enter?

Data from Triple-S and Excel

Some projects that we handle have all or most of the texts with the data provided. For example, Triple-S files contain the data and, usually, texts relating to a project. This minimises the amount of work we have to do. SPSS files can also help, although multiple response questions are not processed efficiently in SPSS, which means that data from SPSS can be less easy to work with if there are a large number multiple response questions.

Response texts in Excel/CSV format or some other form

If the texts are available in Excel format, we can usually read the text directly from the worksheets without the need to re-enter. Sometimes, texts supplied in text files or in Word can also be used.

What will cost more?

If we just receive a printed questionnaire, it is likely that we will need to re-enter all of the texts for you. This can be a labour-intensive task, particularly on long questionnaires where different texts are used for most questions. On a complex project that needs senior tabulation script writers, costs can increase if you are effectively paying a highly skilled person to enter texts.

Tracking studies and multi-country projects

We are specialists in handling tracking studies and multi-country projects. These types of projects typically have similar questionnaires and data files – from wave to wave in the case of a tracking study – from country to country in the case of multi-country studies. How this is managed within the data can have a huge effect on project costs. There is a separate blog article on this, but we would recommend that you speak to us at the earliest opportunity if you want us to help with these types of project. The cost of taking over and re-writing a badly managed project of this type can be high.

3) How many variables and tables are there?

This is a more obvious metric – the more variables or tables that there are, the more that they will cost.

Does the analysis have repetitive parts?

However, there are two important things that can increase or decrease costs. If there are a lot of repetitive variables or tables, they will be much cheaper to produce than lots of differently structured variables or tables. A questionnaire that has a large number of rating scales that all need to be analysed the same way can be very cheap to prepare and process.

How many derived variables are needed?

For some projects, a lot of derived variables are needed. These may take time to prepare and check. If you require tabulations which show data as the questions are on the questionnaire, this will reduce costs.

4) How complex are the tables?

Tabulating a series of questions by one standard banner (or crossbreaks) is usually the cheapest way to produce a volume of crosstabs. Costs increase where there are summary tables, complex calculations, precise table layouts and where weighting is used. Generally, keeping your requirements to a pattern or style will reduce costs. If every table needs to be crafted differently, this will increase costs.

5) Do you know what you want?

This might sound like a rude thing to say – and I apologise in advance. But, clients who provide clear, concise instructions and know what they want can enjoy much lower prices. If you see a run of crosstabs as an experiment before you produce the final set of crosstabs, costs will be much higher.

By clear, concise instructions, I mean that you should specify anything that is not obvious, but don’t specify anything that is obvious or can be explained easily by email, phone or as a standard instruction.

Getting the best value for money

Whether this is the first project you have worked on or you have worked with different agencies, it is always best to talk about your project before it happens. We may be able suggest ways that you provide data, analyse your data or instruct us which will make a big difference to the cost of the work. Just ask!

Phil Hearn
Author: Phil Hearn - Date posted: 13 February 2017
Category: data-analysis - Tags: tabulation, crosstabs, mrdcl, scripting

« The biggest problems with scripted cross tabulations - How to get charts in Excel from MRDCL, Reflect and QPSMR tables »