Hello. I have responses to a questionnaire about fruit and veg consumption, and basically I want to look at how each individual's responses group into quartiles across each category.
The questionnaire consisted of about 100 questions, but I have summarised them into categories and calculated scores according to the response (and hence it is all quantitative data), e.g. Positive attitudes towards fruit & veg; frequency of F&V consumption; diversity of F&V consumption. I would like to analyse whether people are consistent across the categories, i.e. are those in the highest/lowest quartile for attitudes towards F&V also in the highest/lowest quartile for frequency and diversity of consumption. I have looked at the data on excel and colour coded each quartile for each category, so I can see visually that some people track consistently within a quartile, and others less consistently. But I would like a more mathematical way of doing this.
Any advice would be greatly appreciated! I've been searching all day and come up with nothing.
Thanks
Jen
The questionnaire consisted of about 100 questions, but I have summarised them into categories and calculated scores according to the response (and hence it is all quantitative data), e.g. Positive attitudes towards fruit & veg; frequency of F&V consumption; diversity of F&V consumption. I would like to analyse whether people are consistent across the categories, i.e. are those in the highest/lowest quartile for attitudes towards F&V also in the highest/lowest quartile for frequency and diversity of consumption. I have looked at the data on excel and colour coded each quartile for each category, so I can see visually that some people track consistently within a quartile, and others less consistently. But I would like a more mathematical way of doing this.
Any advice would be greatly appreciated! I've been searching all day and come up with nothing.
Thanks
Jen