Copyright ©
Anthony Sun
All Rights Reserved.
Excel Examples
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!
Interactice Excel Programs on The Web (No VBA)
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.
