Guide to Using Minitab 14 For Basic Statistical
Guide to Using Minitab 14 For Basic Statistical Applications To Accompany Business Statistics: A Decision Making Approach, 8 th Ed. Chapter 1: The Where, Why and How of Data Collection By Groebner, Shannon, Fry, & Smith Prentice-Hall Publishing Company Copyright, 2011
Chapter 1 Minitab Examples n n Random Numbers Nordstrom’s Payroll Excel Interface
Random Numbers Nordstrom’s Payroll Issue: Nordstrom’s wishes to survey ten of their 300 employees. Employees are numbered 1 to 300. Objective: Use Minitab 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 Calc Click on Integer Click on Random Data
Random Numbers – Nordstrom’s Payroll Indicate how many random variables to generate Define the range for the random numbers Indicate Where to put the values
Random Numbers – Nordstrom’s Payroll 10 Random Numbers Between 0 and 300 These are the 10 employees to be selected
Importing and Exporting Minitab data to Excel Issue: Occasionally there is a need to import or export data to an Excel spreadsheet. Objective: Use Minitab to read and create an Excel (. XLS) spreadsheet
Importing Excel Data Select file type of “Excel” To open an Excel spreadsheet in Minitab
Saving your Minitab data in Excel Click on “Save Current Worksheet as…
Saving your Minitab data in Excel Click on the version of Excel You want to save it as – Click on “Save”
- Slides: 10