Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi -
I have been working with the LinEst formulas in Qlik Sense to create various Linear regression models.
I am looking for the formula to calculate the P-value of a given variable.
Any thoughts ?? Happy 2022 - Jerry
Hi - Any thoughts on the P-Value formula ? Jerry
may be try this:
sum(aggr(pow(fabs(Value - avg(total Value)), 2), Value))/count(Value)
Hi -
Thank you for the response. The x variable is [Ind-L-H-Estab]
sum(aggr(pow(fabs([Ind-L-H-Estab]- avg(total [Ind-L-H-Estab])), 2), [Ind-L-H-Estab]))/count([Ind-L-H-Estab])
The formula above resulted in a very high value. I am not sure it is accurate - thoughts ? Jerry
Hi -
Thank you for the response. The x variable is [Ind-L-H-Estab]
sum(aggr(pow(fabs([Ind-L-H-Estab]- avg(total [Ind-L-H-Estab])), 2), [Ind-L-H-Estab]))/count([Ind-L-H-Estab])
The formula above resulted in a very high value. I am not sure it is accurate - thoughts ? Jerry