The following spreadsheet analyzes the results from a laboratory test. The measured strengths of a series of specimens from ten tests are listed in the columns of the table.

Click here to download a copy of this spreadsheet minus the formulas in the bottom section. To complete this assignment, do the following:

1. Enter the Excel formulas at the bottom of each column to compute the minimum, maximum, mean (average), and standard deviation for the samples in the test.

2. Create a custom VB function called **num_outliers** to compute the
number of outliers in each column. In this case, an outlier is defined as
a value that differs from the mean (higher or lower) by more than 1.5
times the standard deviation. Enter a formula in the "# Outliers" row
that uses this custom function to display the number of outliers. This
function should take* three arguments* as input and return an
integer. The first argument is the range of cells to analyze (the column
of test values above the cell), the second argument is the mean, and the
third is the standard deviation. You can get the mean and the standard
deviation from the values you have already computed in rows 28 and 29.

3. Create a custom VB function called **adj_mean** that computes an
adjusted average for each column of data values. The adjusted mean should
omit all outliers. In other words, you will compute the sum of the
non-outlier values and divide by the number of non-outliers. Enter a
formula in the "Adj. Mean" row that uses this custom function to display
the adjusted mean. This function will have the same three arguments as
the ** num_outliers** function.

Put your custom functions in the module named **Outlier_Functions**.

**Hint**: You will need to use the "For Each ... Next" construct to
loop through the cells in the input range in both of your custom
functions.

1. Be sure to save the changes to your spreadsheet.

2. Upload your spreadsheet via Learning Suite.