Tip of the Week

Error Bars are not just for use in studies and experiments

Error Bars are commonly used in the Life Sciences industry and also in research studies and experiments.  However, the use of Error Bars is much wider.  Error Bars can be used in any data table to show approved ranges of values compared to actual values.

For example, assume a sales manager in a company wants to compare the previous quarter's forecast to actual revenue for his staff.  He wants to investigate any situation where the actual revenue was more than 20% above or below the forecast.  If the forecast was within the acceptable range of tolerance, no further investigation was needed. If the revenue was more than 20% above or below, he needed to investigate why the forecast was off so much.

So, the sales manager uses Spotfire to plot his data using a Line Chart. There are two lines displayed, one for the forecast and one for the actual of all the salespeople. Error Bars where then added to the Forecast line, with the upper value set to 20% and the lower value set to 20%.

 

We can now see clearly which salespeople fell outside the acceptable range. If the line representing the actual sales numbers is not within the error bars, then we need to investigate further.

 

 

This is automatically setup as a template, meaning, the sales manager can easily load in new data at the end of the quarter and the plot will automatically be configured with the correct error bars.  If you plan on using the 20 % in other plots in the analysis, it would make more sense to store this 20% inside a Document Property (see our tip on Global Variables).



Published Nov 21 2009, 10:07 PM by Kevin Hanegan
Filed under:

Comments

 

hvmarck said:

I have also found an alternative use of the error bars: flowgrams in 454 sequencing (like the one shown in www.genengnews.com/.../454_Fig2_Flowgram.jpg ). By using the flow value used on the Y-axis as the "Lower error", and switching off the "Show end caps". That looks exactly the same!

December 9, 2009 8:26 AM
 

uggskensingtonsale said:

www.uggskensingtonsale.org

www.uggskensingtonsale.orgugg-adirondack-boots-ii-c-6.html | UGG Adirondack Boots II

www.uggskensingtonsale.orgugg-adirondack-tall-boots-c-11.html | UGG Adirondack Tall Boots

www.uggskensingtonsale.orgugg-amberlee-boots-c-34.html | UGG Amberlee Boots

www.uggskensingtonsale.orgugg-annabelle-boots-c-35.html |

December 28, 2011 4:45 AM

Leave a Comment

(required) 
(optional)
(required) 
Submit

Syndication

Other Spotfire Blogs

Spotfire's interactive information visualization and analytic solutions give users a remarkable experience for quickly and easily querying data and reporting results for superior business intelligence. From portfolio management and customer retention programs to key processes such as CRM, marketing, research, bioinformatics, yield and asset management and design for manufacturing, enterprises around the world rely on Spotfire's business analytics software to improve operational performance.

©Copyright 2000-2011 TIBCO Software Inc | Privacy Policy | Terms of Use I Blog I Contact Us I Content Center