ME-310 Mechanical Design: Introduction

Using Spreadsheets in Excel

Assignment 1

1. Look up the Normal Probability Distribution function and enter it into a cell in ascii notation.
2. Define names for the mean and standard deviation parameters.
3. Create a column of fifty x values and a column of Normal Probability Distribution function values.
4. Create a column of derivatives of the probability function.
5. Create a column of the integral of the probability distribution.
6. Plot the three functions vs. x.

 

Assignment 2

1. Control the range of the column of x values to ±3*standard deviation by making the x values functions of the standard deviation.

Create a macro that looks up the Normal Probability Distribution function value for any given x value.