From the course: Excel: Statistical Process Control
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Calculate averages and ranges for X-bar R charts - Microsoft Excel Tutorial
From the course: Excel: Statistical Process Control
Calculate averages and ranges for X-bar R charts
- [Narrator] X-bar and R charts offer great insights - [Instructor] X-Bar and R charts offer great insights into your variable data, but it can be difficult into your variable data but it can't be difficult to calculate to calculate the appropriate standard deviations the appropriate standard deviations and upper and lower control limits. and upper and lower control limits. Fortunately, statisticians have worked out the equations we need to find those limits. we need to find those limits. In this movie I'll show you how to find the averages, In this movie, I'll show you how to find the averages, as well as the upper and lower control limits for X-Bar, R chart pairs. What we're doing is finding the average of averages What we're doing is finding the average of averages for two quantities across multiple samples. We are looking at the average of averages of measurements in a sample, of measurements in a sample and also the range of measurements in a sample. If you want to see what the…
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.