Answer the question
In order to leave comments, you need to log in
How to calculate average daily data considering leap day?
I would like to build a daily graph of average climatic values (temperature, snow, etc), but when averaging, the question arose of what to do with a leap day. In the draft version, I just threw it away, but this is a quarter of the data!
Variants:
- to smear on neighboring (somehow)
- to make the schedule taking into account 29 days of February, interpolating for this day in 75% of cases....
- ???
Answer the question
In order to leave comments, you need to log in
Alternatively, you can make a graph taking into account February 29, only divide the sum of indicators on this day not by the total number of years, but by the number of leap years
A wildly interesting question, how do they deal with this in data analysis?
Nature doesn’t care about our days, months and weeks, maybe for visualization it doesn’t give a damn either? volitional decision to accept a fixed number of days for the year, determine the conditional months and visualize accordingly.
Another option, what is daily averaging? it means adding up the values a year ago, two years ago, three years ago ... so take the day that was a year ago, using the data obtained on the same day in the past to calculate the average on different days (this can be done for min / max/average methods, but you can't add them).
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question