The Origin Forum - Creating Gauss-shaped Plots of discrete values

The Origin Forum

Username:	Password:
Save Password
Forgot your Password? \| Admin Options

All Forums

Origin Forum

Creating Gauss-shaped Plots of discrete values

New Topic

Reply to Topic

Printer Friendly

Author

Topic

chemist99

Germany
3 Posts

Posted - 01/09/2014 : 09:21:33 AM

Origin Ver. and Service Release : 8.5.0 SR1
Operating System: Windows XP, SP3

Hello there,
I'm having a little problem with plotting discrete values in a very special fashion. In principle I'm trying to do a standard column plot for a set of discrete values. The problem is, that instead of the normal, rectangular, "boxlike" columns I'm supposed to create a gaussian distribution for each of the values on the x-axis.
So basically I'd like to have a column plot, with the colums looking like gaussian distributions instead of simple boxes.

Until now this has always been done using an Excel file where you input the set of x- and y-values and it then automatically calculates a gaussian distribution around each of the x-values. You can then change the coefficients of the gauss function manually by changing the corresponding input fields of the excel sheet. This way you can control the "signal shape" i.e. broadness, distance of the signals etc. In the end all these recalculated values are then transferred to Origin and plotted as a simple "line plot". This works of course but is extremely clumsy and error prone and just takes a lot of time if you have bigger datasets.

I'm neither a programmer nor a mathematician, but as I understand it, this amounts to a kind of gaussian blur used e.g. in image processing, right?
So far I've only used Origin for simple plotting and statistics but my experience seems to tell me that there is very little in the way of visualizing data which can't be done using origin.
So if anyone has any idea or a hint to another topic dealing with similar problems I'd be very grateful.

I hope I didn't create this topic uselessly, but at least I didn't find any similar topics with the search term "gauss" or "column plot".

Sam Fang

293 Posts

Posted - 01/09/2014 : 9:23:52 PM

Can you show us a sample graph for your problem? Then we may understand your question better.

Thanks.

Sam
OriginLab Technical Services

chemist99

Germany
3 Posts

Posted - 01/10/2014 : 04:14:22 AM

Hi Sam,
Thanks for your quick answer.
What im trying to do is this:

or if the link itself works better: http://de.tinypic.com/view.php?pic=1zvy7o8&s=5

So if I give Origin a table of x- and y-values I'd like it to plot a graph like the one on the right. Of course for it's pure information value both plots are the same, but for some uses the right version is deemed more "presentable".

Sam Fang

293 Posts

Posted - 01/10/2014 : 05:01:57 AM

Thanks for your explanation. It can be done using cumulative gauss functions in Origin. I used Set Column Values tool to produce data for the graph in the following example.

1. Set column A's data in Set Column Values dialog as:


data(0,6,0.001)

2. Set column B's data in Set Column Values dialog as:


nlf_GaussAmp(col(A),0,1,w,7)+nlf_GaussAmp(col(A),0,2,w,14)+nlf_GaussAmp(col(A),0,3,w,16)+nlf_GaussAmp(col(A),0,4,w,21)+nlf_GaussAmp(col(A),0,5,w,9)

In Before Formula Scripts box, type:

double w=0.04;

3. Use column A and B to plot a line, you can get a graph similar to the right one. You can also change w value to adjust the broadness.

Sam
OriginLab Technical Services

Edited by - Sam Fang on 01/10/2014 05:03:09 AM

chemist99

Germany
3 Posts

Posted - 01/10/2014 : 09:23:14 AM

Hi Sam,
Wow! Thanks for this solution. Absolute genius. I'm probably the only person who needs this, but you just saved me hours of work time normally wasted on dreadful spreadsheets with the exact same result. It looks exactly as its supposed to. And I'd never figured that one out on my own.

Thanks again and have a nice day

Edited by - chemist99 on 01/10/2014 09:23:45 AM

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

The Origin Forum

Snitz Forums 2000