Excel formulas from concatenated data

If, like me, you have been trying for ages to create formulas from concatenated data in Excel, then this is the post for you! For those of y...

read more "Excel formulas from concatenated data"

TextJoin function in Excel

Where we have simple requirements, Excel can be very useful for analysing, grouping and clustering survey data. However, to get the most out...

read more "TextJoin function in Excel"

Some thematic analysis resources

Many great resources can be found for qualitative research, but one tool I particularly like is thematic analysis. Two researchers, Braun an...

read more "Some thematic analysis resources"

Formatting times in Excel

I tend to suggest that my students use MS Excel to analyse their qualitative data transcripts. While Excel is not perfect, it has the advant...

read more "Formatting times in Excel"

Stages of data analysis

In a previous post ( here ), I discussed four steps of Schutt's data analysis model. However, in his text, Schutt outlines five steps. ...

read more "Stages of data analysis"

Data wholes and holes

A kaleidoscope metaphor describing one approach to analyzing qualitative data (Suter, 2011, p. 349) I have recently had an undergraduat...

read more "Data wholes and holes"

SurveyMonkey word cloud

This year, SurveyMonkey introduced a word cloud feature that helps researchers to see any similarity in the text responses to open-ended s...

read more "SurveyMonkey word cloud"