MSM 6633 Excel Homework 3: Correlations Thirty students in TROY's MSM program took a personality profile with the following results. You need to create a correlation matrix to conduct a feedback session. Calculate bivariate correlations for all possible pairs of subscales (except "ID"). Round each correlation coefficient to two (2) decimal places EQ 118 120 118 119 131 156 118 123 135 103 125 106 108 125 137 SE 134 113 120 94 124 120 148 104 137 141 156 91 125 ID LMX TMX 001 164 143 002 143 132 003 137 123 004 139 125 OOS 123 131 006 134 154 007 134 131 008 136 118 009 124 010 94 126 011 131 115 012 129 106 013 144 111 014 137 146 015 111 136 016 112 132 017 136 124 018 126 127 019 146 141 020 140 126 021 97 91 022 136 134 023 134 119 024 109 132 025 110 97 026 132 120 027 128 111 028 162 142 029 114 110 030 109 120 130 NART 133 134 124 119 113 142 109 116 112 107 130 143 140 106 112 133 TQ 118 110 105 131 105 104 144 118 136 109 124 119 109 117 140 128 123 117 123 117 120 131 136 137 124 111 119 135 116 112 BESEE TL 138 105 117 131 140 121 113 125 134 111 128 115 127 119 106 106 132 120 139 153 117 119 132 109 108 133 127 141 117 122 CL nAch Pow 122 127 121 127 95 131 101 132 120 152 104 156 110 107 102 126 90 133 129 150 140 130 124 126 119 125 129 123 133 112 146 143 137 100 106 110 98 131 122 121 137 101 133 99 133 112 128 143 139 143 111 151 143 106 149 136 112 127 117 117 129 118 140 108 133 127 128 138 115 96 119 99 106 112 146 100 128 163 114 146 105 126 109 151 121 152 90 115 131 117 147 133 134 82 123 123 130 115 150 108 141 116 102 95 120 111 118 142 113 113 129 125 126 115 106 108 100 100 112 119 111 140 122 127 142 125 117 101 116 128 127 122 134 138 96 KEY (all scale scores normed to emulate the 10 scale to simplify comparisons) ID Respondent serial number EQ Emotional intelligence LMX Leader-member exchange IQ Intelligence quotient TMX Team member exchange TL Transformational leadership SE Self-efficacy CL Charismatic leadership nach Need for achievement nPow Need for power naff Need for affiliation