Excel: Statistical Process Control – Curt Frye
Excel: Statistical Process Control
By: Curt Frye
Level: Intermediate
Duration: 1h 14m
Released: April 9, 2018
Description:
Learn how to analyze the accuracy and alignment of manufacturing processes using statistical tools. Veteran Excel trainer Curt Frye covers the three types of charts-P charts, C charts, and X-bar R charts-that are used to summarize the most common process metrics: proportion of defective output, number of defects, and variability of process outputs. He shows how to perform the analysis, plot the data, and interpret the results of each technique. He also how to examine processes from the customer’s perspective using process capability analysis. Business analysts and support staff who help prepare documents, as well as executives and senior managers who might not have a statistical background, will use the skills in this course to analyze their organizations’ processes and output.
Topics include:
- Performing statistical analysis
- Analyzing with P charts
- Creating a modified P chart
- Analyzing defects with C charts
- Analyzing variables with X-bar R charts
- Performing process capability analysis
Contents:
- Introduction
- 1. Performing Statistical Analysis
- 2. Analyzing Defective Output Using P Charts
- 3. Analyzing Defects Using C Charts
- 4. Analyzing Variables Using X-Bar R Charts
- 5. Performing Process Capability Analysis
- Conclusion
Author:
Curt Frye is a freelance course developer and writer. He has developed more than 50 online courses on topics including Microsoft Excel, Tableau, Mathematica, and social network analysis. He has also written more than 40 books, with recent titles including Microsoft Excel 2016 Step by Step and Microsoft OneNote 2016 Step by Step, both for Microsoft Press.
In addition to his writing and course development, Curt is a popular conference speaker and entertainer. His programs include his Improspectives® approach to teamwork and creativity, analyzing and presenting data in Microsoft Excel, and his interactive Magic of the Mind show.
Access Download Excel: Statistical Process Control – Curt Frye right now!
Delivery Method:
After your purchase, you’ll get access to the downloads page. Here, you can download all the files associated with your order.
Downloads are available once your payment is confirmed, we’ll also send you a download notification email separate from any transaction notification emails you receive from Coursedownloads.