From the course: Excel: Statistical Process Control
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Plot and interpret trial data using an X-bar R chart - Microsoft Excel Tutorial
From the course: Excel: Statistical Process Control
Plot and interpret trial data using an X-bar R chart
- [Instructor] After you calculate the average and upper and lower control limits of your variable data, you can create X bar and R charts to analyze it. In this movie, I'll show you how to best construct an Excel worksheet to create your charts. My sample file is 04 03 X bar R chart. And you can find it in the chapter four folder of the exercise files collection. I have two sets of data in this workbook on its only worksheet. On the left I have an Excel table that has data for the X bar chart. And, on the right, I have a table for the R chart. On the left, you'll see that I have seven samples. I have the X bar, which is the average of all averages. And then the upper and lower control limits. I've included the upper and lower control limits as well as the overall average in each row of the table so I get horizontal lines in the chart when I create it. In the same way for the R chart, I have my sample number and then the range between the largest and smallest value. And then 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.