K-Means
Clustering
Interesting algorithm to partition
your data. Resources to classification analysis, clustering analysis,
data mining and free download code
|
Numerical Excel
Various tutorials to solve analytical problems using MS Excel with and without programming.
|
Similarity Measurement
Basic knowledge on how to measure similarity and dissimilarity of performance index. Useful for clustering, Machine learning and data mining. Many simple examples.
|
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.
|
Discriminant Analysis
Classical algorithm for pattern recognition and classification analysis.
|
K-Nearest Neighbor Algorithm
Supervised learning for classification in data mining and statistical pattern recognition. Free download.
|
Q Learning by Example
Pictorial introduction to Reinforcement Learning of Agent in unknown environment. Free download code
|
Bootstrap Sampling
Powerful Monte Carlo method to estimate distribution from sample's statistics.
|
| Analytic Hierarchy Process
Analytic Hierarchy Process (AHP) is a famous method for multi criteria decision making analysis. Read more
|
Market Basket Analysis
 Learn to discover association rules from transaction data of a store
|
Kernel Regression
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.
|
Visual
Basic (VB) tutorial
Step by step
guide to programming using Visual Basic for beginners
|
Non-Linear Transformation
Transform nonlinear curves into simple linear regression
|
|
Monte Carlo Simulation
Beginners guide to one of the largest and most important classes of numerical method for computer simulations
|
System Dynamic
Introduction to system thinking terminologies such as rate, level, positive and negative feedback loop, causal and stock flow diagram.
|
| Mean and Average

An eye opener to create many means or average beyond the traditional arithmetic, geometric and harmonic means. Include fundamentalrelationship between averages. |
GIS Tutorial
Introduction to GIS with feature to use Arc GIS (Arc View, Arc Editor or Arc Info). Assumed you know nothing about GIS.
|
Learning from Data
Statistical concepts about central tendency and variation of data |
Data Analysis from Questionnaires
Descriptive Statistics and Pivot Table to analyze your data from questionnaire survey
|
|
Digital Root
Discover fascinating mathematical patterns of digital root
|
Prime Factor
Use MS Excel iteration to compute prime factors in spreadsheet without macro
|
|
What-If Analysis
Explain how to perform what-if scenario and sensitivity analysis. Example on economic feasibility study for public transportation system (bus).
|
Useful Summation & Tricks
This tutorial is made especially for those of you who forget or confuse with the mathematics symbol Sigma that represent summation.
|
| Graph Theory
A very gentle introduction to Graph theory in ordinary English using simple diagram of points and arcs.
|
Difference Equation
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
|
Growth Model
Brief introduction to various basic growth model such as arithmetic , geometric, exponential and logistic growth phenomena.
|
Continued Fraction
An introduction to regular continued fraction (finite, infinite and periodic) and its application to convert decimal to fraction, compute Pi and Euler number.
|
Generalized Inverse
Solve regression using generalized inverse matrix in MS Excel
|
Recursive Average & Variance
Efficient methods to compute average and variance using recursive formula for real time measurement data
|
Quadratic Function
Explore the characteristics of quadratic function and parabola curve
|
LAN Connections Switch
How to automate swicth between LAN connections from static IP address to broadband DHCP
|
|
Solving ODE
Practical approach to solve Ordinary Differential Equation numerically using Euler and Runge-Kutta method
|
More tutorials ...
|