Linear Regression Modeling - P-Value Formula

[jerryr125]

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

[jerryr125]

Hi - Any thoughts on the P-Value formula ? Jerry

[jyothish8807]

may be try this:

sum(aggr(pow(fabs(Value - avg(total Value)), 2), Value))/count(Value)

[jerryr125]

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

[jerryr125]

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

[jerryr125]

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