Skip to main content
SpringerLink
Log in

On the use of V-mask techniques to estimate variations in Cusum control charts by using a commercial spreadsheet

  • Practitioner's Report
  • Published:
Accreditation and Quality Assurance Aims and scope Submit manuscript

Abstract

The laboratories verify data from control samples through the application of typical control charts by using commercial spreadsheets. The criteria to decide whether a measurement procedure is in statistical control involves the interpretation of the control chart after each analytical run although the decision is not always practical. So, to detect long term trends in the process, a Cusum chart graphic representation can be implemented. The use of a V-mask verification tool will show the point from which the deviations are significant. Since the construction of a V-mask is complicated in practice, in this article is proposed the definition of a visual representation and also how to construct a tabular procedure with a commercial spreadsheet form in which the V-mask serves as control limits for the Cusum chart.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig. 6
Fig. 7

References

  1. ISO 8258:1991, Shewhart control charts, International Organization for Standardization (ISO), Geneva, Switzerland

  2. ISO 7870-3:2012, Control charts—Part 3: Acceptance control charts, International Organization for Standardization (ISO), Geneva, Switzerland

  3. ISO 7870-4:2011, Control charts—Part 4: Cumulative sum charts, International Organization for Standardization (ISO), Geneva, Switzerland

  4. Miller JC, Miller JN (1988). Statistics for analytical chemistry. Ellis Horwood Limited, Chichester pp.92–98

  5. Nordtest Report TR 569 (2006). Internal quality controll—handbook for chemical laboratories

  6. Montgomery DC (2000) Introduction to statistical quality control. Wiley, New York

  7. Woodall WH, Adams BM (1993). The statistical design of Cusum charts. Qual Eng 5: 559–570

    Google Scholar 

  8. Sánchez I (2008) Métodos estadísticos para la mejora de la calidad—Cap. 5. Universidad Carlos III de Madrid

  9. Ojeda FC (2007) Cálculos Estadísticos con Excel. ed Anaya

  10. Pérez C (1995). Análisis Estadístico con Statgraphics. ed. Ra-Ma

Download references

Author information

Authors and Affiliations

  1. RPS-Qualitas S.L. Consultoría de Calidad y Laboratorios, C/Marqués de Corbera 62, 7º, 28017, Madrid, Spain

    José Miguel Silván, Pedro Rosario & José Luis Martínez

Authors
  1. José Miguel Silván
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Pedro Rosario
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. José Luis Martínez
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to José Luis Martínez.

Additional information

This approach has been attached as a simple spreadsheet in mainstream software available in the online version of this article

Electronic supplementary material

Below is the link to the electronic supplementary material.

Supplementary material 1 (XLS 73 kb)

Rights and permissions

Reprints and permissions

About this article

Cite this article

Silván, J.M., Rosario, P. & Martínez, J.L. On the use of V-mask techniques to estimate variations in Cusum control charts by using a commercial spreadsheet. Accred Qual Assur 18, 299–306 (2013). https://doi.org/10.1007/s00769-013-0992-9

Download citation

  • Received:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s00769-013-0992-9

Keywords

Search

Navigation