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.

Get Download Curt Frye – Excel: Statistical Process Control at coursesblock.com today!

Delivery Method

– After your purchase, you’ll see a View your orders link which goes 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 coursesblock.com
– Since it is a digital copy, our suggestion is to download and save it to your hard drive. In case the link is broken for any reason, please contact us and we will resend the new download link.
– If you cannot find the download link, please don’t worry about that. We will update and notify you as soon as possible at 8:00 AM – 8:00 PM (UTC 8).

Thank You For Shopping With Us!