Excel as a Qualitative Data Analysis Tool

Abstract

Qualitative research seeks to examine the interconnections in rich, complex data sources. The statistical tools of quantitative methods separate out pieces of data in a manner that defeats the purpose. But, like quantitative researchers, qualitative researchers often still find themselves overwhelmed by the amount of data and equally in need of tools to extend their human senses. This has led the development of a number of software packages designed for this purpose. An often overlooked option, however, is Microsoft Excel. Excel is generally considered a number cruncher. However, its structure and data manipulation and display features can be utilized for qualitative analysis. In this article, the authors discuss data preparation, analysis, and presentation, including discussion of lesser known features of Excel.

Delivering PACT-Principled Care: Are Specialty Care Patients Being Left Behind?

“…25 Each interview fieldnote was reviewed (by GF, BB, HS); relevant passages were captured in the appropriate dimension and entered into the corresponding cells. A clinic summary was created for each site, which included a summary of clinic perceptions along each of the 35 dimensions, thereby providing a synopsis for each site, representing the range of provider experiences.…”

Using Questioning to Facilitate Discussion of Science Teaching Problems in Teacher Professional Development

“…Analysis was based on the written transcripts, with the video used to examine specific segments. The transcripts were prepared and entered into a spreadsheet for analysis (Meyer & Avery, 2009). The entire turn of each speaker appeared in one row in one spreadsheet with a label for the speaker.…”

Attributes of embodied leadership: A beginning in the next chapter of leadership development

“…This makes the data less prone to superficial interpretation and fragmentation, integrating the data between the researcher and participant construction [8]. There have been similar suggestions from researchers who perform qualitative studies that Excel offers more control when dealing with limited data [33].…”