- Posts: 30
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Array questions - save every subitem in database to calculate mean
- evaluation2023
- Topic Author
- Offline
- Junior Member
Less
More
5 months 2 weeks ago #252020
by evaluation2023
PHP Version 8.0.28
Version 5.6.4+230206
Array questions - save every subitem in database to calculate mean was created by evaluation2023
Please help us help you and fill where relevant:
Your LimeSurvey version: 6.2.11
Own server or LimeSurvey hosting: self
Survey theme/template:
==================
Hi,
I have 5 Array questions:
The scale is from Codes 1-6 (very good, good, poor, very poor, ...)
Now I want to get the mean of every single Item in the statistics output.
So I created 5 questions with type "equation" and entered "{A_1} in "equation1" and so on...
When I click on "statistics" unfortunately I don't get the statistics-view
Any Ideas how I can get the mean of every single Item in statistics?
Your LimeSurvey version: 6.2.11
Own server or LimeSurvey hosting: self
Survey theme/template:
==================
Hi,
I have 5 Array questions:
- "How do you like the taste of the coffee?" (Code A_1)
- "How do you ...?" (Code A_2)
- "The XXX...." (Code A_3)
- "The offer ...." (Code A_4)
- "Last question .... ABC" (Code A_5)
The scale is from Codes 1-6 (very good, good, poor, very poor, ...)
Now I want to get the mean of every single Item in the statistics output.
So I created 5 questions with type "equation" and entered "{A_1} in "equation1" and so on...
When I click on "statistics" unfortunately I don't get the statistics-view
Any Ideas how I can get the mean of every single Item in statistics?
PHP Version 8.0.28
Version 5.6.4+230206
Please Log in to join the conversation.
- Joffm
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12940
- Thank you received: 3979
5 months 2 weeks ago #252021
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Array questions - save every subitem in database to calculate mean
So, you have one array question (A) with five subquestions (1,2,3,4,5)?
Now LimeSurvey can not calculate a mean here, because there might be alphanumerical codes.
But you know that in numerical questions the mean, top boxes, etc. are displayed.
So you may create a "multiple numerical" question (hidden), where you pipe the answers of your array.
Best you enter them into the default answers.
Then you see this
Joffm
Now LimeSurvey can not calculate a mean here, because there might be alphanumerical codes.
But you know that in numerical questions the mean, top boxes, etc. are displayed.
So you may create a "multiple numerical" question (hidden), where you pipe the answers of your array.
Best you enter them into the default answers.
Then you see this
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The following user(s) said Thank You: evaluation2023
Please Log in to join the conversation.
- evaluation2023
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 30
- Thank you received: 0
5 months 2 weeks ago #252024
by evaluation2023
PHP Version 8.0.28
Version 5.6.4+230206
Replied by evaluation2023 on topic Array questions - save every subitem in database to calculate mean
Thank you very much, that was the breakthrough. For non-experts without a statistics program, it is now possible to carry out surveys and generate the results themselves. Quite a good solution, I think this should appear as a tip somewhere in the documentation.
PHP Version 8.0.28
Version 5.6.4+230206
Please Log in to join the conversation.
- Joffm
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12940
- Thank you received: 3979
5 months 2 weeks ago #252025
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Array questions - save every subitem in database to calculate mean
Without a statistic program?
There are so many free options:
PSPP, Jasp, Jamovi, or OpenOffice/LibreOffice.
You see, now you know the mean.
And now? The mean itself doesn't give a real insight.
I suppose you want to know if differences between the 5 items are statistically significant.
Or whether there are significant differences between groups of respondents (men vs. women, young vs. old, ...).
Means, you have to calculate at least dependent and independent t-tests, k-tests, ANOVAs, and some more).
Joffm
There are so many free options:
PSPP, Jasp, Jamovi, or OpenOffice/LibreOffice.
You see, now you know the mean.
And now? The mean itself doesn't give a real insight.
I suppose you want to know if differences between the 5 items are statistically significant.
Or whether there are significant differences between groups of respondents (men vs. women, young vs. old, ...).
Means, you have to calculate at least dependent and independent t-tests, k-tests, ANOVAs, and some more).
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Please Log in to join the conversation.
- evaluation2023
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 30
- Thank you received: 0
5 months 2 weeks ago #252026
by evaluation2023
PHP Version 8.0.28
Version 5.6.4+230206
Replied by evaluation2023 on topic Array questions - save every subitem in database to calculate mean
The person who needed that feature just reports the mean. That’s not my cup of tea.
And those kind of users don’t want to calculate the mean or install other software… they just want to see the results and no deeper statistics.
And those kind of users don’t want to calculate the mean or install other software… they just want to see the results and no deeper statistics.
PHP Version 8.0.28
Version 5.6.4+230206
Please Log in to join the conversation.