Principal Component Analysis
Feature selection, dimensional reduction for visualization using PCA. Excel Add-In also available
Python for Data Science
Learn about Data Analysis and Artificial Intelligence in Python.
Build your own intelligent magic box in Excel that can be trained to recognize patterns without programming. It's simply amazing...
Learn step by step how to use and generate a popular classifier that does not require any knowledge or parameter setting.
Step by step example on how to compute hierarchical clustering manually and how to validate the clustering using Cophenetic Correlation Coefficient
Q Learning by Example
Pictorial introduction to Reinforcement Learning of Agent in unknown environment. Solving Tower of Hanoi.
Various tutorials to solve analytical problems using MS Excel with and without programming.
Interesting algorithm to partition your data. Resources to classification analysis, clustering analysis, data mining
Blend of independent component distributions.
Gaussian Mixture Model
Flexible unsupervised learning for density estimation, clustering and likelihood optimization.
K-Nearest Neighbor Algorithm
Supervised learning for classification, interpolation and extrapolation in data mining and statistical pattern recognition.
Break Event Analysis
Interactive way to optimize your pricing strategy and starts make profit
Learn about Random Walk and Brownian Motion in Excel.
Gain insight about the meaning of compound interest rate
Analysis of Algorithm
Compare the efficiency of algorithms, rank the best, good and bad algorithms and measure programmer's productivity that influence your IT cost.
Analytic Hierarchy Process
Analytic Hierarchy Process (AHP) is a famous method for multi criteria decision making analysis.
Market Basket Analysis
Learn to discover association rules from transaction data of a store.
Frequently asked questions about MapReduce for Big Data
Transform nonlinear curves into simple linear regression
Recursive Average & Variance
Efficient methods to compute average and variance using recursive formula for real time measurement data
Classical algorithm for pattern recognition and classification analysis.
Powerful Monte Carlo method to estimate distribution from sample's statistics.
Discover fascinating mathematical patterns of digital root
Explain how to perform what-if scenario and sensitivity analysis. Example on economic feasibility study for public transportation system (bus).
Introduction to system thinking terminologies such as rate, level, positive and negative feedback loop, causal and stock flow diagram.
Basic knowledge on how to measure similarity and dissimilarity of performance index. Useful for clustering, Machine learning and data mining. Many simple examples.
Monte Carlo Simulation
Beginners guide to one of the largest and most important classes of numerical method for computer simulations
Mean and Average
An eye opener to create many means or average beyond the traditional arithmetic, geometric and harmonic means. Include fundamentalrelationship between averages.
Development of prototype multi agent simulation using only spreadsheet. Simple example of race of agents.
Visual Basic (VB) tutorial
Step by step guide to programming using Visual Basic for beginners
Practical approach to solve Ordinary Differential Equation numerically using Euler and Runge-Kutta method
Non-linear curve fitting technique using local kernel only by MS excel without macro
Linear Regression Model
An introduction to regression model using MS Excel. Learn how to model, find the best-fit model and use graph, functions, matrix and Add Ins to automate the regression.
Understanding vector, matrix, solving linear equations, eigen value, and many more using online interactive programs.
Data Analysis from Questionnaires
Interactive descriptive statistics and contingency table and chi-square independent test to analyze your data from questionnaire survey
Introduction to GIS with feature to use Arc GIS (Arc View, Arc Editor or Arc Info). Assumed you know nothing about GIS.
Learn how to test whether a word or a number is a palindrome. Generate and search palindrome.
Useful Summation & Tricks
This tutorial is made especially for those of you who forget or confuse with the mathematics symbol Sigma that represent summation.
Brief introduction to various basic growth model such as arithmetic , geometric, exponential and logistic growth phenomena using interactive program
A very gentle introduction to Graph theory in ordinary English using simple diagram of points and arcs.
Learn very fascinating subject of discrete dynamical system, its solution, behavior, equilibrium or critical value and stability.
Ginger Bread Man
Do you remember ginger bread man cookies? Learn about Chaos and having fun to produce Ginger Bread Man Cards
Fractal in Excel
Have fun with Excel to produce fractal shape of Seipinski gasket
Adaptive Machine Learning Algorithm
Histogram based learning formula with memory for educational Monte Calo game and simulation. Numerical example for hand calculation and MS Excel is explained.
An introduction to regular continued fraction (finite, infinite and periodic) and its application to convert decimal to fraction, compute Pi and Euler number.
LAN Connections Switch
How to automate swicth between LAN connections from static IP address to broadband DHCP
Get frustrated because of congestion and queuing problem? Read this tutorial to solve your unnecessary queuing problems.
Solve regression using generalized inverse matrix in MS Excel
Learn how to compute Google Page Rank algorithm using MS Excel iteration and Matlab. Read more
Explore the characteristics of quadratic function and parabola curve
Learning from Data
Statistical concepts and online programs about central tendency and variation of data.
Have fun with mathematical puzzle and solution.
Build Fractal Geometry using Complex Number. It gives you the basic arithmetic of Complex Number.
An iterative procedure to estimate the maximum likelihood of mixture density distribution
Support Vector Machine
Classify non-linear data using SVM without programming.
Well-known method to estimate the parameter of a distribution