{"id":562,"date":"2014-11-12T04:37:17","date_gmt":"2014-11-12T04:37:17","guid":{"rendered":"http:\/\/rovdownloads.com\/blog\/?p=562"},"modified":"2014-11-21T17:15:38","modified_gmt":"2014-11-21T17:15:38","slug":"cubic-spline-interpolation-and-extrapolation","status":"publish","type":"post","link":"https:\/\/rovdownloads.com\/blog\/cubic-spline-interpolation-and-extrapolation\/","title":{"rendered":"Cubic Spline Interpolation and Extrapolation"},"content":{"rendered":"<p><strong>Theory<\/strong><br \/>\nSometimes there are missing values in a time-series dataset. For instance, interest rates for years 1 to 3 may exist, followed by years 5 to 8, and then year 10. Spline curves can be used to interpolate the missing years\u2019 interest rate values based on the data that exist. Spline curves can also be used to forecast or extrapolate values of future time periods beyond the time period of available data. The data can be linear or nonlinear. Figure 1 illustrates how a cubic spline is run, and Figure 2 shows the resulting forecast report from this module. The Known X values represent the values on the x-axis of a chart (in our example, this is Years of the known interest rates, and, usually, the x-axis values are those that are known in advance such as time or years) and the Known Y values represent the values on the y-axis (in our case, the known Interest Rates). The y-axis variable is typically the variable you wish to interpolate missing values from or extrapolate the values into the future.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/rovdownloads.com\/blog\/wp-content\/uploads\/2014\/07\/Untitled-13.png\" alt=\"Untitled-1\" width=\"1075\" height=\"1663\" class=\"aligncenter size-full wp-image-564\" srcset=\"https:\/\/rovdownloads.com\/blog\/wp-content\/uploads\/2014\/07\/Untitled-13.png 1075w, https:\/\/rovdownloads.com\/blog\/wp-content\/uploads\/2014\/07\/Untitled-13-193x300.png 193w, https:\/\/rovdownloads.com\/blog\/wp-content\/uploads\/2014\/07\/Untitled-13-661x1024.png 661w, https:\/\/rovdownloads.com\/blog\/wp-content\/uploads\/2014\/07\/Untitled-13-135x210.png 135w\" sizes=\"auto, (max-width: 1075px) 100vw, 1075px\" \/><\/p>\n<p><strong>Procedure<\/strong><\/p>\n<ul>\n<li>Start Excel and open the example file Advanced Forecasting Model, go to the Cubic Spline worksheet, select the data set excluding the headers, and click on Risk Simulator | Forecasting | Cubic Spline.<\/li>\n<li>The data location is automatically inserted into the user interface if you first select the data, or you can also manually click on the link icon and link the Known X values and Known Y values (see Figure 1 for an example), then enter the required Starting and Ending values to extrapolate and interpolate, as well as the required Step Size between these starting and ending values. Click OK to run the model and report (see Figure 2).<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/rovdownloads.com\/blog\/wp-content\/uploads\/2014\/07\/Untitled16.png\" alt=\"Untitled\" width=\"1097\" height=\"571\" class=\"aligncenter size-full wp-image-563\" srcset=\"https:\/\/rovdownloads.com\/blog\/wp-content\/uploads\/2014\/07\/Untitled16.png 1097w, https:\/\/rovdownloads.com\/blog\/wp-content\/uploads\/2014\/07\/Untitled16-300x156.png 300w, https:\/\/rovdownloads.com\/blog\/wp-content\/uploads\/2014\/07\/Untitled16-1024x533.png 1024w, https:\/\/rovdownloads.com\/blog\/wp-content\/uploads\/2014\/07\/Untitled16-210x109.png 210w\" sizes=\"auto, (max-width: 1097px) 100vw, 1097px\" \/><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - http:\/\/www.hupso.com\/share\/ --><a class=\"hupso_toolbar\" href=\"http:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/share-medium.png\" style=\"border:0px; padding-top:5px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_t=new Array(\"Twitter\",\"Facebook\",\"Google Plus\",\"Linkedin\");var hupso_background_t=\"#EAF4FF\";var hupso_border_t=\"#66CCFF\";var hupso_toolbar_size_t=\"medium\";var hupso_image_folder_url = \"http:\/\/rovdownloads.com\/blog\/wp-content\/plugins\/hupso-share-buttons-for-twitter-facebook-google\/img\/services\/\";var hupso_url_t=\"\";var hupso_title_t=\"Cubic Spline Interpolation and Extrapolation\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/share_toolbar.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Theory Sometimes there are missing values in a time-series dataset. For instance, interest rates for years 1 to 3 may exist, followed by years 5 to 8, and then year &hellip; <a class=\"readmore\" href=\"https:\/\/rovdownloads.com\/blog\/cubic-spline-interpolation-and-extrapolation\/\">Continue Reading &amp;rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[5],"tags":[125],"class_list":["post-562","post","type-post","status-publish","format-standard","hentry","category-blog","tag-time-series"],"acf":[],"_links":{"self":[{"href":"https:\/\/rovdownloads.com\/blog\/wp-json\/wp\/v2\/posts\/562","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rovdownloads.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rovdownloads.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rovdownloads.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rovdownloads.com\/blog\/wp-json\/wp\/v2\/comments?post=562"}],"version-history":[{"count":1,"href":"https:\/\/rovdownloads.com\/blog\/wp-json\/wp\/v2\/posts\/562\/revisions"}],"predecessor-version":[{"id":565,"href":"https:\/\/rovdownloads.com\/blog\/wp-json\/wp\/v2\/posts\/562\/revisions\/565"}],"wp:attachment":[{"href":"https:\/\/rovdownloads.com\/blog\/wp-json\/wp\/v2\/media?parent=562"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rovdownloads.com\/blog\/wp-json\/wp\/v2\/categories?post=562"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rovdownloads.com\/blog\/wp-json\/wp\/v2\/tags?post=562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}