Gaussian ( _x ; _height ; _center ; _sigma )
Rate this function: Average rating: 3.8 (4 votes) Discuss this Custom Function
Thomas Seidler, The Good Book Company
http://harmlesswise.com/it
Gaussian function to enable a controllable bell shaped graph.
Sample Input:
Let ( [ _height = 1.2 ;
_sigma = .35;
_center = 1.1;
_offset = -.17575 ];
Limit ( 0 ; 1 ; Gaussian ( 0 ; _height ; _center ; _sigma ) + _offset ) & " || " &
Limit ( 0 ; 1 ; Gaussian ( .1; _height ; _center ; _sigma ) + _offset) & " || " &
Round ( Gaussian ( .2 ; _height ; _center ; _sigma )+ _offset ; 2) & " || " &
Round ( Gaussian ( .5 ; _height ; _center ; _sigma ) + _offset; 2) & " || " &
Round ( Gaussian ( .9 ; _height ; _center ; _sigma )+ _offset ; 2 )& " || " &
Round ( Gaussian ( 1 ; _height ; _center ; _sigma )+ _offset ; 2 )
) |
|
Sample Output:
| 0 || 0 || .05 || .4 || .93 || 1 |
|
Description:
If you need to see the graph you plot: http://www.walterzorn.com/grapher/grapher_e.htm
I wanted a nice smooth colour shift from red to green, not going via murky brown, but via brighter shades of orange...
You need some heavy curve control to do that! ;) The example input there is the curve i use for the green (*255!)... i think it works nicely (i used (1-(x^5))*255 for the red (blue=0)).
No doubt it has other uses in statistical analysis etc, though there are functions already up there on that front.
Note: these functions are not guaranteed
or supported by BrianDunning.com. Please contact the individual
developer with any questions or problems.
This is my Custom Function and I want to
edit it
Discuss:There are no comments yet. Be the first to post a comment about this Custom Function! Please try to keep it brief & to the point. Anyone can post:
|
Newest Custom Functions:
| 1. |
GroupRelationInfo ( FileTarget ; TableTarget ; Result ) |
| |
(Tue, Mar 16, 5:57am) |
| 2. |
GeoBox(latitude;longitude; radius) |
| |
(Mon, Mar 15, 11:04am) |
| 3. |
MonthNameList ( start; number; short ) |
| |
(Sun, Mar 14, 11:45pm) |
| 4. |
matchListAB( ListA ; ListB; match_Value; match_operator ; getN ) |
| |
(Sun, Mar 14, 10:29pm) |
| 5. |
Bin2Hex ( binary ) |
| |
(Sat, Mar 13, 10:08pm) |
| 6. |
SlideView (text) |
| |
(Sat, Mar 13, 8:40pm) |
| 7. |
HashFNV1a64 ( text ; empty ) |
| |
(Sat, Mar 13, 6:23pm) |
| 8. |
HashFNV1a32 ( text ; empty ) |
| |
(Sat, Mar 13, 5:55pm) |
 |
|