• Preview of Voice of the Customer and CTQ Tree TemplateExcel workbook preview

Six Sigma and Statistical Quality

Voice of the Customer and CTQ Tree Template

$17.99 Free XLSX
Excel workbook · 12 KB

3 downloads per free account, no card needed.

Need more than 3? Get all 300 templates for $249 One payment, lifetime access, including every template added later.

Who this is for

A project lead who has customer complaints and survey comments on the desk and must turn them into measurable requirements before the Measure phase.

What is inside

  • VOC table: 10 sample customer verbatims from complaints, surveys, interviews and lost orders
  • Each verbatim translated to need, driver and a measurable CTQ with an operational definition
  • Live status column compares current performance with the target in the right direction
  • Kano class (must-be, performance, delighter) and priority 1 to 5 dropdowns
  • CTQ tree sheet: 3 needs broken down into 7 drivers and CTQs with specifications
  • 20 blank rows, red and green status colouring, frozen header and filter

How to use it: Paste real customer words into the verbatim column first, then translate each one; a CTQ is only finished when it has a unit, a target and an operational definition.

Files & formats
  • XLSXvoice-of-the-customer-ctq-tree-template.xlsx12 KB

Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.

Free downloads & full access

Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.

Bought with a different email? Open your account and enter your order number.

Licence

Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.