Age group

User Support
1

Hi Team,

I need example when i input respondent actual age it automatically fill the banded age category ,ie when i put the actual is 23 the i get code 1 the category age when i pt 36 i get code 3-see below

1 18-24
2 25-35
3 36 -45

Thanks,
Edward

2

Hi Edward,
The best way to do that is during analysis rather than in the form itself. You can do that easily in Excel or SPSS or whatever you’re using. In Excel, a nested =IF() formula would easily slice your age values into any category you need.

Using calculates (an additional hidden question type) would also make this possible by creating a complex IF…THEN statement directly in the XML. See here: https://groups.google.com/forum/#!topic/kobo-users/RfWwfH6lpDg

Hope this helps,

Tino

···

On Tue, Feb 11, 2014 at 2:16 AM, Ombuna Edward ombun...@gmail.com wrote:

Hi Team,

I need example when i input respondent actual age it automatically fill the banded age category ,ie when i put the actual is 23 the i get code 1 the category age when i pt 36 i get code 3-see below

1 18-24
2 25-35
3 36 -45

Thanks,
Edward

–

You received this message because you are subscribed to the Google Groups “Kobo Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+...@googlegroups.com.

To post to this group, send email to kobo-...@googlegroups.com.

Visit this group at http://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/groups/opt_out.

3

Alternatively, you can make your single select question have age ranges in the text labels, but record values 1,2,3.

In KoBoForm, that would look like this:

Inline image 1

The XML ends up looking like this:

​

<h:body>




1



2



3


</h:body>

​

​In the final form in KoBoCollect, the user will be presented with labels showing age ranges, and they can select a range. The values 1,2,3 will be recorded in the database. The only disadvantage here is that you will not know the user’s EXACT age, you will only know the range. Otherwise, this is a simple and easy solution.​

​~Neil​

···

☞§※☼:airplane::open_umbrella::slight_smile:

~Neil

On Tue, Feb 11, 2014 at 11:50 AM, Tino Kreutzer tino.k...@gmail.com wrote:

Hi Edward,
The best way to do that is during analysis rather than in the form itself. You can do that easily in Excel or SPSS or whatever you’re using. In Excel, a nested =IF() formula would easily slice your age values into any category you need.

Using calculates (an additional hidden question type) would also make this possible by creating a complex IF…THEN statement directly in the XML. See here: https://groups.google.com/forum/#!topic/kobo-users/RfWwfH6lpDg

Hope this helps,

Tino

–

You received this message because you are subscribed to the Google Groups “Kobo Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+...@googlegroups.com.

To post to this group, send email to kobo-...@googlegroups.com.

Visit this group at http://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/groups/opt_out.

On Tue, Feb 11, 2014 at 2:16 AM, Ombuna Edward ombun...@gmail.com wrote:

Hi Team,

I need example when i input respondent actual age it automatically fill the banded age category ,ie when i put the actual is 23 the i get code 1 the category age when i pt 36 i get code 3-see below

1 18-24
2 25-35
3 36 -45

Thanks,
Edward

–

You received this message because you are subscribed to the Google Groups “Kobo Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+...@googlegroups.com.

To post to this group, send email to kobo-...@googlegroups.com.

Visit this group at http://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/groups/opt_out.

4

Hi Team,

Thanks, i use Spss alot , its only that i wanted to save time for me and interviewers doing it, anyway thanks for your answers .

···

On Tue, Feb 11, 2014 at 7:50 PM, Tino Kreutzer tino.k...@gmail.com wrote:

Hi Edward,
The best way to do that is during analysis rather than in the form itself. You can do that easily in Excel or SPSS or whatever you’re using. In Excel, a nested =IF() formula would easily slice your age values into any category you need.

Using calculates (an additional hidden question type) would also make this possible by creating a complex IF…THEN statement directly in the XML. See here: https://groups.google.com/forum/#!topic/kobo-users/RfWwfH6lpDg

Hope this helps,

Tino

–

You received this message because you are subscribed to a topic in the Google Groups “Kobo Users” group.

To unsubscribe from this topic, visit https://groups.google.com/d/topic/kobo-users/gBXPFIVgcFk/unsubscribe.

To unsubscribe from this group and all its topics, send an email to kobo-users+...@googlegroups.com.

To post to this group, send email to kobo-...@googlegroups.com.

Visit this group at http://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/groups/opt_out.

On Tue, Feb 11, 2014 at 2:16 AM, Ombuna Edward ombun...@gmail.com wrote:

Hi Team,

I need example when i input respondent actual age it automatically fill the banded age category ,ie when i put the actual is 23 the i get code 1 the category age when i pt 36 i get code 3-see below

1 18-24
2 25-35
3 36 -45

Thanks,
Edward

To post to this group, send email to kobo-...@googlegroups.com.

Visit this group at http://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/groups/opt_out.

–

You received this message because you are subscribed to the Google Groups “Kobo Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+...@googlegroups.com.