Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Visualization
Created by Guest
Created on Aug 8, 2019

For Q1,Q3 or U95 and L95 error bars remove the Median or Mean

Currently for line graphs I am often plotting the median with IQR error bars or the mean with Confidence Intervals. Currently if I select Q3 for upper error bar of my median line Spotfire actually plots Q3 + the median. I then have to create a custom expression that subtracts the median from Q1 to get the error bar that matches what is typically graphed. The same is true for mean and Confidence intervals, I have to create a custom expression to subtract the mean from U95 to get the error bar that I want. When selecting Q3 and Q1 this should match what you see in a box plot and it does not (makes error bars too large). This seems inconsistent with other graphing programs. For scientific publications I have not seen anybody use error bars that include the median or mean.

I plot hundreds of graphs as do many other in my biotech company and this is a tedious process as it is now.

  • Attach files
  • Guest
    Reply
    |
    Mar 5, 2020

    Hi, I also agree with Julie it is cumbersome to need to write a formula to plot the inter-quartile ranges or confidence intervals as the error bars instead of being able to directly select them in the menu. Thanks for your consideration!

  • Guest
    Reply
    |
    Mar 4, 2020

    Thank you for the response Niklas. You are correct in what I meant. The same is true for the lower error bar in that it includes the median in addition to the quartile.

  • Admin
    Niklas Amberntsson
    Reply
    |
    Mar 4, 2020

    Julie, thanks for contributing. While I think I understand the intention, I do have some trouble understanding the details. You wrote "Currently if I select Q1 for upper error bar of my median line Spotfire actually plots Q3 + the median." Did you mean: "Currently if I select Q3 for upper error bar of my median line Spotfire actually plots Q3 + the median." ?