{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

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

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)

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online