Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Danijel
Partner - Creator III
Partner - Creator III

Calculate T-Test

Hello all,

I would like to determine the critical T-value. Qlik offers some functions, but so far I have not found the right one.
https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Stati...


Based on this table:
https://people.richland.edu/james/lecture/m170/tbl-t.html

I have the data "df" and the "Conf. Level" one tail, now I need a function that gives me the value "2.365" for the combination of df (e.g. 7) and Conf. Level (e.g. 95%).

In MS there is a function:

Excel T.INV Function (excelfunctions.net)

Does anyone have an idea for me?

Thank you.

Labels (1)
1 Solution

Accepted Solutions
Danijel
Partner - Creator III
Partner - Creator III
Author

Hello again,

have discovered by random the following function, which does exactly what I need.

TINV - script and chart function ‒ Qlik Sense on Windows

I'll leave reply to the thread and mark it as solved in case anyone happens to have the same problem.

View solution in original post

1 Reply
Danijel
Partner - Creator III
Partner - Creator III
Author

Hello again,

have discovered by random the following function, which does exactly what I need.

TINV - script and chart function ‒ Qlik Sense on Windows

I'll leave reply to the thread and mark it as solved in case anyone happens to have the same problem.