Skip to main content
edited tags
Link
kjetil b halvorsen
  • 82.8k
  • 32
  • 201
  • 663
Better explanation
Source Link
PostDocing
  • 3.2k
  • 6
  • 36
  • 65

I am working with weekly data and I am running into troubles when analyzing them because of their inconsistent nature. By inconsistent nature, I mean that not every month is made of the same number of weeks so that some weeks span over two subsequent months and the same holds for months over subsequent years.

Just to give you an example let's suppose I have a week beginning on March 28 ending on April 3. And let's suppose I have just a figure for the whole week, while I should have two figures, one for each month.

SinceThe purpose of this dataset is to run some descriptive analysis, thus I need to impute each figurebe able to a specific yearanalyze data by weeks, month(aggregated) by months and week(aggregated) by years. And I would like to aggregate them properly, howe.g. deaths across two months should I proceed in order notbe (as much as possible) imputed to generate any misinterpretationeach month correctly.

How would you proceed? Any technique better than the others?

I am working with weekly data and I am running into troubles when analyzing them because of their inconsistent nature. By inconsistent nature, I mean that not every month is made of the same number of weeks so that some weeks span over two subsequent months and the same holds for months over subsequent years.

Just to give you an example let's suppose I have a week beginning on March 28 ending on April 3. And let's suppose I have just a figure for the whole week, while I should have two figures, one for each month.

Since I need to impute each figure to a specific year, month and week, how should I proceed in order not to generate any misinterpretation?

I am working with weekly data and I am running into troubles when analyzing them because of their inconsistent nature. By inconsistent nature, I mean that not every month is made of the same number of weeks so that some weeks span over two subsequent months and the same holds for months over subsequent years.

Just to give you an example let's suppose I have a week beginning on March 28 ending on April 3. And let's suppose I have just a figure for the whole week, while I should have two figures, one for each month.

The purpose of this dataset is to run some descriptive analysis, thus I need to be able to analyze data by weeks, (aggregated) by months and (aggregated) by years. And I would like to aggregate them properly, e.g. deaths across two months should be (as much as possible) imputed to each month correctly.

How would you proceed? Any technique better than the others?

edited title
Link
Richard Hardy
  • 69.5k
  • 13
  • 126
  • 278

Troubles with weekly data: reconciling weeks with months and years

added 2 characters in body
Source Link
Nick Cox
  • 59.5k
  • 8
  • 136
  • 212
Loading
Source Link
PostDocing
  • 3.2k
  • 6
  • 36
  • 65
Loading