index002004.gif
logo8.gif
Copyright ©
Anthony Sun
All Rights Reserved.
btn_vba_off.gif
btn_forum_off.gif
btn_cdorder_off.gif
btn_guestbook_off.gif
btn_home_off.gif
faq_off.gif
links_off.gif
search_off.gif
aboutme_off.gif
Finding Median
index011022.jpg
Please read the terms of use before proceeding
Excel VBA Examples
Generate Random Number From Uniform Distribution
index011021.jpg
Compute Factorial
index011020.jpg
Statistics and Math
Sorting Numbers in an Array
index011019.jpg
Double Sorting - The Secret of Resampling Without Replacement
index011018.jpg
index011017.jpg
Simulation Basic Tutorial 101
Loop Structure - For...Next and Loops
index011016.jpg
Creating and Managing Array
index011015.jpg
Finding Max and Min in Array
index011014.jpg
Decision Structure - IF and Select Case
index011013.jpg
Binomial Coefficient
index011012.jpg
Sum Number in an Array
index011011.jpg
Cumulative Standard Normal Distribution
index011010.jpg
Excel VBA Examples
 
This section contains introductory and intermediate Excel VBA examples.  Generally, the examples are smaller in scope.  Also in this section, Simulation Basic Tutorial 101, a section that provides tutorial on basic VBA skills needed before creating a simulation with Excel VBA and an Excel VBA Basic Tutorial series (3 parts) for Beginners.
Creating a Histogram
This is an essential skill for creating a simulation. Topics in this section cover declare an array, resize an array, manage dynamic array, create multi-dimensional array, and find the array size.
Provides examples on all the loop structures: For...Next with Step, Do...While...Loop, So Until...Loop, and etc.
This tutorial shows how to call a sort sub procedure, passes the array to it, and returns a sorted array.
Contains tutorial using If...Else, If...ElseIf, and Select Case statements.
This example shows how to derive unique random values by sorting one array based on another array.
A tutorial on how to create a histogram by passing array into the histogram sub procedure and returns the frequency distribution from the array.
index011009.jpg
Simulation Basic Tutorial 102
Random Number and Randomize
One of the most essential 'Must Know' in simulation.
index011008.jpg
Standard Deviation and Mean
Two of the mostly used statistic estimates in action.
index011007.jpg
Skewness and Kurtosis
Second tier statistic estimates.
index011006.jpg
Percentile and Confidence Interval
Compute the simulated values at a specific percentile.
index011005.jpg
Profitablity
Compute the probability at a specific value (or profit).
index011004.jpg
index011003.jpg
Excel VBA Basic Tutorial Series
Excel VBA Basic Tutorial 3
Excel VBA Basic Tutorial 1
index011002.jpg
Excel VBA Basic Tutorial 2
Provides step by step example on creating and recording a macro, modules and procedures, scope, calling sub procedure and function, passing argument by value and by reference.
Introductory on workbook, worksheet, range, cells. Method and Property.
Array creation and management, decision structures, and loop structures.
Compute the median from an array.
Generate uniform random number within a range.
Sum up number in a array using loop.
Compute factorial using sum and loop
Compute binomial coefficient
Compute the probabilty from a standard normal distribution.
Extract the maximum and the minimum values in an array using sorting method.
index002002.gif
consulting_off.gif
index001003.gif
Excel Consultancy Services
interactive_off.gif
smallnew.gif
portopt_120_90.gif
random.jpg
option.jpg
xlmodeling_110x300_cd.jpg
index011001.gif
simulation.jpg
regression.jpg
domaincity.jpg
exceladdin.jpg