Excel 2019 - I have a sheet which shows customers and what products they have bought. I am looking to see correlations. For example, if the customer owns product A, then the correlation shows that they most likely will own product C and F, etc....
I have this working, but I am seeing that there is directionality to the data... For example, (made up example) if a customer owns a car, then they also own tires, (so 100% correlation), but if they own tires, then they only sometimes may own a car (20% correlation). There is only one intersection of car/tires on the matrix/grid/sheet that the correlation creates.
I tried copying my data and transposing it, seeing if that did anything, but it did not help...
What do I need to do so that I can look at the data BOTH cars then tires, as well as tires, then cars? Is correlation the wrong function to use?
question from:
https://stackoverflow.com/questions/65851698/can-excel-show-directionality-in-correlation 与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
