How to Make an Individuals Control in MS Excel 2007



The time-series data I analyzed in the video is gas use data (in 100s of cubic feet) of natural gas used at my home on a daily basis over a period of 30 consecutive days. The Individuals Control Chart (or I-Chart) can help determine if the process of gas use is stable (with respect to mean level). If any points exceed the control limits, we conclude the process is not stable.

17 thoughts on “How to Make an Individuals Control in MS Excel 2007

  1. Please correct me if this is wrong. "UCL = CL + 2.66*Moving range", why should we “2.66” here, since we are looking for 3 sigma isn’t that we should use UCL as “CL + 3 *Moving range “. Though it doesn't make much difference here, however when we compute/analyze large data there may be a difference.

Leave a Reply

Your email address will not be published. Required fields are marked *