Converting Quarterly Data to Monthly Data

  • Hello,


    I have data that I want to convert from quarterly to monthly data. I know of cubic spline interpolation, however, the data that I want to convert is an aggregate of total government spending. If cubic spline interpolation is done, the data is generated is invalid since "total government spending" would far exceed the original data. What can be done?


    [TABLE="border: 0, cellpadding: 0, cellspacing: 0"]

    [tr]


    [TD="width: 64"]YEAR[/TD]
    [TD="width: 64"]MONTH[/TD]
    [TD="width: 89"]G SPENDING[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2012[/TD]
    [TD="align: right"]1[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2012[/TD]
    [TD="align: right"]2[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2012[/TD]
    [TD="align: right"]3[/TD]
    [TD="align: right"]138167[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2012[/TD]
    [TD="align: right"]4[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2012[/TD]
    [TD="align: right"]5[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2012[/TD]
    [TD="align: right"]6[/TD]
    [TD="align: right"]186143[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2012[/TD]
    [TD="align: right"]7[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2012[/TD]
    [TD="align: right"]8[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2012[/TD]
    [TD="align: right"]9[/TD]
    [TD="align: right"]175661[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2012[/TD]
    [TD="align: right"]10[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2012[/TD]
    [TD="align: right"]11[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2012[/TD]
    [TD="align: right"]12[/TD]
    [TD="align: right"]233298[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2013[/TD]
    [TD="align: right"]1[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2013[/TD]
    [TD="align: right"]2[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2013[/TD]
    [TD="align: right"]3[/TD]
    [TD="align: right"]146528[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2013[/TD]
    [TD="align: right"]4[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2013[/TD]
    [TD="align: right"]5[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2013[/TD]
    [TD="align: right"]6[/TD]
    [TD="align: right"]191273[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2013[/TD]
    [TD="align: right"]7[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2013[/TD]
    [TD="align: right"]8[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2013[/TD]
    [TD="align: right"]9[/TD]
    [TD="align: right"]217308[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2013[/TD]
    [TD="align: right"]10[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2013[/TD]
    [TD="align: right"]11[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2013[/TD]
    [TD="align: right"]12[/TD]
    [TD="align: right"]272133[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2014[/TD]
    [TD="align: right"]1[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2014[/TD]
    [TD="align: right"]2[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2014[/TD]
    [TD="align: right"]3[/TD]
    [TD="align: right"]165771,11[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2014[/TD]
    [TD="align: right"]4[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2014[/TD]
    [TD="align: right"]5[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2014[/TD]
    [TD="align: right"]6[/TD]
    [TD="align: right"]228369,85[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2014[/TD]
    [TD="align: right"]7[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2014[/TD]
    [TD="align: right"]8[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2014[/TD]
    [TD="align: right"]9[/TD]
    [TD="align: right"]258028,84[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2014[/TD]
    [TD="align: right"]10[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2014[/TD]
    [TD="align: right"]11[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2014[/TD]
    [TD="align: right"]12[/TD]
    [TD="align: right"]344027,64[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2015[/TD]
    [TD="align: right"]1[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2015[/TD]
    [TD="align: right"]2[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2015[/TD]
    [TD="align: right"]3[/TD]
    [TD="align: right"]180357,57[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2015[/TD]
    [TD="align: right"]4[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2015[/TD]
    [TD="align: right"]5[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2015[/TD]
    [TD="align: right"]6[/TD]
    [TD="align: right"]253555,6[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2015[/TD]
    [TD="align: right"]7[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2015[/TD]
    [TD="align: right"]8[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2015[/TD]
    [TD="align: right"]9[/TD]
    [TD="align: right"]292231,75[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2015[/TD]
    [TD="align: right"]10[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2015[/TD]
    [TD="align: right"]11[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2015[/TD]
    [TD="align: right"]12[/TD]
    [TD="align: right"]397604,95[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2016[/TD]
    [TD="align: right"]1[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2016[/TD]
    [TD="align: right"]2[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2016[/TD]
    [TD="align: right"]3[/TD]
    [TD="align: right"]201131,59[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2016[/TD]
    [TD="align: right"]4[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2016[/TD]
    [TD="align: right"]5[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2016[/TD]
    [TD="align: right"]6[/TD]
    [TD="align: right"]291210,63[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2016[/TD]
    [TD="align: right"]7[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2016[/TD]
    [TD="align: right"]8[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2016[/TD]
    [TD="align: right"]9[/TD]
    [TD="align: right"]290207,73[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2016[/TD]
    [TD="align: right"]10[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2016[/TD]
    [TD="align: right"]11[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2016[/TD]
    [TD="align: right"]12[/TD]
    [TD="align: right"]401090,33[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2017[/TD]
    [TD="align: right"]1[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2017[/TD]
    [TD="align: right"]2[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2017[/TD]
    [TD="align: right"]3[/TD]
    [TD="align: right"]211829,24[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2017[/TD]
    [TD="align: right"]4[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2017[/TD]
    [TD="align: right"]5[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2017[/TD]
    [TD="align: right"]6[/TD]
    [TD="align: right"]289935,62[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2017[/TD]
    [TD="align: right"]7[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2017[/TD]
    [TD="align: right"]8[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2017[/TD]
    [TD="align: right"]9[/TD]
    [TD="align: right"]308053,44[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2017[/TD]
    [TD="align: right"]10[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2017[/TD]
    [TD="align: right"]11[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2017[/TD]
    [TD="align: right"]12[/TD]
    [TD="align: right"]427050,73[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2018[/TD]
    [TD="align: right"]1[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2018[/TD]
    [TD="align: right"]2[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2018[/TD]
    [TD="align: right"]3[/TD]
    [TD="align: right"]222983,56[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2018[/TD]
    [TD="align: right"]4[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2018[/TD]
    [TD="align: right"]5[/TD]

    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]2018[/TD]
    [TD="align: right"]6[/TD]
    [TD="align: right"]313129,73[/TD]

    [/tr]


    [/TABLE]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!