MATH 221 LAB 10 FA 09

MATH 221 LAB 10 FA 09 - M ATH 221 Student Name Instructor...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
MATH 221 Statistics for Decision Making LAB 10 Student Name Section © Copyright 2009 by P.E.P. Page 1 of 2 Instructor Due Date PROJECT The Normal Distribution Curve 100 Points _____ your score Objective To use worksheet functions to simulate normal curve areas. PROJECT DESCRIPTION Using MS Excel, build a worksheet that involves the Normal probability distribution and its graph. Information About This Project MS Excel can be used to simulate the graph of the so - called bell - shaped curve. Steps to Complete this Project STEP 1 Open MS Excel and Design the Normal Curve Worksheet Open MS Excel and copy the worksheet below onto your computer. A B C D 1 - 3.0 - 3.0 2 - 2.5 - 2.5 3 - 2.0 - 2.0 4 - 1.5 - 1.5 5 - 1.0 - 1.0 6 - 0.5 - 0.5 7 0.0 0.0 8 0.5 0.5 9 1.0 1.0 10 1.5 1.5 11 2.0 2.0 12 2.5 2.5 13 3.0 3.0 In cell B1, type the following formula and press enter. = ( 1 / ( SQRT ( 2 * PI ( ) ) ) * EXP ( - ( 1 / 2 ) * A1 ^ 2 ) ) Drag - and - fill this formula from cell B1 to cell B13. The formula that you have entered returns the values corresponding to normal curve
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 04/05/2011.

Page1 / 2

MATH 221 LAB 10 FA 09 - M ATH 221 Student Name Instructor...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online