Box and Whisker Plot Diagram in Excel


© 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!

Box and Whisker Plot Diagrams

Box and Whisker Plot diagrams are used to analyze variation and central tendency of data due to time, parts, and production tools. The box represents the distance between the 1st and 3rd quartiles. The whiskers show the highest and lowest data points or 1.5 times the box (Q3-Q1). Outlier points are those that are greater than 1.5 times (Q3 -Q1).

  • If the box is all yellow, then there is no difference between the 1st quartile and the median.
  • If the box is all green, there is no difference between the 3rd quartile and the median.

Box and Whiskers

Here are some examples of Box and Whisker Plot diagrams created using the QI Macros for Excel SPC software.

Box and Whisker showing a process over time.

Box and Whisker Plot Diagram

Box and Whisker Plot Diagram showing variation among devices.

Box and Whisker Plot Diagram

The Box and Whisker Plot 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

For more information see:
http://www.itl.nist.gov/div898/handbook/eda/section3/boxplot.htm


© 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