I have one categorical independent variable and one interval dependent variable. I want to determine if there is any association between the two. Is correlation appropriate? If so, which correlation (Pearson, spearman, others?) and which of these is associated with the CORREL function in Excel. How do I do it in excel?