The Complete Guide to Market Research

Reporting

Reporting

There is no standard approach to reporting market research. Partly this is because different studies have different requirements. It is also because people like to work in basic ways. However, an approach to structuring reporting that can work in most situations is:
  1. Conduct all the analyses listed in the Analysis Plan and any additional analyses.
  2. Use Data Reduction to distill the essence of each of the analyses.
  3. Creating charts.
  4. Structuring and Sharing Findings

Charts

Our brains are much more efficient at processing images than at processing numbers. By presenting tables as charts we can make it much easier for people to interpret findings. Plotting Summary Tables using pie charts and column charts is straightforward. Unfortunately, with more complex tables, it is not the case that any chart is better than a table. Our brains are only good at interpreting images when the images are structured in particular ways.

Use columns for comparisons and lines for trends

The two charts below show the same data. When we look at the plot on the left our brain automatically tries to compare the height of the columns. If we look hard enough and read the comment we can see a trend. However, when we look at the plot on the right the trend is so clear it does not need to be described. The general conclusion is to use columns when wanting to emphasize and compare individual results and lines when wanting to emphasize and compare trends.

LinesForTrends.PNG

Minimize difficult comparisons by using grid layouts

The table below is large and complicated. It is not straightforward to examine it for conclusions.

ImageGrid.PNG

A ‘standard’ way to plot such data is as a column chart, as shown below. While prettier than the table, it is actually less useful. Consider trying to work out which brand is most strongly associated with being Sleepy. On the table we can quickly read down the appropriate column. In the chart below it is much harder to work out.

ColumnClustered.png

The solution to this charting problem, and to many charting problems, is to create a structure that is more grid-like, as shown below. The reason that this chart is better is that it replaces numbers with bars, without sacrificing the ability to read by rows or columns. Thus, we can quickly scan this chart to identify that, for example, Diet Pepsi scores the highest on Sleepy.

ColumnBars.png

This same basic principle is useful for time series data as well. Consider the default line chart created by Excel, shown below. It is very different to disentangle the meaning in this data.

Lines.png

We can get a small improvement by replacing the legend with individual labels on each line (this makes the comparisons easier because the reader does not have to continually work out which line to use).

Lines2.png

However, the chart below, which again adopts a grid like layout, and also orders the results, is substantially easier to interpret.

Lines3.png.

Use color and redundancy to emphasize

In a traditional chart is used to indicate different series. For example, in this chart blue is used for feminine and health orange for health-consciousness. This use of color is unhelpful. Our brains infer the colors as indicating that the columns are ‘different’ in some way, which makes it harder for us to accurately compare the columns and thus color in this context completely undermines the purpose of the chart.

ColumnBars.png

A better use of color is in the chart below. Color is still being used but it is being used in a different way. The intensity of the color is proportional to the length of the bars. This redundant use of information helps our brains interpret the chart (see Ordering for a further improvement of this chart).

OrangeImage.png

The next chart improves on the earlier time series chart. Note that color is used here to emphasize interesting results. In this case, it is used as a way of communicating the results of statistical testing.

Line4.png

Software

Most statistical packages can do the types of plots shown on this page (e.g., SPSS, R, SAS). They can also be created with a bit of work in Excel (e.g., by creating multiple charts and lining them up, or, by buying add-ins). The simpler plots on this page were created in Excel. The ‘grid’-style plots were created in Q, which is the only specialist survey-analysis program that implements these styles of plots.

Data Reduction

The easy part of data analysis is creating lots of crosstabs. The hard part is trying to figure out what it all means. Our brains are greatly limited in terms of the quantity of information that they can process. The more information that our brains have to process, the worse the job that they do. Consequently, a secret to interpreting data is to reduce the quantity of data. The academic term for this is data reduction.[1] This page illustrates some of the more elementary aspects of of data reduction by working through an example.

Deleting

The crosstab below shows how preferences for different brands of cola differ by age, gender and income. It is quite typical of the type used by commercial consultants when analyzing surveys. It is a very large crosstab. Indeed, it is so large that it is impractical for anybody to read everything on this crosstab and thus key findings hidden in the crosstab may easily be missed.

TableAll2.png

We can greatly improve this crosstab by deleting things. The reason that this works is that the more things on the page the more our brain gets distracted and thus the more we delete, the clearer the story in the data will become. The key things that we can delete from this table are:

  • All the statistics except for the column percentages. That is, we should delete counts (labelled N), row percentages (% within row). Of course, in some situations these additional statistics may prove to be useful, but more often-than-not they are not useful and thus the default should be to remove them.
  • The decimal places. Due to sampling error it is very rare that differences in decimal places are relevant and thus they should not be shown.
  • All of the income and gender data. The column comparisons show no significant differences for gender and thus the differences between male and female preferences for different brands of cola are likely due to sampling error and are thus not interesting. The case for deleting income is a little more complex. The only significant difference relates to the preference for Pepsi Max being relatively high among the people with incomes of $120,001 to $150,000/. This pattern seems counter intuitive: why should this small brand appeal to such a narrow income-based demographic. Consequently, it likely reflects one of those flukes that comes up from time-to-time in surveys and thus, in the absence of any corroborating evidence, should be ignored.

