Results 1 to 2 of 2

Math Help - Averaging out totals for the end of a month

  1. #1
    Newbie
    Joined
    Mar 2009
    Posts
    20

    Averaging out totals for the end of a month

    Not sure the best way to describe this unfortunately, but basically I have a large data set and I want to graph a count of the number of records for each day of the month. The line graph will have 31 total points, one for each day of the month. However, since February has only 28 days, and roughly half of the months have only 31 days, the 31st point on the graph will look artificially low as far as a linear trend goes. To put it in context these are payments from vendors. Some vendors cut checks every day, some on Mondays only, some on the first and 15th of the month only, some on the 15th and last day of the month (which could be the 28th, 30th, or 31st, which is why this is important), etc etc.

    Can anyone suggest an easy way to "normalize" these so that the 31st or 30th etc don't look like false positives or false negatives?

    Thanks!
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor

    Joined
    Apr 2005
    Posts
    16,396
    Thanks
    1846

    Re: Averaging out totals for the end of a month

    The obvious thing to do is to treat each months separately. That is, for January, divide by 30, Feb divide by 28 (29 in leap years), March, divide by 30, etc.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Replies: 3
    Last Post: October 7th 2012, 01:16 AM
  2. Sum of a series, totals of decreasing bets
    Posted in the Math Topics Forum
    Replies: 0
    Last Post: February 19th 2011, 07:39 PM
  3. Problem of the month
    Posted in the Geometry Forum
    Replies: 1
    Last Post: September 29th 2008, 10:07 AM
  4. day of month
    Posted in the Math Topics Forum
    Replies: 17
    Last Post: May 27th 2008, 11:39 PM
  5. 13th of a month
    Posted in the Statistics Forum
    Replies: 8
    Last Post: June 17th 2006, 07:53 PM

Search Tags


/mathhelpforum @mathhelpforum