Slide 1Chapter 1 Excel ExamplesRandom Numbers - Nordstrom’s PayrollRandom Numbers – Nordstrom’s PayrollSlide 5Slide 6Slide 7Slide 8Guide to Using Excel 2007 For Basic Statistical ApplicationsGuide to Using Excel 2007 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 Chapter 1 Excel ExamplesExamplesRandom Numbers Random Numbers - - Nordstrom’s PayrollNordstrom’s PayrollRandom Numbers -Random Numbers - Nordstrom’s Payroll Nordstrom’s PayrollIssue: Nordstrom’s wishes to survey ten of Issue: Nordstrom’s wishes to survey ten of their 300 employees. Employees are numbered 1 their 300 employees. Employees are numbered 1 to 300.to 300.Objective: Use Excel 2007 to generate 10 random Objective: Use Excel 2007 to generate 10 random numbers between 1 and 300. Values must be numbers between 1 and 300. Values must be integer numbers corresponding to employee integer numbers corresponding to employee numbersnumbersRandom Numbers – Nordstrom’s Payroll•On the Data tab, select Data Analysis•Select Random Number GenerationRandom Numbers – Nordstrom’s Payroll•Distribution = Uniform•Parameters between 1 and 300•Output Range = A1:A10Random Numbers – Nordstrom’s Payroll•Resulting 10 random numbers•Using the Excel Facilities, convert these numbers to Integers Resulting list of 10 random numbers. Now to convert them to integers.Random Numbers – Nordstrom’s Payroll•Select the Home tab•Highlight (select) the numbers to be converted to integers•These Icons (Note the red circle) can be used to control the number of digits to the right of the decimal point. Each click will move the decimal point in one direction. Use the left icon to convert the column to integersRandom Numbers – Nordstrom’s PayrollResulting in 10 random
View Full Document
Unlocking...