Hi,
I am trying to linear interpolate annual data into monthly.
2019 29,063,000
2020 31,388,000
2021 24,826,000
2022 27,436,000
Any help would be greatly appreciated
Hi,
I am trying to linear interpolate annual data into monthly.
2019 29,063,000
2020 31,388,000
2021 24,826,000
2022 27,436,000
Any help would be greatly appreciated
It's not really clear what you want.
The way I am interpreting your question is to find a linear trendline for these four data points then calculate the interpolation of the 48 months onto that line. See attached file.
If you do that, the values for the months will no longer add up to the totals for each individual year.
But I can't think of any other way to interpret what you are asking.
Thank you 6StringJazzer. Appreciate your help
Thanks for the rep!
If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks