Standard Deviation and Mean

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. The mean and standand deviation formulas are shown below. Note that the standard deviation in this example is for a sample, not a population.

Copyright © XL Modeling.