Complex Analysis

[Loris]

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.

 

[Belgian]

Hi,

For my former employer I made a complete buziness analisis, and it seems you
don't need acces for there is not a lot of data. Maybee you could get me a
comy and let me have a look for U

 

[Mike Middleton]

Loris -

If the results are arranged as a standard database (one employee per row,
one column per "statement" and one column per "core skill"), you could use a
pivot table to descriptively summarize any pair of results (a "statment"
versus a "core skill") as frequencies in a "cross tabulation" table.

For inferential statistics, you could use the chi-square test of
independence. Excel does not automate calculation of expected frequencies,
but it does provide the CHITEST function for calculating the prob-value.

- Mike
http://www.mikemiddleton.com