search

smart-on-fhir / cumulus-library-data-metrics

A data metrics study for the Cumulus project
https://docs.smarthealthit.org/cumulus/
Apache License 2.0
2 stars 0 forks source link

Add standard deviation to c_resources_per_pt #19

Closed mikix closed 4 months ago

mikix commented 6 months ago

Standard deviation would be a useful statistic to add to c_resources_per_pt (in addition to the existing average and max stats)

Original report below

Standard deviation & median come to mind.

gotdan commented 6 months ago

Also max and min though min will probably be zero in most cases

mikix commented 5 months ago

I threw max into #21 while I was touching this metric for something else. I also experimented with min, but as you say, everything was just zero. So I left it out for cleanliness.

gotdan commented 5 months ago

Cool, should we change the title of this issue to std deviation - I think that's the only column that's still missing here?

mikix commented 5 months ago

Std deviation and also median.

gotdan commented 5 months ago

I think we could probably skip median - some quick googling indicates it's pretty inefficient to calculate in sql, and not sure it's high value for this use case anyway...