- #1
DaveC426913
Gold Member
- 22,793
- 6,504
I've acquired data on about 14,000 users who participated in my questionnaire. I have their questionnaire answers (98 questions, rated 1 to 5) as well as some user demographic data such as gender, age and honesty.
It's all sitting in a mySQL database on my webhost. I can write some queries on it, and I can export it to one of many formats (OpenDoc Calc or simply CSV), but I'm a bit overwhelmed about how I might extract all the useful, interesting information from it.
My initial queries filter out incomplete questionnaires and dummy users. Then I can filter on gender by age:
This gets me the number of male users in their 20's.
But this is going to get tedious. Additionally, I want to display these results visually using graphs. (I've tried to figure out OpenDoc Calc's graphing feature but it's not going well.)
I know there are a million ways to do what I want, but I'd like your opinions on how to do it easily. Basic is better than advanced. I don't plan to do too much fancy manipulation.
It's all sitting in a mySQL database on my webhost. I can write some queries on it, and I can export it to one of many formats (OpenDoc Calc or simply CSV), but I'm a bit overwhelmed about how I might extract all the useful, interesting information from it.
My initial queries filter out incomplete questionnaires and dummy users. Then I can filter on gender by age:
Code:
SELECT COUNT(*) FROM `Users` WHERE `Completed` = 7 AND `Dummy` IS NULL AND `Gender`= 1 AND `Age` = 2
But this is going to get tedious. Additionally, I want to display these results visually using graphs. (I've tried to figure out OpenDoc Calc's graphing feature but it's not going well.)
I know there are a million ways to do what I want, but I'd like your opinions on how to do it easily. Basic is better than advanced. I don't plan to do too much fancy manipulation.