Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Mathematics (https://www.askmehelpdesk.com/forumdisplay.php?f=199)
-   -   Smoothing data of the year (https://www.askmehelpdesk.com/showthread.php?t=774381)

  • Nov 8, 2013, 04:50 AM
    josse34
    Smoothing data of the year
    Hi!
    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!

    Bye

  • All times are GMT -7. The time now is 05:28 AM.