
1. Re: Correlation between categorical variables
Patrick A Van Der Hyde May 22, 2014 9:29 AM (in response to Susan Baier)Thanks for the post. Would you have a workbook with this data or example data? and an idea of what you are trying to show the dimensions in relation to?
 Thanks
Patrick

2. Re: Correlation between categorical variables
KK Molugu May 22, 2014 10:15 AM (in response to Susan Baier)Susan:
If you are trying to check the relationship between two categorical variables (and not scatter plot), you can create 'Highlight Tables'. You need a measure to compare the relationship, such as, count of records, etc.
OR
You can create numerical equivalents from the categorical variables (male = 1, female = 2), etc. and plot them to see the relationship.
Not a statistician, but my 2 cents..
Hope this helps..
..kk

3. Re: Correlation between categorical variables
Jonathan Drummey May 24, 2014 4:22 AM (in response to Susan Baier) 
4. Re: Correlation between categorical variables
Eric Patterson Nov 24, 2014 11:36 AM (in response to Susan Baier)I may be hijacking this thread a bit but I have a similar question in producing correlation comparisons between search terms based on a time series for the count of each individually search query.
I have read Jonathan Drummey and Bora Beran posts to get very close. The issue I appear to be having is the refactoring into a time series. I used a string interpretation of the date field for the variable dimension but since I have to filter by index to get one value per cell, it is using the first date.
In reality my first objective is to find the best matching search trend to bacon. Then my final objective is to phase shift bacon forward in time to once again find the best matching trend as a predictor item to bacon. I have attached a packaged workbook (see sheet "Correlation Matrix" with a subset of data to work with easier.

DocSearchQueryAnalysis.twbx 66.3 KB
