Correlation Per Item/ID [SOLVED]

willgouldin

I have data as follows:

Item    Condition     Units
a         10               100
a         15               150
a         13               130
b         10               340
b         15               450

etc

I am attempting to see the correlation between Condition and Units Per Item.



When I run the Correlation Matrix against the existing data, the output is the gross correlation btw conditions and units.

Is there an operator I should use to "group" the correlation operator?

Thank you!


Will

MariusHelf

You can use the Loop Values operator to loo over the items and create a correlation matrix for each item on its own.
Be sure to use Filter Examples inside of Loop Values to select only the matching items. Process breakpoints will be a great help when designing such a process for the first time.


Best regards,
Marius