# Finding a correlation or statistically significant relationship in data

I have a data set that is represented below, but much longer. How can I find if there is a statistical relationship between business category and business score?

Business Name     Business Category        Business Score


Given that business is categorical, you can't use correlation.

Business score looks like it is a 1-5 rating or something like that. If that is the case, I would recommend ordinal logistic regression In SAS use PROC LOGISTIC. In R there is polr. The dependent variable would be "score" and the independent variable "type of business".

• The OP appears to use the term "correlation" in the nontechnical sense of a "relationship." A constructive way to interpret that is that it's a request to identify significant differences in score among business categories.
– whuber
Mar 12, 2014 at 16:14
• Hi, I guess I should not have used the term correlation. I am only looking for a significant relationship between business category and business score. Does the above answer still satisfy this? Mar 12, 2014 at 16:17
• Yes it does. Do you know how to do it? Mar 12, 2014 at 17:15
• @PeterFlom I believe so? I imported the arm package and the data and did this: x <- polr(Business.Category ~ Score, data = data). Then I did summary(x) and got this output, pastebin.com/sBGg1xEG, although I'm not really sure what to make of it. Mar 12, 2014 at 18:34
• @PeterFlom Also, are there any other descriptive statistics I can show on x that would show a significant relationship, maybe p-value or r-squared? Mar 12, 2014 at 18:50

I think you can try a simple Chi-square test. Make a frequency table of "Business Category" vs "Business Score" and then go for a chi square test. I don't have R in this PC. Later I will post some code.