Example Class1 - THE UNIVERSITY OF HONG KONG DEPARTMENT OF...

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

View Full Document Right Arrow Icon

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

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

Unformatted text preview: THE UNIVERSITY OF HONG KONG DEPARTMENT OF STATISTICS AND ACTUARIAL SCIENCE STAT 1302 PROBABILITY AND STATISTICS II (2010-11) EXAMPLE CLASS 1 Generating Random Numbers Using EXCEL : Before you start, make sure the package Data Analysis has been installed under the Tools menu (for Office 97-2003) or in the Analysis group under the Data tab (for Office 2007). To install Data Analysis package: • (Using Office 97-2003) Step 1. Click the Add-Ins option under the Tools menu. Step 2. Select the Analysis ToolPak box in the Add-Ins available list, and then click OK . • (Using Office 2007) Step 1. Click the Microsoft Office Button (which is at the left-hand up corner), and then click Excel Options . Step 2. Click Add-Ins , and then in the Manage box, select Excel Add-ins , then click Go . Step 3. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK . Method 1 (Use the Random Number Generation function inside Data Analysis ) Click Tools(Office 97-2003) or Data(Office 2007) → Data Analysis → Random Number Generation • Number of Variables- how many numbers you want to generate for each sample (sample size)...
View Full Document

This note was uploaded on 11/17/2011 for the course MUSIC 1001 taught by Professor Dr.yun during the Spring '11 term at Princess Sumaya University for Technology.

Page1 / 6

Example Class1 - THE UNIVERSITY OF HONG KONG DEPARTMENT OF...

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