Tree Diagram


© 2007 KnowWare International, Inc. DBA LifeStar
2253 S. Oneida St., Ste 3D
Denver, CO 80224

Jay Arthur
888-468-1537
303-756-9144
Email Us

We help people think!

TREE DIAGRAMTree Diagram in Excel

Purpose: To systematically link ideas, targets, objectives, goals, or activities in greater and greater detail.

The tree diagram can map specific tasks to primary and secondary goals. It maps the methods required to achieve corporate goals. The tree diagram shows the key goals, their sub-goals, and key tasks. It can help identify the sequence of tasks or functions required to accomplish an objective. The tree diagram can help translate customer desires into product characteristics. It can also be used like an Ishikawa diagram to uncover the causes of a particular problem.

Process

  1. Develop a clear statement of the problem, issue, or objective to be addressed. Place it on the left side of a board, wall, or easel and work toward the right.
  2. Brainstorm all of the sub-goals, tasks, or criteria necessary to accomplish or resolve the issue.
  3. Repeat this process using each of the sub-goals until only actionable tasks or elements remain.
  4. Check the logic of the diagram in the same way as the Ishikawa: Start at the right and work your way back to the left by asking: ³If we do this, will it lead to the accomplishment of the previous task?²

The tree diagram is just one of the tools included in the QI Macros for Excel SPC Software for Excel.

 

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

Buy the QI Macros Now! Unconditional, No Questions Asked, 90-day Money-Back Guarantee!

Buy QI Macros Excel SPC Software for Histograms and Control Charts Now QI Macros Excel SPC Software for Histograms and Control Charts $139 Plus S&H


© 2007 KnowWare International Inc. (888) 468-1537
knowwareman@qimacros.com
Home | Lean Six Sigma | QI Macros | KnowWare | Site Map

QI Macros 30-day Trial & FREE QI Macros Course
Name:
E-mail
 

QI Macros SPC Software for Excel
Or Buy It Now!
Unconditional
90-Day
Money-Back
Guarantee

The QI Macros for Excel $139, is an inexpensive easy to use set of Excel add-ins for statistical process control and Lean Six Sigma. It draws line, pie, bar, pareto, box whisker, histogram (Cp, Cpk), scatter and control charts (with stability analysis).

It contains over 70 fill in the blank templates such as the Ishikawa diagram, QFD, DOE, FMEA, PPAP, and Gage R&R for MSA. Performs ANOVA, t-test, F-test, and regression analysis.

Buy All-in-One, Excel SPC Software Now

Quantity Discounts

Customer Testimonials

Minitab Comparison

QI Macros FAQs

FREE Lean Six Sigma Course
& QI Macros 30-day Trial
Name:
E-mail