From the course: Excel: Statistical Process Control

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Calculate the mean and standard deviation of defect count data

Calculate the mean and standard deviation of defect count data - Microsoft Excel Tutorial

From the course: Excel: Statistical Process Control

Start my 1-month free trial

Calculate the mean and standard deviation of defect count data

“

- [Instructor] When you count the number of defects in a manufactured product, such as the number of nonfunctioning pixels on a computer monitor, you can summarize the data by finding the average and standard deviation of the counts. While the average calculation is the same as it is for regular data sets, finding the standard deviation requires a different calculation. I will demonstrate how to do this in Excel. My sample file is 0302C Chart Mean and SD, which you can find in the chapter three folder of your exercise files collection. In this data set I have 16 samples and then the number of defective pixels from each of the sample units. What I want to find are the mean, that is, the average number of defective pixels per sample, and then calculate the standard deviation and then go plus or minus three standard deviations to see where the 99.7% of all values range falls. First, to calculate the mean, I will find the average of all the values of the defective pixel counts in column…

Contents