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

Analyzing frequency of co-occurrence

Our take

Analyzing the co-occurrence of themes in your post-secondary course offerings can provide valuable insights into how different concepts are interrelated. By examining how often themes like "business acumen" appear alongside "venture capital," you can uncover patterns that inform curriculum development and highlight interdisciplinary connections. To visualize these relationships effectively, consider using network diagrams or heatmaps, which can illustrate the frequency of co-occurrence. With unique identifiers for each course, you have a solid foundation for deeper analysis.

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]

Read on the original site

Open the publisher's page for the full experience

View original article