JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser .
Find Correlation between ICP Score and Client Won
Hello! my colleague has created an ICP score, which is a score that sales creates in order define the quality of a client. I am trying to find the correlation between the Score and whether we won the client or not. IF I change 'Closed Won' to '1' and 'Closed Lost' to '0' and completed a 'correlation' from the data analysis toolpak, would this sufficient?
Stage ICP Score Stage ICP Score Closed Won 0.77 Closed Lost 0.77 Closed Won 0.77 Closed Lost 0.77 Closed Won 0.77 Closed Lost 0.77 Closed Won 0.77 Closed Lost 0.77 Closed Won 2.69 Closed Lost 0.77 Closed Won 2.69 Closed Lost 0.77 Closed Won 7.31 Closed Lost 0.77 Closed Won 7.69 Closed Lost 0.77 Closed Won 0.77 Closed Lost 0.77 Closed Won 0.77 Closed Lost 0.77 Closed Won 0.77 Closed Lost 0.77 Closed Won 1.15 Closed Lost 0.77 Closed Won 1.15 Closed Lost 0.77 Closed Won 1.92 Closed Lost 0.77 Closed Won 1.92 Closed Lost 0.77 Closed Won 6.15 Closed Lost 0.77 Closed Won 6.15 Closed Lost 0.77 Closed Won 1.15 Closed Lost 0.77 Closed Won 2.69 Closed Lost 0.77 Closed Won 4.23 Closed Lost 0.77 Closed Won 4.23 Closed Lost 0.77 Closed Won 5 Closed Lost 0.77 Closed Won 0.77 Closed Lost 0.77 Closed Won 1.15 Closed Lost 0.77 Closed Won 5.77 Closed Lost 0.77 Closed Won 5.77 Closed Lost 0.77 Closed Won 6.92 Closed Lost 0.77 Closed Won 6.92 Closed Lost 0.77 Closed Won 1.92 Closed Lost 0.77 Closed Won 1.92 Closed Lost 0.77 Closed Won 5.38 Closed Lost 0.77 Closed Won 5 Closed Lost 1.15 Closed Won 3.85 Closed Lost 2.69 Closed Won 8.08 Closed Lost 0.77 Closed Won 8.08 Closed Lost 3.08 Closed Won 5.38 Closed Lost 3.08 Closed Won 3.46 Closed Lost 2.31 Closed Won 6.92 Closed Lost 5.38 Closed Won 6.92 Closed Lost 3.46 Closed Won 5.77 Closed Lost 0.77 Closed Won 5.77 Closed Lost 1.92 Closed Won 2.69 Closed Lost 1.92 Closed Won 5.77 Closed Lost 2.69 Closed Won 1.54 Closed Lost 4.23 Closed Won 5 Closed Lost 1.92 Closed Won 2.31 Closed Lost 6.15 Closed Won 3.46 Closed Lost 2.69 Closed Won 0.77 Closed Lost 2.31 Closed Won 5 Closed Lost 3.85 Closed Won 5 Closed Lost 2.69 Closed Won 3.85 Closed Lost 3.46 Closed Won 1.92 Closed Lost 3.08 Closed Won 1.92 Closed Lost 1.15 Closed Won 2.69 Closed Lost 2.31 Closed Won 4.62 Closed Lost 2.31 Closed Won 5 Closed Lost 1.92 Closed Won 1.15 Closed Lost 1.92 Closed Won 2.69 Closed Lost 1.15 Closed Won 5.38 Closed Lost 5.77 Closed Won 5.38 Closed Lost 2.69 Closed Won 5.38 Closed Lost 1.15 Closed Won 0.77 Closed Lost 0.77 Closed Won 6.92 Closed Lost 1.92 Closed Won 5 Closed Lost 5 Closed Won 1.54 Closed Lost 5.77 Closed Won 2.69 Closed Lost 1.54 Closed Won 2.69 Closed Lost 1.92 Closed Won 2.69 Closed Lost 1.92 Closed Won 2.69 Closed Lost 0.77 Closed Won 0.77 Closed Lost 0.77 Closed Won 0.77 Closed Lost 9.23 Closed Won 1.92 Closed Lost 1.54 Closed Won 6.54 Closed Lost 1.15 Closed Won 1.54 Closed Lost 5 Closed Won 1.54 Closed Lost 3.46 Closed Won 1.15 Closed Lost 3.08 Closed Won 0.77 Closed Lost 3.08 Closed Won 0.77 Closed Lost 1.92 Closed Won 5.77 Closed Lost 6.92 Closed Won 5.77 Closed Lost 1.92 Closed Won 3.85 Closed Lost 3.85 Closed Won 3.08 Closed Lost 3.85 Closed Won 1.92 Closed Lost 3.85 Closed Won 2.31 Closed Lost 3.08 Closed Won 2.31 Closed Lost 3.46 Closed Won 5.38 Closed Lost 2.69 Closed Won 1.15 Closed Lost 5.38 Closed Won 2.69 Closed Lost 0.77 Closed Won 0.77 Closed Lost 2.69 Closed Won 3.46 Closed Lost 5.77 Closed Won 5 Closed Lost 1.92 Closed Won 0.77 Closed Lost 0.77 Closed Won 1.54 Closed Lost 2.69 Closed Won 3.08 Closed Lost 1.54 Closed Won 3.46 Closed Lost 1.54 Closed Won 6.92 Closed Lost 0.77 Closed Won 1.54 Closed Lost 6.15 Closed Won 8.08 Closed Lost 8.85 Closed Won 6.15 Closed Lost 3.85 Closed Won 0.77 Closed Lost 5 Closed Won 1.54 Closed Lost 6.15
Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
I think this will do it. There is a low correlation here.
MrExcel posts20.xlsx D E F G H 4 correleation 0.2569 5 r-squared 0.0660 6 7 Stage Stage (binary) ICP Score 8 Closed Won 1 0.77 9 Closed Won 1 0.77 10 Closed Won 1 0.77 11 Closed Won 1 0.77 12 Closed Won 1 2.69 13 Closed Won 1 2.69 14 Closed Won 1 7.31 15 Closed Won 1 7.69 16 Closed Won 1 0.77 17 Closed Won 1 0.77 18 Closed Won 1 0.77 19 Closed Won 1 1.15 20 Closed Won 1 1.15 21 Closed Won 1 1.92 22 Closed Won 1 1.92 23 Closed Won 1 6.15 24 Closed Won 1 6.15 25 Closed Won 1 1.15 26 Closed Won 1 2.69 27 Closed Won 1 4.23 28 Closed Won 1 4.23 29 Closed Won 1 5 30 Closed Won 1 0.77 31 Closed Won 1 1.15 32 Closed Won 1 5.77 33 Closed Won 1 5.77 34 Closed Won 1 6.92 35 Closed Won 1 6.92 36 Closed Won 1 1.92 37 Closed Won 1 1.92 38 Closed Won 1 5.38 39 Closed Won 1 5 40 Closed Won 1 3.85 41 Closed Won 1 8.08 42 Closed Won 1 8.08 43 Closed Won 1 5.38 44 Closed Won 1 3.46 45 Closed Won 1 6.92 46 Closed Won 1 6.92 47 Closed Won 1 5.77 48 Closed Won 1 5.77 49 Closed Won 1 2.69 50 Closed Won 1 5.77 51 Closed Won 1 1.54 52 Closed Won 1 5 53 Closed Won 1 2.31 54 Closed Won 1 3.46 55 Closed Won 1 0.77 56 Closed Won 1 5 57 Closed Won 1 5 58 Closed Won 1 3.85 59 Closed Won 1 1.92 60 Closed Won 1 1.92 61 Closed Won 1 2.69 62 Closed Won 1 4.62 63 Closed Won 1 5 64 Closed Won 1 1.15 65 Closed Won 1 2.69 66 Closed Won 1 5.38 67 Closed Won 1 5.38 68 Closed Won 1 5.38 69 Closed Won 1 0.77 70 Closed Won 1 6.92 71 Closed Won 1 5 72 Closed Won 1 1.54 73 Closed Won 1 2.69 74 Closed Won 1 2.69 75 Closed Won 1 2.69 76 Closed Won 1 2.69 77 Closed Won 1 0.77 78 Closed Won 1 0.77 79 Closed Won 1 1.92 80 Closed Won 1 6.54 81 Closed Won 1 1.54 82 Closed Won 1 1.54 83 Closed Won 1 1.15 84 Closed Won 1 0.77 85 Closed Won 1 0.77 86 Closed Won 1 5.77 87 Closed Won 1 5.77 88 Closed Won 1 3.85 89 Closed Won 1 3.08 90 Closed Won 1 1.92 91 Closed Won 1 2.31 92 Closed Won 1 2.31 93 Closed Won 1 5.38 94 Closed Won 1 1.15 95 Closed Won 1 2.69 96 Closed Won 1 0.77 97 Closed Won 1 3.46 98 Closed Won 1 5 99 Closed Won 1 0.77 100 Closed Won 1 1.54 101 Closed Won 1 3.08 102 Closed Won 1 3.46 103 Closed Won 1 6.92 104 Closed Won 1 1.54 105 Closed Won 1 8.08 106 Closed Won 1 6.15 107 Closed Won 1 0.77 108 Closed Won 1 1.54 109 Closed Lost 0 0.77 110 Closed Lost 0 0.77 111 Closed Lost 0 0.77 112 Closed Lost 0 0.77 113 Closed Lost 0 0.77 114 Closed Lost 0 0.77 115 Closed Lost 0 0.77 116 Closed Lost 0 0.77 117 Closed Lost 0 0.77 118 Closed Lost 0 0.77 119 Closed Lost 0 0.77 120 Closed Lost 0 0.77 121 Closed Lost 0 0.77 122 Closed Lost 0 0.77 123 Closed Lost 0 0.77 124 Closed Lost 0 0.77 125 Closed Lost 0 0.77 126 Closed Lost 0 0.77 127 Closed Lost 0 0.77 128 Closed Lost 0 0.77 129 Closed Lost 0 0.77 130 Closed Lost 0 0.77 131 Closed Lost 0 0.77 132 Closed Lost 0 0.77 133 Closed Lost 0 0.77 134 Closed Lost 0 0.77 135 Closed Lost 0 0.77 136 Closed Lost 0 0.77 137 Closed Lost 0 0.77 138 Closed Lost 0 0.77 139 Closed Lost 0 0.77 140 Closed Lost 0 1.15 141 Closed Lost 0 2.69 142 Closed Lost 0 0.77 143 Closed Lost 0 3.08 144 Closed Lost 0 3.08 145 Closed Lost 0 2.31 146 Closed Lost 0 5.38 147 Closed Lost 0 3.46 148 Closed Lost 0 0.77 149 Closed Lost 0 1.92 150 Closed Lost 0 1.92 151 Closed Lost 0 2.69 152 Closed Lost 0 4.23 153 Closed Lost 0 1.92 154 Closed Lost 0 6.15 155 Closed Lost 0 2.69 156 Closed Lost 0 2.31 157 Closed Lost 0 3.85 158 Closed Lost 0 2.69 159 Closed Lost 0 3.46 160 Closed Lost 0 3.08 161 Closed Lost 0 1.15 162 Closed Lost 0 2.31 163 Closed Lost 0 2.31 164 Closed Lost 0 1.92 165 Closed Lost 0 1.92 166 Closed Lost 0 1.15 167 Closed Lost 0 5.77 168 Closed Lost 0 2.69 169 Closed Lost 0 1.15 170 Closed Lost 0 0.77 171 Closed Lost 0 1.92 172 Closed Lost 0 5 173 Closed Lost 0 5.77 174 Closed Lost 0 1.54 175 Closed Lost 0 1.92 176 Closed Lost 0 1.92 177 Closed Lost 0 0.77 178 Closed Lost 0 0.77 179 Closed Lost 0 9.23 180 Closed Lost 0 1.54 181 Closed Lost 0 1.15 182 Closed Lost 0 5 183 Closed Lost 0 3.46 184 Closed Lost 0 3.08 185 Closed Lost 0 3.08 186 Closed Lost 0 1.92 187 Closed Lost 0 6.92 188 Closed Lost 0 1.92 189 Closed Lost 0 3.85 190 Closed Lost 0 3.85 191 Closed Lost 0 3.85 192 Closed Lost 0 3.08 193 Closed Lost 0 3.46 194 Closed Lost 0 2.69 195 Closed Lost 0 5.38 196 Closed Lost 0 0.77 197 Closed Lost 0 2.69 198 Closed Lost 0 5.77 199 Closed Lost 0 1.92 200 Closed Lost 0 0.77 201 Closed Lost 0 2.69 202 Closed Lost 0 1.54 203 Closed Lost 0 1.54 204 Closed Lost 0 0.77 205 Closed Lost 0 6.15 206 Closed Lost 0 8.85 207 Closed Lost 0 3.85 208 Closed Lost 0 5 209 Closed Lost 0 6.15
Thank you! I appreciate it!
Threads
1,221,525
Messages
6,160,329
Members
451,637
Latest member
hvp2262