Minitab 16 Tips And Tricks [Read-Only] - MoreSteam

Minitab 16 Tips and Tricks 2010 Minitab, Inc.

Importing and Manipulating DataWorksheetsGraphicsCustomizing MinitabAdditional Tips 2010 Minitab, Inc.

Importing Excel FilesIn Minitab, choose File Open Worksheet 2010 Minitab, Inc.

Importing Excel FilesIn the File Open Worksheet dialog, use Options andPreview before opening file 2010 Minitab, Inc.

Importing Excel FilesCorrectly-formatted sheets open into separate worksheets 2010 Minitab, Inc.

Importing Data from a DatabaseIn Minitab, choose File Query Database (ODBC),select Machine Data Source and then your databaseNote: Use File New Minitab Worksheet to import data into a blank worksheet 2010 Minitab, Inc.

Importing Data from a DatabaseSelect the tables and fields that you want to importSelect Use rows to specify a condition statement 2010 Minitab, Inc.

Tally Individual VariablesUse Stat Tables Tally Individual Variables to get a listof unique values for a given columnTally will help you easily identify any inconsistencies 2010 Minitab, Inc.

Coding DataRight-click oncolumn ReplaceORUse Data Code Text to Text if you need to codemultiple values 2010 Minitab, Inc.

After Data are CodedNow we can create Pareto charts, get DescriptiveStatistics, etc. for the downtime Cum % 2010 Minitab, Inc.0igAlnmentanC hgeeO 67.8aittr Mfo338.676.4atliaerrCuhg tLi256.582.9itanoBr205.288.1nkeolT o184.792.7Oerth287.3100.0PercentCountPareto Chart of Reason

Value OrderValue order determines the ordering of variablesRight-click on a column and choose Column ValueOrder to define an orderIndividual Value Plot of DownTime505040403030DownTimeDownTimeIndividual Value Plot of DownTime20101000HighLowMediumSpeedSpeeds displayed inAlphabetical Order (default) 2010 Minitab, Inc.20LowMediumHighSpeedSpeeds now displayed in aUser-Specified Order

Change Data TypeSuppose you import data and find that a numeric columnis incorrectly formatted as textUse Data Change Data Type Text to Numeric tochange the column format 2010 Minitab, Inc.

Importing and Manipulating DataWorksheetsGraphicsCustomizing MinitabAdditional Tips 2010 Minitab, Inc.

Formulas in the WorksheetUse Calc Calculator to assign formulas to columnsColumns update when data in the worksheet change 2010 Minitab, Inc.

Worksheet and Column DescriptionsRight-click on column and choose Column Descriptionto add notes for future referenceRight-click onto add a Worksheet Description 2010 Minitab, Inc.

Worksheet ZoomingUse the Control key and mouse wheel to zoom in and outof the worksheet 2010 Minitab, Inc.

Multiple Undo and RedoUse toolbar arrows to undo or redo changes made todata in the worksheetundo 2010 Minitab, Inc.redo

Importing and Manipulating DataWorksheetsGraphicsCustomizing MinitabAdditional Tips 2010 Minitab, Inc.

Split Graph into PanelsRight-click on a cluttered graph and choose Panel toreduce the clutterTime Series Plot of Weld StrengthTime Series Plot of Weld Strength89.589.589.0Weld StrengthWeld 088.588.088.011020304050IndexBefore paneling 2010 Minitab, Inc.60708090IndexAfter paneling

Brushing OptionsWe see strength values that are lower than expectedand want to do further investigationRight-click Brush right-click Set ID Variables 2010 Minitab, Inc.

Brushing OptionsBrush multiple groups of points using the Shift keyThe brushing window shows that all lower weldstrengths are associated with the third shift 2010 Minitab, Inc.

Brushing OptionsThe Data Options button for any Graph or Control Chartallows you to include or exclude brushed rows 2010 Minitab, Inc.

Subset WorksheetUse Data Subset Worksheet to create a newworksheet based on a condition, brushed rows orspecific row numbers 2010 Minitab, Inc.

Graph Annotation Tools ToolbarChoose Tools Toolbars to enable the GraphAnnotation Tools toolbarThe Graph Annotation Tools toolbar is useful for addingtext, circles, and arrows to graphsSelect Mode Rectangle Line PolylineText 2010 Minitab, Inc.EllipseMarkerPolygon

Graph Editing ToolbarChoose Tools Toolbars to enable the Graph EditingtoolbarThe Graph Editing toolbar is useful for editing graphsand obtaining graph coordinatesSelect ListSelectEdit 2010 Minitab, Inc.CrosshairBrushPlant FlagAdd ListZoomDelete

Graph Editing Toolbar examplesUse the Add List dropdown to add gridlines, referencelines, subtitles and data labelsUse Crosshair modeexplore graphs 2010 Minitab, Inc.to

