{"id":43317,"date":"2018-11-26T11:44:19","date_gmt":"2018-11-26T06:14:19","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=43317"},"modified":"2018-11-27T09:37:49","modified_gmt":"2018-11-27T04:07:49","slug":"qlik-sense-statistical-distribution-functions","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlik-sense-statistical-distribution-functions\/","title":{"rendered":"Qlik Sense Statistical Distribution Functions With Syntax"},"content":{"rendered":"

1. Objective<\/span><\/h2>\n

Earlier, we have discussed the Qlik Sense General Numeric Function<\/strong><\/a>. In this Qlik Sense tutorial<\/a><\/strong>, we are going to learn about various Statistical Distribution Functions used in Qlik Sense. So, we can use these statistical distribution functions both in data load script and in chart expressions. Moreover, different statistical functions are used to get values which represent different states of individual value points in the data distribution.<\/span><\/p>\n

\"Qlik<\/a>

Qlik Sense Statistical Distribution Functions With Syntax<\/p><\/div>\n

So, let’s start the Qlik Sense Statistical Distribution Functions tutorial.<\/p>\n

2. Qlik Sense Statistical Distribution Functions<\/h2>\n

i. CHIDIS\u00a0Function<\/span><\/h3>\n

This function returns the probability of a one-tailed chi<\/span>2<\/span> distribution. The chi<\/span>2<\/span> distribution is obtained by conducting the chi<\/span>2<\/span> test on the set of values. <\/span><\/p>\n

Syntax:<\/strong><\/p>\n

CHIDIST(value, degrees_freedom)<\/pre>\n
Where, <\/span>value<\/span> is the for which you want to know the probability in the distribution. This value must always be positive.<\/span><\/p>\n
Recommended Reading<\/strong> – Qlik Sense Time Zone Functions<\/a><\/strong><\/p>\n
degrees_freedom<\/span> is a positive integer value specifying the degree of freedom for the given value. <\/span><\/p>\n
For example,<\/strong><\/p>\n
CHIDIST(8, 15)<\/span> returns <\/span>0.9238<\/span> as the probability of a particular Chi<\/span>2<\/span> distribution with the value given as 8 and degree of freedom being 15. <\/span><\/p>\n
ii. CHIINV Function<\/span><\/h3>\n
This function works in contraction to the CHIDIST function as this function returns the value of a chi2 distribution provided the probability and degree of freedom in the expression. <\/span><\/p>\n
Syntax:<\/strong><\/p>\n
CHIINV(prob, degrees_freedom)<\/pre>\n
Where <\/span>prob<\/span> is the probability of occurrence of a value in chi2 distribution. Probability is always a value between 0 and 1. <\/span><\/p>\n
degrees_freedom<\/span> is a positive integer value specifying the degree of freedom for the given value. <\/span><\/p>\n
For example,<\/strong> <\/span><\/p>\n
CHIINV(0.9237827, 15)<\/span> function returns <\/span>8.0000<\/span> as the value for which probability is 0.9238. This function is exactly the inverse of the CHIDIST function as CHIDIST returns the probability of a given value and CHIINV returns the value for a given probability. <\/span><\/p>\n
iii. FDIST Function<\/span><\/h3>\n
This function returns the probability of a value in F-distribution. <\/span><\/p>\n
Syntax:<\/strong><\/p>\n
FDIST(value, degrees_freedom1, degrees_freedom2)<\/pre>\n
Where <\/span>value<\/span> is the distribution value for which you want to calculate the probability. <\/span><\/p>\n
The degree of freedom is a fraction value so there are two parameters required for it to be calculated.<\/span><\/p>\n
First is the <\/span>degrees_freedom1<\/span> which is the numerator and second is <\/span>degrees_freedom2<\/span> which is the denominator. <\/span><\/p>\n
For example,<\/strong> <\/span><\/p>\n
FDIST(15, 8, 6)<\/span> returns <\/span>0.0019<\/span> as the probability of the value 15 with the degree of freedom being 8\/6.<\/span><\/p>\n
You must read Qlik Sense Table Functions<\/a><\/strong><\/p>\n
iv. FINV<\/span><\/h3>\n
FINV is the inverse of FDIST. This function evaluates the probability given for a particular value in F-distribution and returns the value. <\/span><\/p>\n
Syntax:<\/strong><\/p>\n
FINV(prob, degrees_freedom1, degrees_freedom2)<\/pre>\n
Where, <\/span>prob<\/span> is the probability of occurrence of a value in F-distribution. Probability is always a value between 0 and 1. <\/span><\/p>\n
The degrees of freedom is a fraction value so there are two parameters required for it to be calculated.<\/span><\/p>\n
First is the <\/span>degrees_freedom1<\/span> which is the numerator and second is <\/span>degrees_freedom2<\/span> which is the denominator. <\/span><\/p>\n
For example,<\/strong> <\/span><\/p>\n
FINV( 0.0019369, 8, 6)<\/span> returns <\/span>15.0000<\/span> as the value having the probability 0.0019369 in the F-distribution. <\/span><\/p>\n
v. NORMDIST<\/span><\/h3>\n
This function evaluates the cumulative normal distribution probability from the given value, mean and standard deviation values. Although, this function will return the standard normal distribution value if you put mean=0 and standard deviation=1. <\/span><\/p>\n
Syntax:<\/strong><\/p>\n
NORMDIST(value, mean, standard_dev)<\/pre>\n
Where, <\/span>value<\/span> is the value for which you want the function to evaluate the normal distribution.<\/span><\/p>\n
Let’s revise Qlik Sense Formatting Functions<\/a><\/strong><\/p>\n
Mean<\/span> is the arithmetic mean of the distribution.<\/span><\/p>\n
Standard_dev<\/span> is the standard deviation for the distribution and is a positive value. <\/span><\/p>\n
For instance,<\/strong><\/p>\n
NORMDIST(0.5, 0, 1)<\/span> returns <\/span>0.6915<\/span> as the standard normal distribution for the value 0.5 as the mean is 0 and sd is 1. <\/span><\/p>\n
vi. NORMINV<\/span><\/h3>\n
The NORMINV function is the inverse of NORMDIST function. The function evaluates the probability, mean and standard deviation values of a normal distribution and returns the associated value for the given probability. <\/span><\/p>\n
Syntax:<\/strong><\/p>\n
NORMINV(prob, mean, standard_dev)<\/pre>\n
Where, <\/span>prob<\/span> is the probability of occurrence of a value in normal distribution. Probability is always a value between 0 and 1. <\/span><\/p>\n
Mean<\/span> is the arithmetic mean of the distribution.<\/span><\/p>\n
Standard_dev<\/span> is the standard deviation for the distribution and is a positive value. <\/span><\/p>\n
For example,<\/strong> <\/span><\/p>\n
NORMINV(0.6914625, 0, 1) returns 0.5000 which is the value for the probability 0.6914625. <\/span><\/p>\n
vii. TDIST<\/span><\/h3>\n
This function evaluates a T-value from a Student\u2019s T-distribution and returns the probability for the occurrence of that value. <\/span><\/p>\n
Syntax:<\/strong><\/p>\n
TDIST(value, degrees_freedom, tails)<\/pre>\n
Where, <\/span>value<\/span> is the T value for which probability has to be calculated for the distribution.<\/span><\/p>\n
degrees_freedom<\/span> is the value specifying the degree of freedom. This value is a positive integer. <\/span><\/p>\n
tails<\/span> is the value specifying whether it is a one-tailed or two-tailed distribution. Use 1 for one-tailed and 2 for two-tailed distribution.<\/span><\/p>\n
You must check Qlik Sense Treemap Visualizations<\/a><\/strong><\/p>\n
For example,<\/strong><\/p>\n
TDIST(1, 30, 2)<\/span> returns <\/span>0.3253<\/span> as the probability for the t-value 1. <\/span><\/p>\n
viii. TINV<\/span><\/h3>\n
This function is just the inverse of the TDIST function. It takes in the probability corresponding to a t-value and returns the t-value. <\/span><\/p>\n
Syntax:<\/strong><\/p>\n
TINV(prob, degrees_freedom)<\/pre>\n
Where, prob is the probability of occurrence of a t-value in student\u2019s t-distribution. Probability is always a value between 0 and 1.<\/span><\/p>\n
degrees_freedom is the value specifying the degree of freedom. This value is a positive integer.<\/span><\/p>\n
For example,<\/strong> <\/span><\/p>\n
TINV(0.3253086, 30)<\/span> returns <\/span>1.0000<\/span> as the t-value having the probability 0.3253086.<\/span><\/p>\n
So, this was all in Qlik Sense Statistical Distribution Functions. Hope you like our explanation.<\/p>\n
3. Conclusion<\/span><\/h2>\n
Hence, these were all the important Qlik sense Statistical Distribution Functions applied to statistical distribution values. One thing must always be kept in mind, which is that only numeric values should be entered into the function expression to obtain a result. If you enter a non-numeric value, then the function will return NULL.<\/span><\/p>\n
Still, if you any query regarding Qlik Sense Statistical Distribution Functions ask in the comment tab.<\/p>\n
See also –\u00a0<\/strong><\/p>\n
Qlik Sense Conditional Functions<\/a><\/strong><\/p>\n
Reference for Qlik Sense\u00a0<\/a><\/strong>
1. Objective Earlier, we have discussed the Qlik Sense General Numeric Function. In this Qlik Sense tutorial, we are going to learn about various Statistical Distribution Functions used in Qlik Sense. So, we can...<\/p>\n","protected":false},"author":6,"featured_media":43372,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17408],"tags":[17730,17731],"class_list":["post-43317","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlik-sense-tutorials","tag-qlik-sense-statistical-distribution-functions","tag-statistical-distribution-function"],"yoast_head":"\nQlik Sense Statistical Distribution Functions With Syntax - DataFlair<\/title>\n<meta name=\"description\" content=\"Qlik Sense Statistical Distribution Functions, CHIDIS, CHINV, FDIST, FINV, NORMDIST, NORMINV, TDIST, TINV, syntax, example\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-statistical-distribution-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Qlik Sense Statistical Distribution Functions With Syntax - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Qlik Sense Statistical Distribution Functions, CHIDIS, CHINV, FDIST, FINV, NORMDIST, NORMINV, TDIST, TINV, syntax, example\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlik-sense-statistical-distribution-functions\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-26T06:14:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-27T04:07:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Statistical-Distribution-Functions-01-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Qlik Sense Statistical Distribution Functions With Syntax - DataFlair","description":"Qlik Sense Statistical Distribution Functions, CHIDIS, CHINV, FDIST, FINV, NORMDIST, NORMINV, TDIST, TINV, syntax, example","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/qlik-sense-statistical-distribution-functions\/","og_locale":"en_US","og_type":"article","og_title":"Qlik Sense Statistical Distribution Functions With Syntax - DataFlair","og_description":"Qlik Sense Statistical Distribution Functions, CHIDIS, CHINV, FDIST, FINV, NORMDIST, NORMINV, TDIST, TINV, syntax, example","og_url":"https:\/\/data-flair.training\/blogs\/qlik-sense-statistical-distribution-functions\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-26T06:14:19+00:00","article_modified_time":"2018-11-27T04:07:49+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Statistical-Distribution-Functions-01-1.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-statistical-distribution-functions\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-statistical-distribution-functions\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Qlik Sense Statistical Distribution Functions With Syntax","datePublished":"2018-11-26T06:14:19+00:00","dateModified":"2018-11-27T04:07:49+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-statistical-distribution-functions\/"},"wordCount":942,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-statistical-distribution-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Statistical-Distribution-Functions-01-1.jpg","keywords":["Qlik Sense Statistical Distribution Functions","Statistical Distribution Function"],"articleSection":["Qlik Sense Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-statistical-distribution-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-statistical-distribution-functions\/","url":"https:\/\/data-flair.training\/blogs\/qlik-sense-statistical-distribution-functions\/","name":"Qlik Sense Statistical Distribution Functions With Syntax - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-statistical-distribution-functions\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-statistical-distribution-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Statistical-Distribution-Functions-01-1.jpg","datePublished":"2018-11-26T06:14:19+00:00","dateModified":"2018-11-27T04:07:49+00:00","description":"Qlik Sense Statistical Distribution Functions, CHIDIS, CHINV, FDIST, FINV, NORMDIST, NORMINV, TDIST, TINV, syntax, example","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-statistical-distribution-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-statistical-distribution-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-statistical-distribution-functions\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Statistical-Distribution-Functions-01-1.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Statistical-Distribution-Functions-01-1.jpg","width":1200,"height":628,"caption":"Qlik Sense Statistical Distribution Functions With Syntax"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-statistical-distribution-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Qlik Sense Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/qlik-sense-tutorials\/"},{"@type":"ListItem","position":3,"name":"Qlik Sense Statistical Distribution Functions With Syntax"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/43317","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=43317"}],"version-history":[{"count":5,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/43317\/revisions"}],"predecessor-version":[{"id":43513,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/43317\/revisions\/43513"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/43372"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=43317"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=43317"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=43317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}