Assuming that you are using a survey asking questions that allow for only nominal categorical answer choices (1,2,3....), what is the best statistical test to analyze the resulting data for a survey with 20 questions in it (some questions have only two answer choices 0 or 1 and some have multiple like 1,2,3...) explain the answer and how to to the testing in Excel?

Years	Environment	Default	2.1	2.2	2.3	2.4	3.1	3.2	3.3	3.4	4.1	4.2	4.3	4.4	5.1	5.2	Honoring DNR	Define Resuscitation	Duration
3	1	1	1	3	5	1	1	1	5	1	1	3	5	1	5	5
1	1	1	4	4	4	4	4	4	4	4	4	4	4	4	2	2
1	2	4	3	3	3	3	2	2	2	2	3	3	3	3	2	2	1	1
1	1	1	3	3	4	3	2	2	4	2	1	1	4	3	2	2	2	3	5
5	1	4	1	1	1	1	1	1	1	1	1	1	1	1	1	2	1	3	6
5	1	4	3	3	3	4	4	4	4	4	4	4	4	4	2	2	2	2	6
5	1	1	1	1	1	1	1	1	1	1	1	1	1	1	5	5	1	1	1
2	1	1	3	3	3	3	2	2	2	2	3	3	3	3	3	7	4	5	6
5	5	4	3	3	3	3	2	2	2	2	3	3	3	3	2	1	1	1	6
5	1	1	3	3	3	3	2	2	2	2	3	3	3	3	2	2	1	2	6
3	1	1	3	3	3	3	3	3	3	3	3	3	3	3	4	4	1	3	6
3	1	1	2	3	5	3	2	2	2	2	2	3	3	2	3	2	2	2	5
3	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	2	2	2	5
4	2	1	1	2	5	1	1	2	5	1	1	1	5	1	2	2	2	1	5
5	1	1	3	3	3	3	2	2	2	2	3	3	3	3	1	1	1	2	6
5	1	4	3	3	3	3	2	2	2	2	3	3	3	3	1	1	2	4	6
2	1	1	3	3	3	3	2	2	2	2	3	3	3	3	2	2	4	5	6
5	1	1	1	3	3	3	4	4	4	4	3	3	3	3	2	2	1	3	1
3	4	4	4	4	5	4	4	2	5	2	4	3	5	3	2	2	1	2	1
4	1	1	1	1	1	2	2	2	2	2	2	1	1	1	2	1	3	2	5
5	1	4	4	4	4	4	4	4	4	4	4	4	4	4	2	1	1	5	6
3	1	4	3	3	3	3	2	2	1	2	3	3	4	3	2	2	1	2	6
2	1	4	1	1	1	2	1	1	1	2	1	1	1	1	2	2	2	2	5
2	1	4	3	3	3	3	2	2	2	2	3	3	3	3	2	1	2	2	5
5	5	1	3	3	3	3	2	2	2	2	3	3	3	3	2	2	1	3	6

Need to check and test for the correlation of any one column of entire table to any other other column of entire table. IE each column must be checked for it's correlation with every other column of the table. Need all the calculations and work to be shown to explain answers obtained and magnitude of significance or correlations found if any.