Is there a way to rank based on R squared value?

Steve-DOMOnoob
Steve-DOMOnoob Member
in Magic ETL

i'm looking to see if there is a way to rank based on the increasing trend (R squared).

i.e. the greater the increase over a set period the higher the rank.

image.png

Thanks, Steve.

Answers

  • MichelleH
    MichelleH Coach

    @Steve-DOMOnoob What specifically are you trying to rank? R-Squared is just a single value for a regression model.

  • Steve-DOMOnoob
    Steve-DOMOnoob Member

    Hi @MichelleH, I was aiming to use the R-squared value to rank the increase in trend over a set period. i.e. if one variable had an R-squared value of 0.9 and another 0.2 then they would be ranked 1st and 2nd respectively.

    There possibly might be a better way to do this that i'm not aware of.

  • MichelleH
    MichelleH Coach

    @Steve-DOMOnoob Can you please share an anonymized data sample?

Categories