class: center, middle, inverse, title-slide .title[ # Survey Data Analysis with {Kobocruncher} ] .subtitle[ ## Session 4 - Setting Crosstabulation ] .author[ ### <a href="https://edouard-legoupil.github.io/kobocruncher/">Link to Documentation</a> – <a href="03-Grouping_Questions.html">Link to Previous Session</a> – <a href="05-Searching_Asssociation.html">Link to Next Session</a> ] .date[ ### Training Content as of 02 November 2023 ] --- ## Cross-tabulation: what is that? When you want to compare the results for one or more variables with the results of another, then you need to cross-tabulate This will allow to examine relationships within the data that might not be readily apparent when only looking at total survey responses. .bg-blue[ Cross tabulation is also a key tool to help identifying data cleaning needs as we will see later ] --- ## Frequent variable used for cross-tabulation Typically cross-tabulation are required for standard disaggregation (i.e. breakdown) variables * Gender of the main respondent * Country of Origin * Area of residence in the country (here you might group together different areas based on frequency to obtain meaningfull representation -see session 7) * Age * Displacement type --- ## How can I crosstabulate questions within my survey? By default the initial exploration report does not include cross-tabulation as it depends on your data: 1. Open the expanded xlsform 2. set up yes in the `disaggregation` column for the variable you want to use for cross-tabulation --- ## What will you get then? Once you regenerate the chart with this new setting in your analysis plan, every single questions will be be presented in additional charts for each `disaggregation` variable .bg-blue[ This setting will automatically inflate considerably the size of your exploration report. You may save you expanded `xlsform` with a new name and adjust your parameters settings so that you can create multiple exploration report exploring different `disaggregation` options Do not forget, at this stage you are exploring your data so that you can select the final charts you want to include in the presentation for the joint data interpretation session ] --- ## What happenned? The function [kobo_cruncher](https://edouard-legoupil.github.io/kobocruncher/reference/kobo_cruncher.html) then loop around all the questions, and in adition of the default simple tabulations, and based on the data types, generate standard charts: * `select_one` simple bar chart with [plot_select_one_cross](https://edouard-legoupil.github.io/kobocruncher/reference/plot_select_one_cross.html) * `select_multiple` bar chart [plot_select_multiple_cross](https://edouard-legoupil.github.io/kobocruncher/reference/plot_select_multiple_cross.html) * `integer` or `numeric` or `date` histogram with [plot_integer_cross](https://edouard-legoupil.github.io/kobocruncher/reference/plot_integer_cross.html) --- class: inverse, center, middle # TIME TO PRACTISE ON YOUR OWN! ### .large[.white[<svg aria-hidden="true" role="img" viewBox="0 0 512 512" style="height:1em;width:1em;vertical-align:-0.125em;margin-left:auto;margin-right:auto;font-size:inherit;fill:currentColor;overflow:visible;position:relative;"><path d="M368.4 18.3L312.7 74.1 437.9 199.3l55.7-55.7c21.9-21.9 21.9-57.3 0-79.2L447.6 18.3c-21.9-21.9-57.3-21.9-79.2 0zM288 94.6l-9.2 2.8L134.7 140.6c-19.9 6-35.7 21.2-42.3 41L3.8 445.8c-3.8 11.3-1 23.9 7.3 32.4L164.7 324.7c-3-6.3-4.7-13.3-4.7-20.7c0-26.5 21.5-48 48-48s48 21.5 48 48s-21.5 48-48 48c-7.4 0-14.4-1.7-20.7-4.7L33.7 500.9c8.6 8.3 21.1 11.2 32.4 7.3l264.3-88.6c19.7-6.6 35-22.4 41-42.3l43.2-144.1 2.8-9.2L288 94.6z"/></svg>] **5 minutes! **] <div class="countdown" id="timer_9c28dd8e" data-update-every="1" data-play-sound="true" tabindex="0" style="right:0;bottom:0;margin:5%;font-size:8em;position: relative; width: min-content;"> <div class="countdown-controls"><button class="countdown-bump-down">−</button><button class="countdown-bump-up">+</button></div> <code class="countdown-time"><span class="countdown-digits minutes">05</span><span class="countdown-digits colon">:</span><span class="countdown-digits seconds">00</span></code> </div> Open your xlsform and fill in the .large[disaggregation] column, save and knit again your report Do not hesitate to raise your questions in the [ticket system](https://github.com/Edouard-Legoupil/kobocruncher/issues/new) or in the chat so the training content can be improved accordingly! --- class: inverse, center, middle ### .large[.white[<svg aria-hidden="true" role="img" viewBox="0 0 512 512" style="height:1em;width:1em;vertical-align:-0.125em;margin-left:auto;margin-right:auto;font-size:inherit;fill:currentColor;overflow:visible;position:relative;"><path d="M256 0a256 256 0 1 1 0 512A256 256 0 1 1 256 0zM232 120V256c0 8 4 15.5 10.7 20l96 64c11 7.4 25.9 4.4 33.3-6.7s4.4-25.9-6.7-33.3L280 243.2V120c0-13.3-10.7-24-24-24s-24 10.7-24 24z"/></svg>] **Let's take a break! **] <div class="countdown" id="timer_cafc0d4d" data-update-every="1" data-play-sound="true" tabindex="0" style="right:0;bottom:0;margin:5%;font-size:8em;position: relative; width: min-content;"> <div class="countdown-controls"><button class="countdown-bump-down">−</button><button class="countdown-bump-up">+</button></div> <code class="countdown-time"><span class="countdown-digits minutes">05</span><span class="countdown-digits colon">:</span><span class="countdown-digits seconds">00</span></code> </div> __Next session__: [05-Searching_Asssociation: beyond the cross-tabulation, it is key to check how variables relate to each other. This can be done with statistical test that verify if variables are significantly associated](05-Searching_Asssociation.html)