I like mathematics and see the potential it is not only in robotics or “almost sci-fi” technologies but everywhere where data is generated and should be understood.
I like Qlik, its possibilities and simplicity for end-users at the same time.
However, when it comes to mathematics and Qlik together, a lot of people think about SSEs – python or R – and default Qlik math functions are underestimated. I think there might be two reasons – Qlik users do not know about them or do not understand when these functions can help them. So, I decided to develop a Qlik app that will get you an overview of default mathematical functions in Qlik with a little bit of theory and above all, examples and exercises. All of them are interactive – thanks to Qlik 😉.
In the QS Math & Statistics app v3.0 you can find:
- Quiz to test your skills with Qlikculator I am very proud of 😄 (what to do for 5 hours in a train without wifi)
- An interactive overview of basic math functions with examples
- Descriptive statistics – theory, example, and my thoughts:
- Measures of central tendency
- Measures of variability
- Percentiles, quartiles, fractiles
- Measures of distribution
- Overview of different datasets
- Intro to correlation
- Financial functions
- Overview with the Payment calculator
- Future Value & Present Value
If you will find the app useful, in next versions I will add:
- Outliers & extreme values – why and how to identify them
- Financial aggregation functions (IRR, NPV, XIRR, XNPV)
- Linear regression with examples not only for prediction
- Combinatorics examples
- Statistical distribution functions
Thanks, @radoresky for your help and review of the app
I hope you will like it. Any recommendations are very welcome 😉,
Maria
