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, duration hours minute second in high quality that is uploaded to the channel DoIT Training at Stony Brook University 29 February 2024. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 294 times and liked it 2 visitors.
