Standard Deviation in Spotfire Expressions and Visualizations – Part 2 of 2

There are many different ways to use standard deviation in TIBCO Spotfire – the video in this post shows 6 different examples of how you can use standard deviation in Spotfire to learn more about your data.

For example, we can make statistical outliers stand out with color to alert us when a condition deviates outside of the desired range:

The topic for this blog post was submitted by a reader through the “What do you want to learn more about” box on the right side of this page (or possibly near the bottom if you’re viewing on your phone). If you submitted the idea – thank you!!

When I started recording this video, I realized that it would end up being much longer than expected. I like to keep the videos fairly short so I decided to split this post into 2 parts. The video below covers #3 in the list below, and the previous post covers the first 2

To download the Excel & Spotfire files shown in the video, just [ninja-popup ID=1448] click here. [/ninja-popup]

In this 2-part blog post I cover 3 things:

  1. What standard deviation is and how to calculate it
  2. Why it’s important and what it’s used for
  3. How to use standard deviation in TIBCO Spotfire with the following features and visualizations:
    1. Calculated Column (with OVER function)
    2. Histogram
    3. Box Plot
    4. Scatter Plot
    5. Summary Table
    6. Binned Column

If the embedded player above isn’t working, this video is also on YouTube:

Questions / Comments
If you have any questions or comments, or if there’s something you’d like featured on this blog, feel free to email me at or leave a comment below.

Leave a Reply

Your email address will not be published. Required fields are marked *