Students often are confused by the difference between a normal distribution curve, as in Exercise 22, and

Question:

Students often are confused by the difference between a normal distribution curve, as in Exercise 22, and a random distribution. Excel has a variable rand() that will generate random numbers between 0 and 1. (See the Excel Help menu to see how to use it.) Plot a random curve for the set of 100 numbers from 0 to 99.
Use the Chart–Column representation. Observe its shape and calculate its mean and standard distribution.


Exercise 22

The equation for a normal error curve is

(x-) exp

or in spreadsheet script:


Plot a normal distribution curve for the set of 100 numbers from 0 to 99.

Step by Step Answer:

Related Book For  book-img-for-question

Exploring Engineering An Introduction to Engineering and Design

ISBN: 978-0123747235

2nd edition

Authors: Philip Kosky, George Wise, Robert Balmer, William Keat

Question Posted: