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
Watch video Google Sheets Tools to Delve Into AI-coded Sentiment Analysis Data online without registration, duration hours minute second in high quality. This video was added by user DoIT Training at Stony Brook University 29 February 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 294 once and liked it 2 people.