Private Library for Business-Only Content.

Lynda – Curt Frye – Excel: Statistical Process Control

Lynda.com.Excel.Statistical.Process.Control.2018.04.09
[19 WebRips (MP4) 19 Subs (SRT) Ex.Files (XLSX)]

Category:
This product can only be requested by members. To get this product, you must be a member
Apply for Membership

Description

Excel: Statistical Process Control
(Including Exercise Files & Subs)
Instructor: Curt Frye
Skill Level: Intermediate
Business, Business Intelligence, Spreadsheets, Excel
Duration: 1h 14m
Released: April 9, 2018

Lynda PageLinkedIn Learning Page

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

Table of 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

About the Instructor:

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.


Filename………….: 03. Statistical_process_control.mp4
Duration………….: 3 min 44 s
Size……………..: 5.20 MiB
Overall bit rate…..: 194 kb/s

Video #0
Codec…………….: AVC
Resolution………..: 1280×720
Aspect ratio………: 16:9 (1.778)
Bit rate………….: 60.0 kb/s
frame rate………..: 30.000 FPS

Audio #0
Format……………: AAC ()
Channels………….: 2 channels
Bit rate………….: 128 kb/s
Sampling rate……..: 48.0 kHz
Language………….: English


Reviews

There are no reviews yet.

Be the first to review “Lynda – Curt Frye – Excel: Statistical Process Control”
Quick Navigation
×
×

Cart