I'm looking to move data from Excel to FM and produce charts from it. These charts will be the typical bell curves that a standard deviation range produces happily at the moment in Excel.
I'm having a couple of issues around the NORMDIST and STDEV(p) calculations. I should also add at this point I am certainly no mathematician!!
I've set up a table to test with which simply has 4 fields:
- dData - the data values which are sorted low to high
- cDistribution - is a calculation field which uses the custom function from here : FileMaker Custom Function:_Normsdist ( z )
- cAverage - A native summary (average) calculation
- cStdDev - A native calculation StDev (dData) <<< I think this needs another parameter, but not sure
I've set things up this way as it matches what I've done on Excel and when the results are plotted I get a lovely smooth curve.
I can plot the results on here, but the values differ somewhat from Excel and the curve is far from smooth as a result.
Appreciate any help on this.