1 Reply Latest reply on May 21, 2009 8:40 AM by philmodjunk

    FMP and integration with statistical analysis programs



      FMP and integration with statistical analysis programs


      Hi there!

      I am new to FMP and was wondering whether there is an easy (automated) way to update ongoing statistical analysis while the data set is still growing in FMP.



      for example, let's say measuring research variable for an experiment, I am collecting data for the color of apples and pears.

      so my database get pear1, apple1, pear2, pear3, apple2 all with their values for red, green and blue content.


      can I export or better automatically analyse that data stratified by type of fruit? comparing red values between apples and pears?


      at best automatically (updating)?


      of course I have a lot more variable than R,G,B... many more.


      any ideas or experiences? do I have to manually export to SPSS or STATA everytime I measure a new apple or pear?


      Thanks alot for any help




        • 1. Re: FMP and integration with statistical analysis programs

          A lot depends on the degree of sophistication you need in your statistical analysis:


          Average, Count, Max, Min, StDev, Sum and Variance are all functions that can be used to generate statistical values over an entire set of records where each record represents a single data point. You can design relationships that work with these functions so that you can generate values such as "the Standard Deviations for color values for Lot#3456". You can learn more about these by looking up "Aggregate functions" in the on line help.


          If you need more sophisticated analyis or to chart the data, you will likely need to export data to your statistical analysis software. Filemaker can export data in a variety of formats and there is a good chance that one of these formats such as tab delimitted, csv, or Excel. The export process can be automated by creating a script so that you just have to click a button to export it. What happens to the data after it's exported will depend on the capabilities of your statistics software.


          Filemaker can also function as an ODBC data source--which might be an option depending on what the other software can do--though setting this up has proven to be a challenge for some judging by the threads found in this forum.