topic Finding P-Value in QlikView

Finding P-Value

Anonymous — Thu, 01 Jul 2010 15:25:02 GMT

I am being asked to reproduce a calculation from SQL and have run into a SQL command VPAR which finds the P-Value of a set of numbers. P-Value is supposed to indicate statistical significance, but I cannot find any reference that can help me in Qlikview, nor can I figure out how to calculate the P-Value in general. Does anybody have any clue how to accomplish this? Here is the code I am attempting to reproduce:

SELECT AVG(quantity) AvgQuantity,
(Avg(date * quantity) - Avg(date) * Avg(quantity)) / VarP(date) AS Slope,
power(((1 / (VarP(date) * (Count(date) - 2))) * (VarP(quantity) - power((Avg(date * quantity) - Avg(date) * Avg(quantity)), 2) / VarP(date))), 0.5) AS SE_Slope into #stats
FROM #data

Thanks,

Aaron

Finding P-Value

Thu, 01 Jul 2010 16:59:18 GMT

Here it is:

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

See example in attachment

Re: Finding P-Value

sundarakumar — Wed, 08 Dec 2021 09:57:06 GMT

I know its too late 😄 still adding so that it will be useful for others 🙂

TTest_sig() actually gives you the P value. and it always gives you for two tailed. you can just divide it by 2 to get the equivalent one tail number.