Coding Ordinal Variables in Sheets Using Nested IF Statements

Part of a series on preparing Google Forms survey data for analysis in Jamovi. This video provides a step-by-step guide to transforming an ordinal variable into numbered values in Google Sheets using nested IF statements, using a socioeconomic status variable as an example. It also explains why this transformation is necessary for ordinal variables but not for nominal variables. When you are done cleaning your data, download your Google Sheet to a .CSV by going to File -- Download -- Comma Separated Values (.csv). DO NOT USE EXCEL. Then open your .CSV file in jamovi: https://youtu.be/putvHX5HGmw. You will create total scores in jamovi, unless you are categorizing data with subscale means and IF statements. Other Videos in this Playlist: Linking Google Forms to Sheets: https://youtu.be/Z4AXfXrjW44 Data Cleaning Best Practices in Sheets: https://youtu.be/KEJbp16pIds Naming Variables in Sheets (for uploading to Jamovi): https://youtu.be/sb6SMcsq7wI Transforming Informed Consent & Eligibility Variables in Sheets: https://youtu.be/_LxyUR9Qbik Cleaning “Other” Gender Responses in Sheets: https://youtu.be/QWMya7Rdq14 Scoring Likert-Type Text Responses in Sheets: https://youtu.be/83uZzuG15lo Reverse Scoring Likert-Type Numeric Responses in Sheets: https://youtu.be/ulZjUuJbn_o Calculating Subscale Means in Sheets with IF Statements: https://youtu.be/DeXATQM0P0Y Categorizing Data with Subscale Means and IF Statements: https://youtu.be/3wXHMArX0Ck