AnsweredAssumed Answered

Record selection for statistic calculations

Question asked by psijmons on Jan 19, 2015
Latest reply on Jan 19, 2015 by psijmons

I am using the statistical functions for Average, St Dev, etc. on a set of related records.

The user gets the option to exclude a record when it is an outlier and should not be included for the average calc., but the data has to remain in the set.

 

In the attached ERD, there is a connection based on the presence or absence of this marker.

However, this indeed does change the average, but it is not corrected for a reduced number of records to base the average on.

 

I do want to keep the raw data and statistical data in separate tables as I expect a very high number of raw data records.

Is there a better approach to this?

 

Any suggestions appreciated as I am stuck on this one.

Peter.

Outcomes