• Preview of Hypothesis Test Selection Guide and Test LogExcel workbook preview

Six Sigma and Statistical Quality

Hypothesis Test Selection Guide and Test Log

$7.99 Free XLSX
Excel workbook · 16 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 Green Belt in the Analyze phase whose coach asks which test was used, why, and what the p-value means for the project, at the tollgate.

What is inside

  • Selection guide: 12 common questions mapped to the test, assumptions and Excel function
  • Each test linked to its NIST/SEMATECH e-Handbook section (7.2 to 7.4)
  • Test log with 10 sample tests: hypotheses, alpha, statistic, p-value and live decision
  • Two-sample t calculator (Welch) with 12 + 12 readings, live t, df and p-value
  • Two-proportion test calculator with pooled z and two-sided p-value
  • Decision column colours reject and fail to reject, 20 blank log rows

How to use it: Write the question and the hypotheses before you look at the data, choose the test from the guide, and log every test you run, including the ones that showed nothing.

Files & formats
  • XLSXhypothesis-test-selection-guide-template.xlsx16 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 $7.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.