Question to the group

-
Question to the group
I have a number of dates
(I can format any way needed)
and I want to average those dates
whats the easiest way to come up with an average :)
the year is not needed, just the day and month
I might have to convert to 1 to 365 and use sin and cos
thanks!

Comments

  1. Brian HamiltonMarch 2, 2015 at 1:54 PM

    yes, I guess I could create a real number for converted to 0 to 360 (i.e fraction) for the day of the year, to plug into the equation, then reverse that again (i.e as you say, normalize the number first)

    ReplyDelete
  2. David MillingtonMarch 2, 2015 at 2:16 PM

    Brian Hamilton No - create a real number (0-2pi radians) for the converted 0 to 365 or 366.

    That way you support the entire year, including leap years.

    ReplyDelete
  3. David HeffernanMarch 2, 2015 at 2:24 PM

    +Brian I gave you the equation above. And you still need to accept the sometimes you won't be able to get an answer.

    ReplyDelete

Post a Comment