Slide 1Chapter 1 Excel 2003 ExamplesRandom Numbers - Nordstrom’s PayrollSlide 4Slide 5Slide 6Slide 7Slide 8Slide 9Guide to Using Excel 2003 For Basic Statistical ApplicationsGuide to Using Excel 2003 For Basic Statistical ApplicationsTo AccompanyTo AccompanyBusiness Statistics: A Decision Making Approach, 7th Ed.Chapter 1:Chapter 1:The Where, Why and How of Data The Where, Why and How of Data CollectionCollectionByByGroebner, Shannon, Fry, & SmithGroebner, Shannon, Fry, & SmithPrentice-Hall Publishing CompanyPrentice-Hall Publishing CompanyCopyright, 2008Copyright, 2008Chapter 1 Excel 2003 ExamplesRandom Numbers - Nordstrom’s PayrollRandom Numbers - Nordstrom’s PayrollIssue: Issue: Nordstrom’s wishes to survey ten of their Nordstrom’s wishes to survey ten of their 300 employees. Employees are numbered 1 to 300 employees. Employees are numbered 1 to 300.300.Objective: Objective: Use Excel to generate 10 random numbers Use Excel to generate 10 random numbers between 1 and 300. Values must be between 1 and 300. Values must be integer numbers corresponding to integer numbers corresponding to employee numbersemployee numbersClick on ToolsClick on Data AnalysisRandom Numbers – Nordstrom’s PayrollSelect Random Number GenerationRandom Numbers – Nordstrom’s PayrollProvide Required InputsNote: Select Uniform DistributionRandom Numbers – Nordstrom’s PayrollNeed to convert numbers to integersNote: Each time you use Random Number Generation, you will get a different string of random numbersRandom Numbers – Nordstrom’s PayrollHighlight the Data ValuesClick the Decrease Decimal Button to Remove Decimal PlacesRandom Numbers – Nordstrom’s Payroll10 Random Numbers Between 0 and 300 - These are the 10 employees to be selectedRandom Numbers – Nordstrom’s
View Full Document