Google Sheets Tools to Delve Into AI-coded Sentiment Analysis Data
#googlesheets #smartchips #spreadsheetskills #qualitativeanalysis
Starting with qualitative workshop feedback comments coded as positive, neutral, or negative by AI, we can use Google Sheets Tools to delve into that coded data more and answer questions.
Slides: https://docs.google.com/presentation/...
Demo Sheet - Make a Copy to Follow Along: https://docs.google.com/spreadsheets/...
0:00 Intro
0:49 Pivot Tables
4:39 Vlookup to combine data sets
8:15 Vlookup to add 1, 0, -1 to quantify sentiments
11:20 Quick Numbers for easy average score
11:54 Pivot Table with date group for average score over time
14:03 Chart average score over time