Skip to content

GHT has misleading declining trend --- in areas with unexpectedly low volume? #67

@brookslogan

Description

@brookslogan

In MSAs like:

  • Beaumont-Port Arthur, TX
  • College Station-Bryan, TX
  • Sioux City, IA-NE-SD
  • Cheyenne, WY

It appears that the GHT signal is encountering single queries or single days with queries above the reporting threshold on scattered days, but then the smoothing/averaging over the following days make it look like a declining trend over the next 7 days. Especially with the default of showing the last two weeks only in the graph, this often appears like a (misleading) rapidly decreasing trend, or strange spikes upward.

(I guess this goes back to real 0s vs. under threshold; not sure what the status on handling these is.) It seems we need to adjust the smoothing to either: skip over missed reporting or perhaps both missed reporting and real 0s --- e.g., if there are only 3 nonmissing days, average over only those 3 with a 3 in the denominator rather than 7 --- or report NAs for the smoothed estimates instead.

Metadata

Metadata

Labels

EngineeringUsed to filter issues when synching with Asanadata qualityMissing data, weird data, broken datamodelingMust coordinate with Modeling team

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions