Statistical Analysis :S

[adolf hamster]

Have you done that manually?

i had to get the categories manually, given you have the original list of options you'll be able to put the full list in instead (i was going by the responses)

the numbers are from formulas, more as a flavour of what can be done/ways of doing it, the same general idea can be applied to the other categories you had in the original questionnaire.

edit: should clarify it's all on the second sheet, the first sheet is your original data.

 

[LOAM]

looks pretty feasable for many of the columns.

had a go just with a few options (age, gender, activity):
https://drive.google.com/file/d/1Qf81s-v_NiOj7Y8KC97YJJrh9N37ypRp/view?usp=sharing

not the prettiest method, but it's just an example of how you could go splitting up the strings of text into something that you can make comparisons with.

Apologies i was parked up on phone when I first saw that and didn't realise what you had done, so much thanks. I can butcher that to deal with more or less every question by creating a new tab for each one and adjusting the targets etc

 

[adolf hamster]

Apologies i was parked up on phone when I first saw that and didn't realise what you had done, so much thanks. I can butcher that to deal with more or less every question by creating a new tab for each one and adjusting the targets etc

that was the plan

hopefully that does what you need it to.

 

[Ugley_Matt]

Before you do anything, you need to have some questions that you want answers too. Then you cans start to either reshape or visualise the data.

For example, what % of people do exercise during lunch,