How do I use the "Correlation" dialog box with multiple ranges?

[Guest]

I'm using data in an Excel 2003 in a workbook, trying to see if there is any
correlation between specific offices in which people work and the length of
time they have been employed, their age the amount of sickleave taken and/or
the amount of sickleave balance they have. I'm attempting to use Data
Analysis and the Correlation dialog box. Although the dialog description
tells me that I can use multiple comparison ranges, I don't see how to do it.
Thanks for any help.

 

[Michael R Middleton]

Paulf6 -

Arrange your data in list (database) format, i.e., names in the top row
(Time Employed, Age, ...) in adjacent columns. Subsequent rows have values
for each person. Choose Tools | Data Analysis | Correlation. Select the
entire list range as the "Input Range."

"Specific offices" is a categorical variable, not numerical, so it should
not be included in the Correlation analysis.

I don't know what you mean by "multiple comparison ranges." I cannot find
that phrase in the dialog box or in Excel's Help.

- Mike
www.mikemiddleton.com

I'm using data in an Excel 2003 in a workbook, trying to see if there is any
correlation between specific offices in which people work and the length of
time they have been employed, their age the amount of sickleave taken and/or
the amount of sickleave balance they have. I'm attempting to use Data
Analysis and the Correlation dialog box. Although the dialog description
tells me that I can use multiple comparison ranges, I don't see how to do
it. Thanks for any help.