How Do You Create Control Charts In Excel?
A control chart is a statistical process control tool used to visualize a complex set of data. The purpose of a control chart is to view a set of recurring numerical data compared with its average and upper/lower control limits to test the reliability of process outputs. Examples of effective uses of control charts include measuring how much of a certain component is found in daily batches of a mixture, and measuring the amount of time it takes to perform a daily task. Create a two-columned table; enter the dates or other time measuring criteria in the right column, and the data to be graphed in the left column. For example, to begin creating a control chart to measure the number of products produced on an assembly line per day, list the respective dates on the left and the corresponding production numbers on the right. Calculate the average of your entire data series by entering “=AVERAGE(first value,last value)” into any cell, and establish your desired upper and lower control limits
