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
Linear and Non-Linear Regression - Log Transformation
index010005.jpg
Please read the terms of use before proceeding
Excel Examples
Bivariate Standard Normal Density Function
index010004.jpg
Excel Tutorial And Interactice Web Excel Models

This section is designed to demostrate examples without using VBA.  Complicate financial and statistic models can still be constructed without the use of VBA.  It also includes general Excel topics.  Newly added, the interactive Web Excel section.  You can run the excel models and simulations on the Web.  Very cool!
Frequency Histogram on Uniform Distribution
index010003.jpg
Interactice Excel Programs on The Web (No VBA)
Black/Scholes Option Model on European Call and Put
index010002.jpg
Monte Carlo Simulation
index010001.jpg
This example shows how to construct frequency distribution from a simulated uniform distribution and displays a histogram without using Excel chart.
This interactive web application let you compute call and put price right on the Web. Just change any of the 5 parameters and see the changes take place.
This example generates Normal distribution and Discret distribution deviates to simulate a movie theater tickets sale. Percentiles and other descriptive statistics are also created. The result is also displays on a histogram. (This example is about 600KBs, therefore, it will take a little longer to to load depends on your online service. Please be patient. It is worth.
Comparision between a linear and a none-linear regression model. Log transformation is used for the none-linear model.
Demostrates how to generate bivariate normal distribution density function for both 'with correlation' and 'without correlation' case.
index002002.gif
Excel Consultancy Services
consulting_off.gif
index001003.gif
xlmodeling_110x300_box.jpg
interactive_off.gif
smallnew.gif
simulation.jpg
regression.jpg
portopt_120_90.gif
random.jpg
option.jpg