Qlik Sense distribution and Trigonometric and HyperBolic Functions

Last updated on Nov 15 2021
Deepak Gupta

Table of Contents

Qlik Sense distribution and Trigonometric and HyperBolic Functions

i. CHIDIS Function

This function returns the probability of a one-tailed chi2 distribution. The chi2 distribution is obtained by conducting the chi2 test on the set of values.

Syntax:

1. CHIDIST(value, degrees_freedom)

Where, value is that the that you would like to understand the probability within the distribution. This value should be positive.

Recommended Reading – Qlik Sense zone Functions

degrees_freedom may be a positive integer value specifying the degree of freedom for the given value.

For example,

CHIDIST(8, 15) returns 0.9238 because the probability of a specific Chi2 distribution with the worth given as 8 and degree of freedom being 15.

ii. CHIINV Function

This function works in contraction to the CHIDIST function as this function returns the worth of a chi2 distribution provided the probability and degree of freedom within the expression.

Syntax:

1. CHIINV(prob, degrees_freedom)

Where prob is that the probability of occurrence of a worth in chi2 distribution. Probability is usually a worth between 0 and 1.

degrees_freedom may be a positive integer value specifying the degree of freedom for the given value.

For example,

CHIINV(0.9237827, 15) function returns 8.0000 because the value that probability is 0.9238. This function is strictly the inverse of the CHIDIST function as CHIDIST returns the probability of a given value and CHIINV returns the worth for a given probability.

iii. FDIST Function

This function returns the probability of a worth in F-distribution.

Syntax:

1. FDIST(value, degrees_freedom1, degrees_freedom2)

Where value is that the distribution value that you would like to calculate the probability.

The degree of freedom may be a fraction value so there are two parameters required for it to be calculated.

First is that the degrees_freedom1 which is that the numerator and second is degrees_freedom2 which is that the denominator.

For example,

FDIST(15, 8, 6) returns 0.0019 because the probability of the worth 15 with the degree of freedom being 8/6.
You must read Qlik Sense Table Functions

iv. FINV

FINV is that the inverse of FDIST. This function evaluates the probability given for a specific value in F-distribution and returns the worth .

Syntax:

1. FINV(prob, degrees_freedom1, degrees_freedom2)

Where, prob is that the probability of occurrence of a worth in F-distribution. Probability is usually a worth between 0 and 1.

The degrees of freedom may be a fraction value so there are two parameters required for it to be calculated.
First is that the degrees_freedom1 which is that the numerator and second is degrees_freedom2 which is that the denominator.

For example,

FINV( 0.0019369, 8, 6) returns 15.0000 because the value having the probability 0.0019369 within the F-distribution.

v. NORMDIST

This function evaluates the cumulative Gaussian distribution probability from the given value, mean and variance values. Although, this function will return the quality Gaussian distribution value if you set mean=0 and standard deviation=1.

Syntax:

1. NORMDIST(value, mean, standard_dev)

Where, value is that the value that you would like the function to guage the traditional distribution.

Let’s revise Qlik Sense Formatting Functions
Mean is that the first moment of the distribution.

Standard_dev is that the variance for the distribution and may be a positive value.

For instance,

NORMDIST(0.5, 0, 1) returns 0.6915 because the standard Gaussian distribution for the worth 0.5 because the mean is 0 and sd is 1.

vi. NORMINV
The NORMINV function is that the inverse of NORMDIST function. The function evaluates the probability, mean and variance values of a traditional distribution and returns the associated value for the given probability.

Syntax:

1. NORMINV(prob, mean, standard_dev)

Where, prob is that the probability of occurrence of a worth in Gaussian distribution . Probability is usually a worth between 0 and 1.

Mean is that the first moment of the distribution.

Standard_dev is that the variance for the distribution and may be a positive value.

For example,

NORMINV(0.6914625, 0, 1) returns 0.5000 which is that the value for the probability 0.6914625.

vii. TDIST
This function evaluates a T-value from a Student’s T-distribution and returns the probability for the occurrence of that value.

Syntax:

1. TDIST(value, degrees_freedom, tails)

Where, value is that the T value that probability has got to be calculated for the distribution.
degrees_freedom is that the value specifying the degree of freedom. This value may be a positive integer.
tails is that the value specifying whether it’s a one-tailed or two-tailed distribution. Use 1 for one-tailed and a couple of for two-tailed distribution.

You must check Qlik Sense Treemap Visualizations

For example,

TDIST(1, 30, 2) returns 0.3253 because the probability for the t-value 1.

viii. TINV

This function is simply the inverse of the TDIST function. It takes within the probability like a t-value and returns the t-value.

Syntax:

1. TINV(prob, degrees_freedom)

Where, prob is that the probability of occurrence of a t-value in student’s t-distribution. Probability is usually a worth between 0 and 1.

degrees_freedom is that the value specifying the degree of freedom. This value may be a positive integer.

For example,

TINV(0.3253086, 30) returns 1.0000 because the t-value having the probability 0.3253086.

Qlik Sense Trigonometric and Hyperbolic Functions
i. cos() function

It returns the cosine value of x, which may be a number between -1 and 1.
The syntax of cos() function:

