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
  • evaluation2023's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
5 months 2 weeks ago #252020 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:
  1. "How do you like the taste of the coffee?" (Code A_1)
  2. "How do you ...?" (Code A_2)
  3. "The XXX...." (Code A_3)
  4. "The offer ...." (Code A_4)
  5. "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
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 months 2 weeks ago #252021 by Joffm
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
 



 

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
  • evaluation2023's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
5 months 2 weeks ago #252024 by evaluation2023
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
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 months 2 weeks ago #252025 by Joffm
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 
 

Volunteers are not paid.
Not because they are worthless, but because they are priceless

Please Log in to join the conversation.

  • evaluation2023
  • evaluation2023's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
5 months 2 weeks ago #252026 by evaluation2023
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.

PHP Version 8.0.28
Version 5.6.4+230206

Please Log in to join the conversation.

Lime-years ahead

Online-surveys for every purse and purpose