From the course: Excel: Statistical Process Control
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Plot and interpret trial data using a P chart - Microsoft Excel Tutorial
From the course: Excel: Statistical Process Control
Plot and interpret trial data using a P chart
- [Instructor] After you gather and summarize the proportional defect data for a process, you can visualize the data in a chart to determine whether your process is in control. I'll demonstrate how to create a statistical process control chart, using proportional data, using the sample file 0203 plot pchart data which is an Excel workbook you can find in the chapter two folder of the exercise files collection. This workbook contains a single worksheet, and on it you can see proportional defect data, in other words proportion of a sample that had at least one defect, and then also the mean proportion and the upper and lower control limits. Now I can summarize this data by using a chart. There are a few steps to creating exactly the chart you need but they're fairly straightforward. First you need to click any cell within the Excel table that contains your data, and then on the insert tab of the ribbon, go to the charts area, and click the line chart button, And then under 2D line click…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.