1. cos(x)
ii. acos() function
It returns inverse cosine of x, where the worth of x must fulfil the condition -1≤x≥1 and it gives a result between 0 and π.
The syntax of acos() function in Qlik Sense:
1. acos(x)
iii. sin() function
It returns the sine of x, where the resultant value are going to be between -1 and 1.
Do you realize Qlik Sense Mapping Functions
The syntax of sin():
1. sin(x)
iv. asin() function
It returns the inverse sign of x, where the condition -1≤x≤1 must be fulfilled for the worth of x and therefore the result are going to be variety between – π/2 and π/2.
The syntax of asin() function:
1. asin(x)
v. tan() function
This function returns the tangent of x, where the result’s a true number.
The syntax of tan() function in Qlik Sense:
1. tan(x)
vi. atan() function
This function returns the inverse tangent of x, where a result’s variety between – π/2 and π/2.
Let’s revise Qlik Sense Line chart
The syntax of atan() function in Qlik Sense:
1. atan(x)
vii. atan2() function
This function returns the angle between the origin and therefore the point represented by the coordinates x and y. it’s a two-dimensional generalization of the inverse tangent function where a result’s variety between -π and +π.
The syntax of atan2() function:
1. atan2(y,x)
viii. cosh() function
This function returns the hyperbolic cosine of x, where the result’s a true positive number.
The syntax of cosh() function:
1. cosh(x)
ix. sinh() function
This function returns the hyperbolic sine of x, where a result’s a true number.
Let’s discuss Qlik Sense Exponential and Logarithmic Functions
The syntax of sinh() function:
1. sinh(x)
x. tanh() function
This function returns the hyperbolic tangent of x, where the result’s a true number.
The syntax of tanh() function in Qlik Sense:
1. tanh(x)
xi. Sample code
In the sample code given below, we’ve first loaded a table named ‘SampleData’ where a field named ‘Value’ has been loaded. within the next table named ‘Results’, we’ve used all the trigonometric and hyperbolic function that we just learned to require the script to get a table with the trigonometric and hyperbolic values for the given values.
SampleData:
1. LOAD * Inline
2. [Value
3. 0
4. 1];
5. Results:
6. Load *,
7. cos(Value),
8. acos(Value),
9. sin(Value),
10. asin(Value),
11. tan(Value),
12. atan(Value),
13. atan2(Value, Value),
14. cosh(Value),
15. sinh(Value),
16. tanh(Value)
17. RESIDENT SampleData;
18. Drop Table SampleData;
cos
(value) acos
(value) sin
(value) asin
(value) tan
(value) atan
(value) atan2
(value,value) cosh
(value) sinh
(value) tanh
(value)
1 1.570.. 0 0 0 0 0 1 0 0
0.540.. 0 0.841.. 1.570.. 1.557.. 0.785… π/4 1.543.. 1.175.. 0.761..

The results table given below returns the 0 and 1 value for every function.

So, this brings us to the end of blog. This Tecklearn ‘Qlik Sense Statistical Distribution and Trigonometric and HyperBolic Functions’ blog helps you with commonly asked questions if you are looking out for a job in Qlik Sense BI. If you wish to learn Qlik Sense and build a career in Business Intelligence domain, then check out our interactive, Qlik Sense Certification Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

Qlik Sense Certification Training

Qlik Sense Certification Training

About the Course

Qlik Sense is a revolutionary Business Analytics tool to come from the Qlik stables. It provides powerful self-service analytics that are readily deployable through interactive and personalized dashboards, data visualization techniques and insightful reports. By the end of this Qlik Sense online training, you will be able to perform key skills of the self-service BI tool – Qlik Sense, such as self-service analytics, write data load scripts, data discovery, create dashboards, develop and share apps, create reports, and design and build data visualizations. All these skills will enable you to clear the Qlik Sense certification exam.

Why should you take Qlik Sense Training?

• The average annual pay for a Qlik Sense Professional is $101,871. -Indeed.com.
• HSBC, Alstom, Chrysler, Citibank, Accenture and many other MNC’s worldwide use Qlik Sense BI and it has a market share of around 5% globally.
• By the end of 2020, the market is expected to touch USD 22.8 billion as modern BI and analytics continue to expand more rapidly, Gartner said in a report.

What you will Learn in this Course?

Introduction and Installation of Qlik Sense

• Need for self-service Business Intelligence/Business Analytics
• Installation of Qlik Sense and Qlik Sense Desktop

Qlik Sense Features

• Qlik Data indexing engine
• Data dimensions relationships
• Types of Data Loading
• Types of Concatenation

Data Modelling

• Qlik Sense data architecture
• Understanding QVD layer
• Converting QlikView files to Qlik Sense files
• Incremental Load
• Scripting
• Create Master Calendar

Advance Data Modelling

• Qualify and unqualify
• Joins
• Keep
• Cross Table
• Let Vs Set
• Calendar Table Creation

Qlik Sense Enterprise

• Various Functions
• Create QVD Files
• Read Data for QVD Files
• Create QVD’s
• Create Tier 2 Qlik Sense App

Data Visualization

• Expressions
• Variables
• Extensions
• Data Visualization

Set Analysis

• Set analysis in Qlik Sense
• Use set expression like identifiers, operators, modifiers and comparative analysis

Advance Set Analysis

• Deploy comparison sets and perform point-in-time analysis

Qlik Sense Storytelling

• Storytelling feature of Qlik Sense
• Create a story and playback the story

Qlik Sense Visualization

• Qlik Sense Charts
• Advanced Charts
• Creating Dashboards
• Real Life Examples

Security

• Security aspects of Qlik Sense
• Security rules

Got a question for us? Please mention it in the comments section and we will get back to you.

 

0 responses on "Qlik Sense distribution and Trigonometric and HyperBolic Functions"

Leave a Message

Your email address will not be published. Required fields are marked *