Skip to main content

Analyze Your Findings

Learning Objectives

After completing this module, you’ll be able to:

  • Collate your results.
  • Use a spreadsheet to organize your results.
  • Analyze your results to identify trends, commonalities, and differences.

Finding the Gold Needles in Your Data Haystack

In the previous unit you learned how to observe and interview your users. In this unit, you’ll learn how to collate the data you’ve recorded in written form and look through it to identify any trends, commonalities, and differences across the users you interviewed.

Collate Your Results

Let’s think about how your results might be collated after you’ve recorded and perhaps transcribed them.

If you used a separate note taker during your interviews, it’s important to go through their notes and make sure you understand what’s been written. This is a good step to take even if you were both interviewer and note taker. You’ll likely need to return to your session recordings to verify some parts of the notes.

Having checked through the findings for each of your users, you can now pull them together into a spreadsheet. Yes, a spreadsheet. Spreadsheets let you scan across your users’ responses to each of the questions, especially if you’ve organized it well.

Collating Your Results

Working with Your Data Spreadsheet

As you scan through your spreadsheet, look for both overall consensus and differences in responses from user to user. Spreadsheets help you easily scan your results. And they help you share your data with other team members who might have also been taking notes during your interviews. As a guide for best practices, we’ve included a snapshot of a spreadsheet so you can see what your data might look like (check out the resources section of this module for a template version of sample data).

Screen Shot of Sample Spreadsheet

Create Order from Data Chaos

Now that you’ve consolidated all of your notes into your handy-dandy spreadsheet, you can begin to create order from the sea of data before you. Yes, it may look daunting, but you know that each bit of information comes from a user who gifted you their time to help identify a solution to your problem. So it’s up to you to use that data well. You can start by noting responses that might come across as positive, negative, or unsure in their sentiment.

Color coding these responses according to the sentiment can help when you scan across the tab, for example green for positive, red for negative, and yellow for unsure.

Analyzing Your Results

Carla uses this approach to see if there are any trends, commonalities, or interesting differences. She uses distinguishing colors to represent the positive and negative trends and interesting patterns. She knows to look for the following elements in her data:

  •  Commonalities and trends—words, sentiments, phrases, or ideas that seem to appear often across user’ responses.
  •  Interesting differences—sentiments that stand out in a given response or that appear to be in contrast to a phrase or sentiment in another response.

She also found some similarities across the results and color coded them like a pro:

  • Orange = Time/Busy
  • Purple = Information availability
  • Blue = Product needs more description and photos/images
  • Bolded Text = suggestions from participants, additional fields needed, see more images, and so on

Her color-coded spreadsheet of findings is in the resources section for you to use too!

Mapping Solutions to Your Research

But wait, there’s one last step. We still need to map the trends, commonalities, and differences to potential  solutions.  Yes, actual recommendations to change things. Now you might be thinking that you’re not a developer and you don’t know what’s feasible, so how can you recommend a solution? It’s a risky venture to put your research out there, but to put it out in the wild without having clear next steps as to how all your hard work can be used would be a half-finished job (and we know you’re a closer).

Don’t worry we’ve got your back!

Your Magic Solution Finder

Take each of the trends you’ve discovered and map them to the commonalities and differences you’ve identified. Chances are there are clear groupings of feedback from your users that point to a pretty clear solution. You can even take the time, yes that again, to sync up with your team members and see if they might have a great solution to some of the trends you’ve seen.

Once you’ve mapped your trends, commonalities, and differences to solutions—then you have all of the elements you need to build your story. We’ll get to that in our final unit.

Carla has uncovered some clear trends in her analysis and is eager to map them to solutions. She identified a host of trends that provide a frame for the recommendations and clearly associated solutions:

Trend Commonality/Difference Recommendations
1. There are three roles:
  •  Managers with a more strategic role
  •  Senior sales assistants who support managers, manage junior sales assistants, and track sales and inventory
  •  Junior sales assistants who work the floor and make sales
n/a n/a
2. Junior sales assistants don’t have much time because the shop floor is always busy. Cited 3 times
  • Add more images (consider adding a video if relevant) on third screen to make it easy to scan.
  • Add more detail on the product description, such as:
    • How the product can be used in different ways
3. Junior sales assistants need to have quick access to all relevant product information. Cited 5 times
4. Junior sales assistants want the product details to be easily digestible in the new product. Cited 4 times
5. Junior sales assistants are looking forward to trying out the new product. Cited 6 times
  • Build for the junior sales assistants first, then build functionality for the senior sales assistant
6. Senior sales assistants are cautious about the product possibly being a distraction on the shop floor. Cited 3 times

Now, finally, Carla is done with the analysis of her data. But she’s not done with her work. We need to take all of this information and make a story—one that’s compelling enough to provoke her audience to act on her recommendations.


  • Download the UX Research Basics Pack:
    • Raw results template to enter in participant details and results
    • Results template with sample data
    • Results template showing how to color-coded sample data
Keep learning for
Sign up for an account to continue.
What’s in it for you?
  • Get personalized recommendations for your career goals
  • Practice your skills with hands-on challenges and quizzes
  • Track and share your progress with employers
  • Connect to mentorship and career opportunities