AnsweredAssumed Answered

Standard deviation data set up for chart

Question asked by Stu412 on Jul 15, 2016
Latest reply on Jul 15, 2016 by jbante

Hi there

 

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.

 

Thanks

Outcomes