topic Re: Paired samples t-test Qlik Sense in App Development
https://community.qlik.com/t5/App-Development/Paired-samples-t-test-Qlik-Sense/m-p/1683962#M52089
<P>Leaving this here in case anyone has the same question.</P><P>It appears that at this time Qlik Sense does NOT have a Paired T-Test Capability. Fortunately, the formula for this test is pretty simple. You can first calculate the t value using the Paired T-Test formula located <A href="http://www.sthda.com/english/wiki/t-test-formula#what-is-independent-t-test" target="_self">on this site</A>. Then you can use the <A href="https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Scripting/StatisticalDistributionFunctions/TDIST.htm" target="_self">TDIST()</A> function to calculate your P value.</P><P>This is what your formula in qlik should look like:</P><P>TDIST(FABS(AVG(D))/(FABS(STDEV(D))/SQRT(N)),N-1,2)</P><P>where D is an array of the differences between your groups, and N is your population size.</P><P>Perhaps Qlik Sense has yet to integrate this directly in to their statistical packages because of the simplicity of user-implementation.</P><P>Hope this helps!</P>Wed, 11 Mar 2020 20:14:19 GMTAmarkowitz12020-03-11T20:14:19ZPaired samples t-test Qlik Sense
https://community.qlik.com/t5/App-Development/Paired-samples-t-test-Qlik-Sense/m-p/36311#M2477
<HTML><HEAD></HEAD><BODY><P>I'm looking for some functions in Qlik Sense for executing a paired samples t-test.</P><P>I saw it was possible in Qlik View, but I couldn't find it in Qlik Sense.</P><P></P><P>Has anyone an idea how to execute a paired samples t-test in Qlik Sense?</P></BODY></HTML>Thu, 01 Feb 2018 14:14:20 GMThttps://community.qlik.com/t5/App-Development/Paired-samples-t-test-Qlik-Sense/m-p/36311#M2477kjvdlangemheen2018-02-01T14:14:20ZRe: Paired samples t-test Qlik Sense
https://community.qlik.com/t5/App-Development/Paired-samples-t-test-Qlik-Sense/m-p/1683962#M52089
<P>Leaving this here in case anyone has the same question.</P><P>It appears that at this time Qlik Sense does NOT have a Paired T-Test Capability. Fortunately, the formula for this test is pretty simple. You can first calculate the t value using the Paired T-Test formula located <A href="http://www.sthda.com/english/wiki/t-test-formula#what-is-independent-t-test" target="_self">on this site</A>. Then you can use the <A href="https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Scripting/StatisticalDistributionFunctions/TDIST.htm" target="_self">TDIST()</A> function to calculate your P value.</P><P>This is what your formula in qlik should look like:</P><P>TDIST(FABS(AVG(D))/(FABS(STDEV(D))/SQRT(N)),N-1,2)</P><P>where D is an array of the differences between your groups, and N is your population size.</P><P>Perhaps Qlik Sense has yet to integrate this directly in to their statistical packages because of the simplicity of user-implementation.</P><P>Hope this helps!</P>Wed, 11 Mar 2020 20:14:19 GMThttps://community.qlik.com/t5/App-Development/Paired-samples-t-test-Qlik-Sense/m-p/1683962#M52089Amarkowitz12020-03-11T20:14:19Z