In-Place Graph EditingDouble-click on the graph components to change fonts,colors, add a date/time stamp, etc.Right-click on the graph to add titles, gridlines, datalabels, etc.Before EditingAfter EditingBoxplot of Weld StrengthBoxplot of Weld StrengthFebruary 26 - March 3089.51ShiftWeld Strength89.088.588.031 2010 Minitab, Inc.22Shift388.088.5Weld Strength89.089.5

Extract from Date/TimeSuppose we want to create the same boxplot, but useweekday instead of shiftUse Data Extract from Date/Time to create a weekdayscolumn using the existing date column 2010 Minitab, Inc.

Make Similar GraphUse Editor Make Similar Graph to create a similargraph using different variablesBoxplot of Weld StrengthBoxplot of Weld StrengthFebruary 26 - March 30February 26 - March 30SunMonWeekdayShift12TueWedThuFri3Sat88.088.5Weld Strength 2010 Minitab, Inc.89.089.588.088.5Weld Strength89.089.5

Layout ToolTo combine multiple graphs into one window, chooseEditor Layout ToolBo xp lo t o f We ld S t re n gt hF ebruary 26 - M arch 30Shift12388.088.5We ld S tr e n g th89.089.588.088.5We ld S tr e n g th89.089.5S unWeekdayM onT ueWe dT huF riS at 2010 Minitab, Inc.

Updating GraphsAvailable for core graphs and Control ChartsRight-click on icon in upper left corner to update graph Automatic Updates – graph automatically updates anytime datachange Update Graph – performs one-time updateCore Graphs and Control ChartsGraph is up-to-dateData used to create graphhave changedOn-hold, some conditionprevents auto-update 2010 Minitab, Inc.All Other GraphsGraph is up-to-date, butcannot be updatedData used to create graphhave changed, and graphcannot be updated

Importing and Manipulating DataWorksheetsGraphicsCustomizing MinitabAdditional Tips 2010 Minitab, Inc.

Tools OptionsUse Tools Options to set default preferencesFor example, specify a default file location that Minitabwill go to when using File Open Project 2010 Minitab, Inc.

Tools Options My FootnoteTo easily keep track of which worksheet was used tocreate each graph, set a footnote to automatically displaythe worksheet nameBoxplot of Weld StrengthWeld Strength89.589.088.588.012ShiftWorksheet: Initial Study 2010 Minitab, Inc.3

Tools Options Capability AnalysisDisplay Benchmark Z’s by default instead of Cp and Pp 2010 Minitab, Inc.

Tools Options Residual PlotsDisplay the Anderson-Darling Normality Test onregression, ANOVA and DOE residual plots 2010 Minitab, Inc.

Tools CustomizeCustomize existing menu and toolbar items: Move Add Edit DeleteCreate a new menuor toolbar 2010 Minitab, Inc.or

Tools Customize to move or addChoose Tools Customize and then click and dragAdd ‘Open Worksheet’to your toolbarMove or add ‘ParetoChart’ to Graph menu 2010 Minitab, Inc.

Tools Customize to create new toolbarsTo create a new toolbar, use the Toolbars tab NewTo add features to a new toolbar, choose the Commandstab, then click and drag 2010 Minitab, Inc.

Tools Customize to create new menusTo create a new menu, use the Commands tab NewMenuTo add features to a new menu, choose the Commandstab, then click and drag 2010 Minitab, Inc.

Importing and Manipulating DataWorksheetsGraphicsCustomizing MinitabAdditional Tips 2010 Minitab, Inc.

The AssistantNot sure which tool to use?Want Minitab to interpret the output for you?Need to present your results? 2010 Minitab, Inc.

Export to PowerPoint or WordRight-click to send to PowerPoint or Word 2010 Minitab, Inc.

Using the ReportPadUse the ReportPad to write a reportRight-click on a graph and choose Append Graph toReportRight-click on Session output and choose AppendSection to ReportClick on the toolbar’s 2010 Minitab, Inc.to open the ReportPad

Saving and Exporting the ReportPadSave Report As saves the report as a .RTF or .HTMLMove to Word Processor moves the ReportPad contentsto your default word processor (i.e. cut and paste)Copy to Word Processor copies the ReportPad contentsto your default word processor (i.e. copy and paste) 2010 Minitab, Inc.

HelpHelp includes examples and sample data setsAvailable from the Help menu and in every dialog box3 2010 Minitab, Inc.

StatGuideAfter you run an analysis, click on theStatGuide toolbar icon for help interpretingyour results 2010 Minitab, Inc.

Free ResourcesTechnical Support Via phone and online minitab.com/supportMinitab Blog Sharing tools, tips and techniques for statistics and qualityimprovement at blog.minitab.comLinkedIn Connect with other Minitab users linkedin.com Groups Minitab Network 2010 Minitab, Inc.

Additional ResourcesQuality Trainer, our e-Learning courseInstructor-led trainingVisit minitab.com for more information or to find contactinformation for your local Minitab representativeMichelle Paretmparet@minitab.com 2010 Minitab, Inc.

2010 Minitab, Inc. Importing Excel Files In the File Open Worksheet