1. Limited time only! Sign up for a free 30min personal tutor trial with Chegg Tutors
    Dismiss Notice
Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Smoothing data of the year

  1. Nov 8, 2013 #1
    I have a problem to resolve this question :

    I have a total value each month :
    January = 60
    Fébruary = 80
    March = 130
    April = 150
    May = 180
    June = 200
    July = 210
    August = 170
    September = 140
    October = 90
    November = 60
    December = 50

    I want to calculate the value each day of year, but the total of this values each month must be exactly like value previously describing.
    Also, the graphic render must be with smoothing line, like spline or simpson rule.

    See attached a excel base http://cjoint.com/?CKilaalz7z2

    How to make this ?!

    Thank you so much and have a nice day!

  2. jcsd
  3. Nov 8, 2013 #2


    User Avatar
    Staff Emeritus
    Science Advisor
    Homework Helper

    Simpson's rule is for numerical integration, so you don't want that.
  4. Nov 8, 2013 #3
    Any method is ok for me, the simply is the best because i must integrate this into PHP code after!
    Do you any idea?
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook