Home » Topics »

Rows and Columns, Part 1 - Jump-starting Analysis Using Spreadsheets

By Michael A. Morgan In this first installment of my series “Rows and Columns,” I’ll describe how to use some very powerful tools of spreadsheets that can make analyzing your UX research data much easier. For those who have been reluctant to use spreadsheets during analysis, this series is for you, and you’ll hopefully find this information useful. For those of you who have expertise in using spreadsheets, some of this information might be review. The central part of any UX research project is the analysis of data. This task can be both satisfying and cumbersome at the same time. As you go through your data, you might become excited as you recognize emerging patterns or see great variations across participants. However, getting to the point at which you can easily see such trends can be quite difficult. Your data must be in a format that affords easy filtering, so you can decipher the various rows and columns across participants. Part 1 of this series covers the following features of spreadsheets, which can facilitate your understanding of the data you’ve gathered: filters form elements such as checkboxes and drop-down lists Read More

Visit site »