Skip to content

Using SPC & RAG rating

Best Practice:
Where possible, products should use Statistical Process Control (SPC) to show variation over time. SPC is a powerful tool for distinguishing between normal fluctuation and meaningful change, supporting better decision-making and reducing overreaction to single data points.

For national guidance and methodology, refer to:
Making Data Count – NHS Improvement

When to Use SPC

SPC should be applied when:

  • Time series data is available (typically ≥10 points)
  • The product aims to identify improvement, deterioration, or stability
  • Variation analysis is key to the product’s purpose

Where SPC is used, always include a brief explanation of what SPC is by included a link to user-friendly SPC guidance.

A table outlining how to interpret an SPC chart

Interpreting an SPC Chart

Alternative SPC

A simplified view of SPC trend (found in FDP) uses the following terms:

  • Improved
  • Sustained
  • Deteriorated

FDP Variation Logic

RAG Rating

RAG (Red, Amber, Green) ratings are a simple yet effective way to visually communicate the status or health of a metric, project, or task. They provide an immediate understanding of what's on track, what needs attention, and what's at risk. To ensure consistency across all our products, please adhere to the following color palette:

A reference table outlining the correct colour is included below

Diagram of RAG colours

When to Use RAG Ratings

RAG ratings should be used when you need to convey a quick, high-level status. This could include: Project progress updates Performance against key metrics (KPIs) Risk assessments Task completion status

Enhancing RAG Ratings with Arrows

To provide even greater clarity and indicate trend, consider incorporating arrows alongside your RAG ratings. These arrows visually represent whether the status is improving, worsening, or remaining stable since the last reporting period.

A reference table outlining the correct arrows to use is included below

Diagram of RAG arrows

By consistently applying these RAG colors and utilising trend arrows, we can ensure that our data products are not only informative but also immediately actionable, enabling our stakeholders to quickly grasp the key takeaways