workshop09 - CHEN 3010 Applied Data Analysis Fall 2004...

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

View Full Document Right Arrow Icon
CHEN 3010 Applied Data Analysis Fall 2004 Group Members: __________________________ __________________________ __________________________ __________________________ Workshop 9: Central Limit Theorem Objective: Measurements may exhibit a distribution that is markedly different from the normal distribution; however, when groups of these measurements are combined in a calculation, such as an average, the Central Limit Theorem states that the distribution of the calculated values tends toward a normal distribution, even if the original data definitely do not. In this workshop, you will test the Central Limit Theorem. Directions: 1. Go out the HP Lab Plaza in the ITLL. Rotate group members on the computer, as suggested below, and pay close attention to the operations carried out there. 2. Group Member 1 : Log onto the computer. Launch Excel. 3. Select Tools Data Analysis . [If Data Analysis is not on the Tools menu, select Add-Ins , then check Analysis Toolpak .] Select Random Number Generation . 4. In the Random Number Generation dialog box, set the Number of Variables equal to 20 and the Number of Random Numbers to 200 . Select the Distribution type to be Uniform . Click OK . You should see a matrix of 4,000 random numbers appear on a new worksheet. These follow a uniform , not normal, distribution. 5.
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.

Page1 / 2

workshop09 - CHEN 3010 Applied Data Analysis Fall 2004...

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