The much simpler crosstab that results is shown below.

Table1.png

The same basic idea can be applied to charts as well. The example below is from a PowerPoint presentation showing the popularity over time of some of Australia’s Prime Ministers. The plot beneath makes the pattern in the data much more clear by:

  • Deleting the background colors.
  • Smoothing the lines (i.e., deleting the small random deviations).
  • Deleting the chart junk (i.e., the callouts with the Prime Minters’ names.

Pol1.PNG

Pol2.PNG

Ordering

The two tables below show the same data. The one on the left is ordered alphabetically. The one on the right has been sorted by values. For most purposes, the table on the right is more useful as it allows people to quickly work out the relative performance of the options (which is usually the main interest when interpreting any table).

Aware.PNG

The idea of ordering information is more general than that of sorting. Consider the following two charts. The one on the left is substantially better in terms of communicating the pattern.[2]

OrderedStacked.PNG

When dealing with large tables the most useful way of ordering the tables is to use diagonalization. The basic idea of diagonalization is that the rows and columns of tables are re-ordered such that a near-diagonal pattern appears in the table. This allows our brains to recognize a pattern, which in turn makes it much easier to process the data. Note how in the second of the plots below it is really easy to see which brands are similar to which other brands and why.

OrangeImage.png

OrangeImageOrdered.png

References

  1. Jump up Collins, M. (1992). “The data reduction approach to survey analysis.” Journal of the Market Research Society 34(2): 149-162. Ehrenberg, A. S. C. (1975). Data reduction: analyzing and interpreting statistical data. New York, John Wiley.
  2. Jump up Ehrenberg, A. S. C. (1975). Data reduction: analyzing and interpreting statistical data. New York, John Wiley.
Market Research Guide: 11. Reporting | Q Research Software

Import and clean data

Advanced Analysis

Visualization and reporting

Another pair of hands

Find a researcher

Add profile  |  Edit profile
Alissa Algarin
New York, United States
Alissa Algarin consulting
Import and clean data
Advanced analysis
Visualization and reporting
Another pair of hands

Experienced marketing researcher with a proven track record of timeliness and quality work. End-to-end service, from research plan and questionnaire development, through data analytics, to reporting and presentation. MBA (Marketing), MS Data Science (Dec. 2021)

contact: alissa.algarin@outlook.com

CONTACT Alissa
Anastassia Laskey
Georgia, United States
AD Laskey Consulting
Import and clean data
Advanced analysis
Visualization and reporting
Another pair of hands

I use market research, customer analytics, and user research to help my clients solve their consumer-facing business problems. I help clients across the country conduct market research to gather fast, efficient, and actionable recommendations to move their businesses forward. I'm here to help!

CONTACT Anastassia
Benita Tan
Victoria, Australia
Essence Communications
Import and clean data
Advanced analysis
Visualization and reporting
Another pair of hands

Highly experienced quanty (and qually) with over 15 years in market research in APAC. Can assist at / on any stage in the project stage including survey design through to analysis, tabulation, reporting and advanced outputs (segmentation, mapping etc).
Love data and bringing it to life.

Contact me at: benita.tan@gmail.com

CONTACT Benita
Bernd Schmidl
Wien, Austria
self employed
Import and clean data
Advanced analysis
Visualization and reporting
Another pair of hands

I'm a sociologist, data analyst and market research consultant.
I have deep knowledge about survey data, how to set up questionnaires, do advanced analysis and visualization.
I work project based. More on:

www.berndschmidl.com

CONTACT Bernd
Diana Pinto
Greater London, United Kingdom
Point Insight Ltd
Import and clean data
Advanced analysis
Visualization and reporting
Another pair of hands

After 12 years at KPMG Nunwood and Incite, I have spent the last 2 years as freelancer for both insight agencies and for end clients. Happy to help in all aspects of a quant project; experienced in Q, having worked with the software for the last 7 years.
Contact me at: diana@pointinsight.co.uk

CONTACT Diana
Eva Iken
New South Wales, Australia
54degrees
Import and clean data
Advanced analysis
Visualization and reporting
Another pair of hands

With 12+ years experience in Research and Strategy, 5 years as independent quant consultant and 10 years of working with Q, I’m offering help on all levels; be it setting up or cleaning a data file, running simple or more advanced analysis or pulling data into an insightful and engaging report.

Contact me at: eva@54degrees.com.au

CONTACT Eva
Gillian Johnston
Bay of Plenty, New Zealand
Sprout Customer Research
Import and clean data
Visualization and reporting
Another pair of hands

Easy to work with and passionate about bringing data to life I have over 15 years experience in insight lead customer experience and MR. I work internationally with clients in NZ, the UK and Australia. For more information look me up on LinkedIn. https://www.linkedin.com/in/gillianjohnston1/

CONTACT Gillian
Gina Ricci
Florida, United States
GR Insights
Import and clean data
Advanced analysis
Visualization and reporting
Another pair of hands

With 20 years of experience, I can assist at any point in your project. Insights I've provided recently include customer satisfaction, market segmentation, pricing and packaging, employee engagement, new product and service introduction, and more. I hold an MS in Statistics and an MBA.

CONTACT Gina
Emma Woodwark
Cambridgeshire, United Kingdom
Indie Insight
Import and clean data
Advanced analysis
Visualization and reporting
Another pair of hands

I have 15+ years' experience in market research, initially agency side with Simpson Carpenter and then Incite, and more recently three years as a freelance consultant. I have been using Q for five years and would be happy to help with any aspect of your Q project.

CONTACT Emma
Jared Bothwell
Wellington, New Zealand
PublicVoice
Import and clean data
Advanced analysis
Visualization and reporting
Another pair of hands

Hello. I've been working in the research industry since 2004 and using Q since 2016.

My focus is working with public opinion and consultation data using qualitative, quantitative and mixed methods approaches. Find out more at www.publicvoice.co.nz

CONTACT Jared
Lucy de Canha
Western Cape, South Africa
Apex Market Research
Import and clean data
Advanced analysis
Visualization and reporting
Another pair of hands

Insight Driven

M.Sc in Mathematical Statistics and Honours in Actuarial Science.
8 years analytical experience in Market Research
Founder of ApexMR

Passion to find effective solutions to enhance customer experience and to help create the holistic experience every business strives towards.

CONTACT Lucy
Morris Wilburn
Georgia, United States
Advanced Customer Analytics
Advanced analysis

Skilled in MaxDiff. Advanced design skills; see my article https://www.quirks.com/articles/improving-your-max-diff-data. Can produce analysis results at the total sample level or individual level. See my website https://www.advancedcustomeranalytics.com.

Contact me at: info@advancedcustomeranalytics.com

CONTACT Morris
Nathan Reed
Victoria, Australia
NR
Import and clean data
Advanced analysis
Visualization and reporting
Another pair of hands

After 8 years at global leaders Nielsen and OMD I have spent the last 5 years as an independent researcher. A natural storyteller, I am here to help bring your data to life and communicate it in a way that is easy for your organisation to understand and act upon.

CONTACT Nathan
Nicola Scott
New South Wales, Australia
Nicola Scott Consulting
Import and clean data
Visualization and reporting
Another pair of hands

Highly experienced Insights Consultant and Research Director with 15 years experience in the industry. Here to help find the insights, visualise those insights and prepare an engaging, straight-forward and meaningful story using Q.
Happy to be an extra pair of hands to support your research team.

CONTACT Nicola
Paul Di Marzio
Victoria, Australia
Di Marzio Research
Import and clean data
Visualization and reporting
Another pair of hands

I've been using Q software to do survey research analysis for the last 5 years. Can assist with data processing survey files into a reader friendly format showing results by total sample and segment. Happy to collaborate and will generally charge an hourly rate to be determined by the need.

CONTACT Paul
Ronda Pinkerman
South Dakota, United States
Marketing Revelations
Import and clean data
Advanced analysis
Visualization and reporting
Another pair of hands

Seasoned expert in marketing research (+25 years) that thrives on taking the ugly out of data and making it into something beautiful. Any question can be answered, any need fulfilled, and any problem solved. Let me help you make a difference in this world. Thanks!

CONTACT Ronda
Paul Crooke
Oxfordshire, United Kingdom
Import and clean data
Advanced analysis
Visualization and reporting
Another pair of hands

Hello

I am Paul and I have been working agency side big/small and client side for 15 years. This has enabled me produce visually engaging presentations of advanced analysis output.

Please contact me to find out more. I look forward to hearing from you.

Paul

CONTACT Paul
Kate Shahan
New York, United States
Self
Import and clean data
Advanced analysis
Visualization and reporting

I have been working as a professional researcher for the past 7 years, over which I have developed an extensive research & analysis skillset.

My areas of expertise methodologies from the fields of design, economics, psychology, demography, and traditional market research.

CONTACT Kate
Sven Radcke
London, United Kingdom
www.surveydatatables.co.uk
Import and clean data
Advanced analysis
Visualization and reporting
Another pair of hands

Experienced Data Analyst who specialise in cross-tabs and statistical analysis. Previous experience working with clients in automotive, FMCG, healthcare and finance.

I've established Survey Data Tables, offering data analysis services on a freelance basis.

www.surveydatatables.co.uk

CONTACT Sven
Zeeshan Qureshi
Ontario, Canada
Nielsen
Import and clean data
Advanced analysis
Visualization and reporting
Another pair of hands

I have over 5 years of experience in the field of Marketing Research and Consulting in various industries across various geographies

Most recent professional position held-
Senior Research Analyst - Nielsen (Sept 14 - Mar 2018)

Highest Education qualification-
MBA (Marketing) from MET college

CONTACT Zeeshan
Add profile  |  Edit profile

Are you a Q expert interested in doing freelance work?

ADD YOUR PROFILE
close-link