Eclipse Community Forums Forum Search:

Home » Archived » BIRT » Bell Curve Chart in BIRT
Bell Curve Chart in BIRT Thu, 25 October 2012 04:57
 mark wenMessages: 2Registered: October 2012 Junior Member
Hi everyone,

Does anybody know how to generate Bell Curve (a.k.a normal distribution) chart in BIRT? This is not a built-in chart type.

Mark

[Updated on: Thu, 25 October 2012 10:30]

Report message to a moderator

Re: Bell Curve Chart in BIRT [message #965957 is a reply to message #957244] Wed, 31 October 2012 16:43
 Alex RodriguezMessages: 1Registered: October 2012 Junior Member
mark wen wrote on Thu, 25 October 2012 00:57
Hi everyone,

Does anybody know how to generate Bell Curve (a.k.a normal distribution) chart in BIRT? This is not a built-in chart type.

Mark

I have the same situation I need to generate a Bell Courve with BIRT, does any one know how to do it? From what I have seen in Excel methods:
1. You will have to have a set of data with a normal distribution
2. You will have to calculate Standar Deviation and the mean
3. You will have to grade the courve
For points 2 and 3 I think formulation expressions must be used as I do not see statistical functions in BIRT to calculate mean or Dev.
4. You will have to generate values according to the grading sections, the devstd and the mean. I'm trying to do it with cubes and expressions.
5. After you can generate a cube with the frecuency values according to grading, It could be possible to graph the Bell Courve using Scattered chart type.
I'm in the process of doing it but still working on it. The hard thing is creating the DevStd and Mean formulations.

This is what I'm trying following and Excel example I'm attaching, but still have not been able to finish it. I hope it helps.

If you have any luck please get back to me and give me a hand, If I get ti done I'll sure write to you via this forum.

Best regards,

Alex Rodriguez - Avanxo

Re: Bell Curve Chart in BIRT [message #966141 is a reply to message #957244] Wed, 31 October 2012 19:54
 andrew smithMessages: 43Registered: February 2012 Member
Here is what I would recommend on this:

all you need is a series of x,y pairs which when plotted produce the scatter plot.
The scatter plots are indeed supported by BIRT and BIRT is an excellent tool for plotting. Further BIRT's charging capabilities can be extended as well.

The following are the steps that you need to do:
1) Given \sigma (standard dev) and \mu (mean of the distribution), generate values of x that cover the region of interest. For example you could start with the following X vector: [-5,-4.9,....4.9,5]

2) Now that you have your x values, stick every one of them into the equation for normal destribution, so that you can produce correspoding y-values.

NOTE: now you have x,y pairs that define your distribution.

3) Next create a scripted data source. There is an excellent example on that on the BIRT's website

4) Next use scatter or a line chart and use your scripted datasource.

5) Once you run the report, you will see the normal distribution...

Hope this helps...
Re: Bell Curve Chart in BIRT [message #966337 is a reply to message #966141] Wed, 31 October 2012 23:25
 mark wenMessages: 2Registered: October 2012 Junior Member
It surely helps.

Many thanks, guys.

 Previous Topic: JNDI configuration for BIRT report designer Next Topic: Creating a list
Goto Forum:

Current Time: Wed Feb 08 15:05:16 GMT 2023