This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full 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.
- Spring '11