Categorizing Data with Subscale Means and IF Statements

Part of a series on preparing Google Forms survey data for analysis in Jamovi, and the follow-up to the subscale means video. This video walks through how to use nested IF statements in Google Sheets to create a categorical variable from subscale means, using the Adult Attachment Scale (Collins & Read, 1990) as an example. 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 Coding Ordinal Variables in Sheets Using Nested IF Statements: https://youtu.be/uvZhwPHCfoI 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/65R2ECY5x5M