1 / 29

Minitab overview

Minitab overview. L. Goch – Jan 2011. Agenda:. Why do I need Minitab? Data Entry & Manipulation Minitab Tutorials Multi-Vari Charts Graphing Box & Whisker Plots Scatter Plots Histograms Bar Charts Simple Linear Regression Control Charting T-tests/F-tests/ANOVA Analyses

Download Presentation

Minitab overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Minitab overview L. Goch – Jan 2011

  2. Agenda: • Why do I need Minitab? • Data Entry & Manipulation • Minitab Tutorials • Multi-Vari Charts • Graphing • Box & Whisker Plots • Scatter Plots • Histograms • Bar Charts • Simple Linear Regression • Control Charting • T-tests/F-tests/ANOVA Analyses • Weibull (‘time to failure’) Plots

  3. Why do I Need Minitab?: • Excel: • Easier Data Entry • No pre-set data formatting required for analysis • Need multiple tools & Steps for Data Analysis & Graphs • Minitab: • Easier / Faster Graphing • Graphs & Data Analysis in 1-Step • Report Writing tool within Minitab • Requires Stacked Data for most Tools • Minitab & Excel: • Multiple Windows/Worksheets within one main file. • Data Analysis Capability

  4. Data Entry & Manipulation: • Window Types:Session Window & Data Window • Session Window: • The Output • Data Window: • A Worksheet, not an Excel Spreadsheet • Column names are above first row • Everything in a column is considered to be from the same group

  5. Data Entry & Manipulation: • Enter Data into Minitab by: • Typing it in • Cutting & pasting from other programs • Random number generators in Minitab • Importing it: Excel, Text, ASCII, Dbase files, etc….

  6. Data Entry & Manipulation: • Graph Manager: • Lists all Created Graphs

  7. Data Entry & Manipulation: • Worksheet Manager: • Lists all Created Worksheets

  8. Data Entry & Manipulation • Minitab Operating Files • Minitab has training files in it’s data subdirectory • To find them go to: • C:/Program Files/ MINITAB 14/ English/Sample Data • Minitab File Extensions • MPJ for Project Files • Ex: Data.mpj • MTW For Data Files (Worksheets only) • Ex: Data.mtw • MFG For Graphs (Graphs only) • Ex: Pareto1.mgf

  9. Data Entry & Manipulation:Short Cut Keys • Control C / Control V • Copies data / Pastes data • Alt Tab • Moves you from one Windows application to another • Ex: • Minitab to PowerPoint for making presentations • Excel to Minitab for copying data • Control E • Pulls up previous menu • Control Tab • Moves you from Data, Session, History, and Info Windows

  10. Data Entry & Manipulation: Common Pitfalls • Numeric / Text / Date Data In Columns • Once a column has been defined with data it will need to be changed if you want to use a different type of data • Data > Change Data Type • Dollar signs, number signs, and commas are treated as text data • Grey Menu Screens and Commands • You may be in the wrong Minitab Window • You may not have finished entering data (Hit the enter key) • Minitab Moving Slowly • Not enough computer memory • Close some graphs, other applications or upgrade your computer.

  11. Data Entry & Manipulation: Common Pitfalls • Minitab Worksheets do not function the same as Excel spreadsheets • Graphs may or may not automatically update when worksheet data is changed. By right clicking over a graph, you can ‘Update Graph Automatically’ to refresh the graph to the changes you made in the worksheet from which it was created. • Calculated fields within a Minitab worksheet do not automatically update when changes are made unless you’ve set the field with a formula • Note: Minitab does not recognize imbedded formulas imported from other applications • Use caution when closing worksheet or graph windows as they may be removed without warning • Use Tools > Options to reset these options

  12. Minitab Tutorials • Opening the Tutorial Files • Click Help> Tutorials • Open a Session • Click the plus sign next to Session #

  13. Minitab Tutorials • Start by clicking on the Overview and continue to follow step by step. Minitab will provide you with the already available files so you can do the analysis along with Minitab.

  14. Minitab Help • Opening the Help Files • On any tool, you can Click the Help button

  15. Data Entry & Manipulation Example • Most Minitab tools require STACKED DATA • Unstacked Data needs to be changed into Stacked Data

  16. Let’s look at some of the Graphs and Tools that are Available in Minitab.

  17. Charts & Graphs: • Multi-Vari Charts:Can plot up to 4 different Factors on a Multi-Vari Chart

  18. Charts & Graphs: • Box & Whisker Plot:Same data, different view. 50% of data is within the BOX.

  19. Charts & Graphs: • Histogram:Same data, different view.

  20. Charts & Graphs: • Capability Chart:Same data, different view.

  21. Charts & Graphs: • Bar Chart:Same data, different view.

  22. Charts & Graphs: • Control Chart: Daily Calibration Data.

  23. Charts & Graphs: • Control Chart: Daily Production Data.

  24. Basic Data Analysis: Results for: By Load Data Two-Sample T-Test and CI: % Total Late Dbl Bills, FW Two-sample T for % Total Late Dbl Bills FWNMeanStDevSE Mean 30.20 8 0.00312 0.00372 0.00130 40.50 8 0.00063 0.00116 0.00041 Difference = mu (30.20) - mu (40.50) Estimate for difference: 0.00250 95% CI for difference: (-0.00045, 0.00545) T-Test of difference = 0 (vs not =): T-Value = 1.81 P-Value = 0.091 DF = 14 Both use Pooled StDev = 0.0028 • Two Sample T-Test: Compares Avgs of 2 Groups

  25. Basic Data Analysis: • F-Test: Compares Stdevs of >2 Groups

  26. Basic Data Analysis: • Chi-Squared: Compares Counts of >2 Groups

  27. Basic Data Analysis: • Data Analysis: Analyzes DOE & Non-DOE Data

  28. Weibull Plots: • AFD 1.6 Data:1 Failure at 1.8 M cycles, 1 Failure at 2.2 M cycles, 1 still going at 1.3 M cycles

  29. Questions???

More Related