Quote:
|
Originally Posted by starwest
The improvements are great, especially the 'Questions Grid'. One glaring problem, however, is the inability to export the results into a format that's usable. It may be difficult to do with the questions grid, so perhaps a slightly different solution is in order for questions thank rank satisfaction numerically (1 to 10 or otherwise), but simply telling us what percentage of respondents replied to such a question is pointless. Another possibly solution would be the ability to assign a numeric value to each column and use that for further analysis (which would work well if someone wanted to use 'neutral', 'satisfied', etc. in place of numeric values).
I'm not sure I'm making my point clearly, so here's an example. I setup the following question:
"How satisfied are you with each of the following aspects of your purchase from mydomain.com?"
Product Availability - 1 2 3 4 5 6 7 8 9 10
Order Tracking/Status Info - 1 2 3 4 5 6 7 8 9 10
On-Time Delivery - 1 2 3 4 5 6 7 8 9 10
Each of the numbers is represented by a radio button, and the numbers are listed once along the top as a key. I can now create this question using Survey Builder, which is a great improvement. When I look at the results in the survey admin I can see how many times each specific radio-button was selected. However, if I want to export those results from the survey admin, so that I can actually make sense of them (ex: take an average, or look at the mean), the exported data only tells me the percentage of responses each ROW received (ie: they all show at 20% if you have 5 rows and respondents select a rating for each of the 5 rows). Preferably, I would be able to see some statistical information in Survey Builder, but I would definitely settle for a working export function.
See the attached images of both the survey admin and the export file.
|
I see what you mean.
Thank you for bringing this to my attention.
There are several aspects of this question:
1. You can also check CondensedSpreadsheet export - it has grid, stored as x/y values, listed one by one.
2. Export formats - we support industry-common formats, that are supported by major players in survey world. Most of them are later processed by some systems programmatically, not manually. (SPSS is good example of such software)
Especially for this purpose there are XML-based formats.
There are no simple way of storing set of values (matrix) as a single value, each way will have some trade-off.
3. Questions Grid and it's export
Lets think about it as matrix - x (horizontal), y (vertical) scales.
X can be different types of values,
1. can be numbers 1-10 (as in your example)
In this case exporting average value makes sense
2. can be set of words (Variant 1, Variant 2, Variant 3 etc) - where you can select only 1 (1 variant). In this case exporting selected one makes sense (no way to make average of few strings)
3. Can be multi-select options, i.e. you can select more than 1 Y value per each row(X).
Example - X - list of features, Y - list of products.
In this case it makes sense to export all selected values for each row (X).
Now - lets assume we need summary of this (as in your example)
Each of these 3 types requires little different summary formats.
We will think about improving this export function, key thing here is that we aren't first who faced this task and it makes sense to use existing formats, not create new own one.
I will place update notification here when this improvement will be implemented.
I welcome your other improvement suggestions.