Identify the correlation coefficient for the following: Look at the four categor
ID: 3127956 • Letter: I
Question
Identify the correlation coefficient for the following:
Look at the four categories below.Take a guess at which two variables will yield the highest correlation coefficient.
2. Transaction and Traffic
3. Transaction and OppVol
4. Transactions and Sales
Name Gender Sales Transactions Traffic UPT OppVol A. Leaderis m 1701 55 111 6.02 784 B. Wilson m 2255 55 91 7.03 64 C. McMillion f 2113 88 162 5.8 173 D. Arias m 2211 101 186 6.33 257 E. Browning f 1699 55 93 6.52 34 I. McClean m 1526 50 130 5.82 618 J. Brown f 2144 62 103 5.64 31 J. Dixon f 2441 96 182 6.03 1050 J. Santiago m 1283 105 162 7.03 895 L. Endsoy m 2552 86 162 6.43 861 L. Thompson m 1966 70 216 6.28 147 L. Wheeler m 2113 76 130 5.64 32 M. Clarke f 1095 104 182 6.51 259 M. Davis f 2311 81 93 6.28 52 M. Mayo f 2533 82 186 5.69 30 M. Merrill f 1657 57 103 6.33 102 M. Scott m 2795 109 216 5.64 1316 P. Worlda f 1357 67 130 6.22 159 R. Haug f 1756 72 186 6.81 132 S. Miller f 2579 77 216 6.02 951 S. Reda m 1652 95 111 6.62 258 S. Teagle f 1573 60 117 5.56 456 T. Hags f 1107 69 182 6.71 357 V. Totalier m 2352 71 117 5.56 874 Z. Terrell f 1382 51 100 6.22 25Explanation / Answer
By using excel->Data->Data Analysis->Correlation, the correlation table is shown below:
from the above table, the correlation between:
2. Transaction and Traffic is 0.5957
3. Transaction and OppVol is 0.3957
4. Transactions and Sales is 0.2645
Transaction and Traffic have highest correlation coefficient.
Sales Transactions Traffic UPT OppVol Sales 1 Transactions 0.2645 1 Traffic 0.2561 0.5957 1 UPT -0.4175 0.0899 -0.0188 1 OppVol 0.3209 0.3957 0.4128 -0.1883 1