If you like these free online learning material, link this page from your homepage, tell your friends. If you write any papers or publications or even web sites based on the open course in this web site, please refer to the appropriate reference for each material. I would really appreciate this because you help others to find this page easier.
Market Basket Analysis
Business Intelligence method to discover association rules from transaction data of a store
|
Prime Factor
Factoring a number by its prime factors using MS Excel iteration. Free download |
Regression Model
Learn how to model you data, find the best-fit model and use graph, functions and Add Ins wizard in MS excel to automate the regression
|
Generalized Inverse
Solve regression using generalized inverse matrix in MS Excel |
| Tower of Hanoi
Solve Tower of Hanoi solitary game using iteration in MS Excel
|
Newton Rhapson
Using MS Iteration to solve one of the most famous numerical methods finding root of equation |
| Goal Seek
Solving inverse problem single unknown variable using Goal Seek tool
|
Excel Iteration
You can actually do many interactive simple programs in MS Excel without VBA macro. See how it works in this tutorial |
| Break Event Point
Simple explanation on how to determine product price based on break even point
|
Solving Inequality
Finding the range of solution for non-linear inequality equation
|
| Zeros of Non-linear equation
Steps by step procedure to obtain zeros of non-linear equation using MS Excel Goal seek
|
Discriminant Analysis
Many people disbelieve that you can do pattern classification and machine learning in MS excel without any programming or macro. Check how to do it in this tutorial |
| MultiVariate Distance Matrix
Example to compute Distance matrix from combination of categorical, binary, rank, and quantiative variables
|
Observation Based Simulation
Demonstrate how to make Monte Carlo Simulation based on the observation data |
Monte Carlo Simulation
Learn the basic of simulation and how to perform Simulation in MS Excel.
|
Bootstrap Sampling
Advance Monte Carlo method to obtain sampling distribution of an estimator from non parametric sample.
|
K means clustering
Numerical example of K means clustering using iteration (no macro).
|
K-Nearest Neighbor Algorithm
Supervised learning for data mining and statistical pattern recognition.
|
| Write your own Excel Function
Unleash the power of MS Excel by writing your own function
|
Simulatenous Rotation
Simplify your job using matrix multiplication to rotate many points simultaneously without typing the formula for each point. |
| Solving System equations
Tutorial on how to use Inverse matrix and matrix multiplication in MS Excel.
|
Root of Polynomial
Finding root of cubic polynomial equation using Goal seek tool |
Finding Eigen Value
Using MS excel Goal seek to find eigen value of a symmetric matrix.
|
Symmetric matrix from any matrix
Learn simple matrix theory on how to obtain symmetric matrix from any matrix. |
Sierpinski Gasket
Have fun with Excel to produce fractal shape of Seipinski gasket |
Ordinary Differential Equation
Practical approach to solve Ordinary Differential Equation numerically using Euler and Runge-Kutta method
|
Ginger Bread Man
Learn about Chaos and having fun with Excel to produce Chaotic Shape of Ginger Bread Man |
Q Learning
Step by step state-diagram learning theory by examples
|
Mean and Average
Interesting relationship of various average such as geometric mean, harmonic mean, and quadratic mean and arithmetic mean, time average, moving average and fundamental relationship
|
Learning from Data
Statistical concepts about central tendency (Mean, Median, and Mode) and variation of data (Range, Variance and Standard Deviation) |
Convert Decimal to Rational
How do we obtain approximation ratio of a real number? Take a look on this interesting tutorial. |
Kernel Regression
Find a fitting function that is smooth and approximate your data locally
|
Quadratic Function
Explore the characteristics of quadratic function and parabola curve |
Nearest Neighbor Interpolation
Nearest Neighbor algorithm for smoothing and prediction of time series data
|
