| T O P I C R E V I E W |
| hajo_old |
Posted - 08/16/2004 : 3:13:24 PM
Hello, all
I just had to create some histograms / box charts to check some of our production data.
Using the box chart leeds to really nice and informative graphs, but I'm not able (as far as I can see) to include some basic statistical data as numbers in some text lables somewhere on the graphic layer.
As all the values are shown in the box chart (mean, median, SD, SE ....) they somewhere are calculated, but I can't see any possibility to directly access them and print out the values!
The only way seems to be to perform an additionally column statistic calculation and include the values from the new created worksheet!
Could there be a shortterm solution for that?! I would need something without heavy coding in about a week!
An other point is the labeling of the box chart. You can choose different attributes like Min/Max, whiskers, SD or SE (only few of them) to get the box more informative.
If you choose the attribute you can also set a "coef."-value (a sort of gain factor) for display purpose. The label that shows up should be in the format
e.g.:
3*sd (coef * whisker)
NOT only +/- SD as that is WRONG at that place (in my opinion)!
I would add that by hand, but I didn't manage to edit that labels!
Also, there should be a legend available you can set somewhere on the layer, to describe the symbols you use for the Mean/Median/... values at the box plot.
like (I write out everything as there's only ASCII available):
red (-) Min
red (+) Max
red (#) Median
....
Hope that all was understandable ...
Feel free to ask mor details ...
Thanks in advance
Hajo
-- --
Dipl.-Ing. Hans-Joerg Koch
SiemensVDO Automotive
Regensburg
Edited by - hajo on 08/16/2004 3:14:58 PM |
| 2 L A T E S T R E P L I E S (Newest First) |
| cpyang |
Posted - 08/16/2004 : 9:53:16 PM
Hi Hajo,
Your best bet would be to use the Data_percentiles function in Origin C and combine that with Data_sum function. These routines were used internally to calculate the box chart anyway.
This area are going to be reworked in Origin 8 to allow easy access to the tables that make up those charts.
CP
|
| Mike |
Posted - 08/16/2004 : 4:17:47 PM
Hajo...will you go to sleep?!! (just kidding)
First of all, make sure that you have the most up-to-date documentation on the Box Chart. We revised and added to this topic after 7.5 was released. If needed, you can get the Origin 7.5 SR4 Help file (included in a ZIP file called OriginHelp_75_SR4.zip here).
To show relevant worksheet data along with your Box Chart, you would need to use the Layout Page.
You are correct: To get the statistics that correspond to the various Box Chart display options (mean, median, SD, SE, etc.), you would have to do a Descriptive Statistics:Statistics on Columns on your worksheet data.
You are also correct about the labeling bug -- when you choose a Coef value for SD, it should clearly indicate the multiplication factor (but does not). I will submit a bug report asking that this be fixed.
Lastly, I will enter a separate item requesting that the user have the option to create a special legend for symbols used in the Box Chart (presumably only necessary when the labelling options are not used (Box tab)).
Mike
OriginLab
Edited by - Mike on 08/16/2004 4:18:41 PM |
|
|
