1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Analyzing frequency of co-occurrence

I am working on some qualitative analysis of post-secondary course offerings in a nationwide scan. I have a spreadsheet listing a large number of courses in an academic discipline. In one of my columns, I've listed three or four themes or keywords relevant to the course. I've already used unpivot in Power Query to put each theme on its own line, and then used a pivot table from this to calculate how often each theme occurs. But I'm having trouble taking my analysis to the next level.

I want to analyze how often themes occur together. For example, how often does the theme "business acumen" appear on the same line as "venture capital". Which themes never appear together? The courses included in my scan all have unique identifiers so I'm hoping this will help.

I'd really like to be able to visualize the co-occurrence of themes, but I'm not sure where to start. I am having trouble Googling solutions because I'm not sure what vocabulary to use.

submitted by /u/thousandtrees
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#enterprise-level spreadsheet solutions
#conversational data analysis
#AI-driven spreadsheet solutions
#no-code spreadsheet solutions
#data analysis tools
#rows.com
#natural language processing for spreadsheets
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#digital transformation in spreadsheet software
#Excel compatibility
#large dataset processing
#business intelligence tools
#collaborative spreadsheet tools
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#AI-powered spreadsheet
#Excel alternatives
Analyzing frequency of co-occurrence