ExcelBanter - How do I set up a correlation table?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I set up a correlation table? (https://www.excelbanter.com/excel-discussion-misc-queries/19225-how-do-i-set-up-correlation-table.html)

rh555

How do I set up a correlation table?

I am working with survey results. I need a correlation table that represents
the data taken.

dlw

excel has the CORREL function

Michael R Middleton

rh555 -

I am working with survey results. I need a correlation table that
represents the data taken. <

A) CORREL worksheet function

B) Correlation tool of the Analysis ToolPak add-in

- Mike
www.mikemiddleton.com

All times are GMT +1. The time now is 10:28 AM.