Correlation Per Item/ID [SOLVED]

willgouldin
willgouldin New Altair Community Member
edited November 5 in Community Q&A
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

Answers

  • MariusHelf
    MariusHelf New Altair Community Member
    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