【正文】 nitab Interoperability Excel Minitab PowerPoint 169。The National Graduate School of Quality Management ? 15 Menu Bar Graph Window Editor Menu Key Functions ?Advanced Edit and Display Options ?Brushing ?Graph Manipulation ?Colors ?Orientation ?Font 169。The National Graduate School of Quality Management ? 11 Menu Bar Stat Menu Key Functions ?Advanced Statistical Tools and Graphs ?Hypothesis Tests ?Regression ?Design of Experiments ?Control Charts ?Reliability Testing 169。The National Graduate School of Quality Management ? 7 Menu Bar File Menu Key Functions ?Worksheet File Management ?Save ?Print ?Data Import 169。The National Graduate School of Quality Management ? 3 Worksheet Format and Structure Session Window Worksheet Data Window Menu Bar Tool Bar 169。169。The National Graduate School of Quality Management ? 4 Text Column C1T (Designated by T) Numeric Column C3 (No Additional Designation) Data Window Column Conventions Date Column C2D (Designated by D) 169。The National Graduate School of Quality Management ? 8 Menu Bar Edit Menu Key Functions ?Worksheet File Edits ?Select ?Delete ?Copy ?Paste ?Dynamic Links 169。The National Graduate School of Quality Management ? 12 Menu Bar Graph Menu Key Functions ?Data Plotting Capabilities ?Scatter Plot ?Trend Plot ?Box Plot ?Contour/3 D plotting ?Dot Plots ?Probability Plots ?Stem Leaf Plots 169。The National Graduate School of Quality Management ? 16 Menu Bar Window Menu Key Functions ?Advanced Window Display Options ?Window Management/Display ?Toolbar Manipulation/Display 169。The National Graduate School of Quality Management ? 20 Starting with Excel... Load file “Sample 1” in Excel…. 169。The National Graduate School of Quality Management ? 24 Move to Minitab... Select Paste from the menu and the data will be inserted into the Minitab Worksheet…. 169。The National Graduate School of Quality Management ? 28 Use Minitab to do the Analysis... ?Minitab now does the analysis and presents the results... ?Note that in this case there is a graph and an analysis summary in the Session Window… ?Let’s say we want to use both in our PowerPoint presentation…. 169。The National Graduate School of Quality Management ? 32 Transferring the Analysis... ?Our Minitab graph is now pasted into the powerpoint presentation…. We can now size and position it accordingly…. 169。The National Graduate School of Quality Management ? 36 Presenting the results.... ?Now all we need to do is tune the presentation….. ?Here we position the graph and summary and put in the appropriate takeaway... ?Then we are ready to present…. 169。The National Graduate School of Quality Management ? 40 Pareto Chart.... Fill out the screen as follows: ?Our data is already summarized so we will use the Chart Defects table... ?Labels in “Category”… ?Frequencies in “Quantity”…. ?Add title and hit OK.. 169。The National Graduate School of Quality Management ? 44 Histogram.... Fill out the screen as follows: ?Select GPA for our X value Graph Variable ?Hit OK….. 169。The National Graduate School of Quality Management ? 48 Histogram.... ?Select Graphical Summary…. ?Select OK….. ?Select OK again on the next screen... 169。The National Graduate School of Quality Management ? 52 Histogram.... Fill out the screen as follows: ?Select filler 1 for the Y Variable…. ?Select head for the X Variable ?Select OK….. 169。The National Graduate School of Quality Management ? 56 Boxplot.... Fill out the screen as follows: ?Select “filler 1” for our Variable…. ?Select Graphs….. 169。The National Graduate School of Quality Management ? 60 Boxplot.... Fill out the screen as follows: ?Select “filler 1” for our Y Variable…. ?Select “head” for our X Variable…. ?Select OK….. 169。The National Graduate School of Quality Management ? 64 Scatter Plot.... Fill out the screen as follows: ?Select GPA for our Y Variable…. ?Select Math and Verbal for our X Variables….. ?Select OK when done... 169。The National Graduate School of Quality Management ? 68 Scatter plot.... ?There is another way we can generate these scatter plots…. ?Go to: ?Graph… ?Matrix Plot... 169。The National Graduate School of Quality Management ? 72 PROCESS CAPABILITY ANALYSIS 169。The National Graduate School of Quality Management ? 76 Note that the data does not fit the normal curve very well... Note that the Long Term capability (Ppk) is . This equates to a Z value of 3*= standard deviations or sigma values. This equates to an expected defect rate PPM of 147,055. INTERPRETING THE DATA…. 169。The National Graduate School of Quality Management ? 80 Set up the Test ?We will test the “Before” column of data…. ?Check AndersonDarling ?Click OK 169。The National Graduate School of Quality Management ? 84 ?Now that we have our data stacked, we are ready to test for equal variances.… ?Go to Stat… ANOVA…. Test for equal Variances... Checking for equal variance.. 169。The National Graduate School of Quality Management ? 88 ?Since we already have our data stacked, we will load C4 for our samples and C3 for our subscripts. Setting up the test…. ?Since we have already tested for equal variances, we can check off this box… ?Now select Graphs…. 169。The National Graduate School of Quality Management ? 92 Paired Comparisons ? In paired parisons we are trying to “pair” observations or treatments. An example would be to test automatic blood pressure cuffs and a nurse measuring the blood pressure on the same patient using a man