This example is a relatively easy one. The objective is to compute the mean and the standard deviation from an array. In this example, the array is from A1 to A10 of sheet1 of an opened Excel workbook. This program has two function procedures and one sub procedure. The sub procedure reads in the numbers from the array (A1..A10), calls up the function procedures and returns the mean and standard deviation value.
See Examples below;
Standard Deviation and Mean
Lotto Number Generator >
Playing Card Probability >
Normal Distribution Random Number Generator >
Monte Carlo Integration >
Black-Scholes Option Pricing Model - European Call and Put >
Binomial Option Pricing Model >
Portfolio Optimization >
Multiple Regression >
Bootstrap - A Non-Parametric Approach >
Multivariate Standard Normal Probability Distribution >
Monte Carlo Simulation >
Option Greeks Based on Black-Scholes Option Pricing Model.
Special! Free Choice of
Complete Excel Training Course
or Excel Add-ins Collection
on all purchases totaling over
ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft