Reverse Scoring Likert-Type Numeric Responses in Sheets

Part of a series on preparing Google Forms survey data for analysis in Jamovi. This video provides a step-by-step guide to reverse scoring survey items in Google Sheets, using a depression scale as an example. The reverse scoring calculation works by adding the minimum and maximum possible response values (e.g., 1 + 5 = 6) and subtracting each participant's response. 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 Calculating Subscale Means in Sheets with IF Statements: https://youtu.be/DeXATQM0P0Y Categorizing Data with Subscale Means and IF Statements: https://youtu.be/3wXHMArX0Ck