Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Evaluation of Multiple Option questions in Excel

  • chuckmensch
  • chuckmensch's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 2 months ago #129676 by chuckmensch
Hello everybody!

I finally received the dataset of a collaboration survey. Actually, I thought to compute the data with pivot tables. But the format of the outcome regarding the multiple option questions denies this approach.
Does anyone have an idea how to evaluate this kind of question in Excel? (number of answers = number of columns per question)

Thanks so much!
Eric
The topic has been locked.
  • chuckmensch
  • chuckmensch's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 2 months ago #129707 by chuckmensch
Replied by chuckmensch on topic Evaluation of Multiple Option questions in Excel
EDIT: Or is there still a workflow to be able to use pivot tables in excel in combination with multiple option questions?

Thanks a lot!
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 2 months ago #129740 by holch
I am not quite sure how else you would want the data of multiple option question than one column per option.

How would you need to analyse data? This is the first thing you need to think about and we would need to know, in order to help you.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The following user(s) said Thank You: chuckmensch
The topic has been locked.
  • chuckmensch
  • chuckmensch's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 2 months ago - 8 years 2 months ago #129747 by chuckmensch
Replied by chuckmensch on topic Evaluation of Multiple Option questions in Excel
Hi holch,

thank you for your response.

In order to examine the data with the help of Excels' Pivot Tables, the results of one question has to be in a single column. I want to count several results, look for correlations as well as create diagrams out of the data. Since the column number is about 100 it would be a lot of work to do this without Pivot tables, isn't it?

On the other hand side I am open for new workarounds, but yet I didn't see any to analyze this kind of question in Excel. May you know any?

Thanks again for your help!
Last edit: 8 years 2 months ago by chuckmensch.
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 2 months ago #129756 by tpartner
As Holch point out, how can you have the results for a multiple-choice question in one column? What would that result look like if a respondent selects more than one option?

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The following user(s) said Thank You: chuckmensch
The topic has been locked.
  • chuckmensch
  • chuckmensch's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 2 months ago #129764 by chuckmensch
Replied by chuckmensch on topic Evaluation of Multiple Option questions in Excel
Hi tpartner,

thanks for your help as well!
I created an Excel-File with an example. Is it possible to upload this file?
The topic has been locked.
  • chuckmensch
  • chuckmensch's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 2 months ago #129768 by chuckmensch
Replied by chuckmensch on topic Evaluation of Multiple Option questions in Excel
I admit, it's not a single column, it's two columns: This for example would be a suitable format to analyze the data with pivot tables.

But I am still open for a different approach if this is nonsense what I try to do.

Thanks again!
The topic has been locked.
  • chuckmensch
  • chuckmensch's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 1 month ago #130157 by chuckmensch
Replied by chuckmensch on topic Evaluation of Multiple Option questions in Excel
So am I right, that there is no suitable workaround to analyse LimeSurvey datasets with Microsoft Excel?
The topic has been locked.
  • elissa
  • elissa's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 1 month ago #130160 by elissa
Hi, Excel is also very powerful tool. I would rather think how to reorder the data in Excel with formulas. You may search for something like "table to column".
Cheers
Elisa

Elzbieta Lesinska
LS voluntary Polish translator and supervisor
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose