Guide to Using Excel 2003 For Basic Statistical Applications
To Accompany Business Statistics: A Decision Making Approach, 7th Ed. Chapter 1: The Where, Why and How of Data Collection By Groebner, Shannon, Fry, & Smith
Prentice-Hall Publishing Company Copyright, 2008
Chapter 1 Excel 2003 Examples
Random
Numbers Nordstrom’s Payroll
Random Numbers Nordstrom’s Payroll
Issue: Nordstrom’s wishes to survey ten of their 300 employees. Employees are numbered 1 to 300. Objective: Use Excel to generate 10 random numbers between 1 and 300. Values must be integer numbers corresponding to employee numbers
Random Numbers – Nordstrom’s Payroll
Click on Tools
Click on
Data Analysis
Random Numbers – Nordstrom’s Payroll
Select Random Number Generation
Random Numbers – Nordstrom’s Payroll
Note: Select Uniform Distribution
Provide Required Inputs
Random Numbers – Nordstrom’s Payroll
Need to convert numbers to integers
Note: Each time you use Random Number Generation, you will get a different string of random numbers
Random Numbers – Nordstrom’s Payroll
Highlight the Data Values Click the Decrease Decimal Button to Remove Decimal Places
Random Numbers – Nordstrom’s Payroll
10 Random Numbers Between 0 and 300 These are the 10 employees to be selected