I have a Filemaker file with several fields (say 10) to fill in numbers for statistics (say n=100 in each field). Have calculated a mean and a standard deviation for each field. Question: How can I create an overall mean and overall standard deviation of all numbers of all fields (10 x 100 numbers) with a Filemaker formula. Statistically it is wrong to calculate the overall standard deviation as mean of all single standard deviations of every field. My only idea was to export all fields + numbers to "excel", arrange all numbers into one column and send them back to filemaker via import to use them in my layout in one field. But that is unprofessional, isn`t it? And if one new number is given in one field there is no way that the standard deviation is automatically actualized.
Is there any idea in the community to manage that problem via FM?