I surveyed a group of employees using 12 statements to which they could
respond: Strongly agree, somewhat agree, no opinion, somewhat disagree, and
strongly disagree. I then gave the same employees a skills test rating them
on a scale of 0 to 3 on 11 core skills. I need to see if there is a
correlation between any of their responses on the attitude part with their
demonstrated skills on any of the core skills. Can Excel do that kind of
analysis and, if so, I would appreciate any suggestions as to which functions
I could use or which features would best work on such an undertaking; or
would Access be the better tool.