{"id":6,"date":"2008-09-23T11:13:09","date_gmt":"2008-09-23T15:13:09","guid":{"rendered":"https:\/\/blogs.mathworks.com\/videos\/2008\/09\/23\/importing-excel-data-and-fitting-a-curve-to-it\/"},"modified":"2009-05-19T16:44:07","modified_gmt":"2009-05-19T16:44:07","slug":"importing-excel-data-and-fitting-a-curve-to-it","status":"publish","type":"post","link":"https:\/\/blogs.mathworks.com\/videos\/2008\/09\/23\/importing-excel-data-and-fitting-a-curve-to-it\/","title":{"rendered":"Importing Excel data and fitting a curve to it"},"content":{"rendered":"I recently got an e-mail from a MATLAB user that had a large dataset in Excel.  They wanted to import the data and &#8220;take the average of the graph&#8221;.\r\n\r\nIt turns out that meant fitting a polynomial to the data.  This three minute video covers the import of the data, finding the right combination of data to plot and then we fit a polynomial to it.\u00a0 Finally the graphic is cleaned up by changing the colors and line styles.\u00a0 All of this is done without having to write code or type a command.\r\n\r\nThis video will be the most helpful for newer MATLAB users.\r\n\r\n<div><div class=\"row\"><div class=\"col-xs-12 containing-block\"><div class=\"bc-outer-container add_margin_20\"><videoplayer><div class=\"video-js-container\"><video data-video-id=\"3877438024001\" data-video-category=\"blog\" data-autostart=\"false\" data-account=\"62009828001\" data-omniture-account=\"mathwgbl\" data-player=\"rJ9XCz2Sx\" data-embed=\"default\" id=\"mathworks-brightcove-player\" class=\"video-js\" controls><\/video><script src=\"\/\/players.brightcove.net\/62009828001\/rJ9XCz2Sx_default\/index.min.js\"><\/script><script>if (typeof(playerLoaded) === 'undefined') {var playerLoaded = false;}(function isVideojsDefined() {if (typeof(videojs) !== 'undefined') {videojs(\"mathworks-brightcove-player\").on('loadedmetadata', function() {playerLoaded = true;});} else {setTimeout(isVideojsDefined, 10);}})();<\/script><\/div><\/videoplayer><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<div class=\"thumbnail thumbnail_asset asset_overlay video\"><a href=\"https:\/\/blogs.mathworks.com\/videos\/2008\/09\/23\/importing-excel-data-and-fitting-a-curve-to-it\/?dir=autoplay\"><img decoding=\"async\" src=\"https:\/\/cf-images.us-east-1.prod.boltdns.net\/v1\/static\/62009828001\/72e22ce6-23f5-4f7f-9fd7-1d7e9f42e29a\/9d7ab51d-f545-497e-9abf-6fc29e21c933\/1280x720\/match\/image.jpg\" onError=\"this.style.display ='none';\"\/>\n      <div class=\"overlay_container\">\n      <span class=\"icon-video icon_color_null\"><time class=\"video_length\">3:14<\/time><\/span>\n      <\/div>\n      <\/a><\/div><p>I recently got an e-mail from a MATLAB user that had a large dataset in Excel.  They wanted to import the data and &#8220;take the average of the graph&#8221;.\r\n\r\nIt turns out that meant fitting a&#8230; <a class=\"read-more\" href=\"https:\/\/blogs.mathworks.com\/videos\/2008\/09\/23\/importing-excel-data-and-fitting-a-curve-to-it\/\">read more >><\/a><\/p>","protected":false},"author":68,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[4,17,7],"tags":[],"_links":{"self":[{"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/posts\/6"}],"collection":[{"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/users\/68"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/comments?post=6"}],"version-history":[{"count":0,"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/posts\/6\/revisions"}],"wp:attachment":[{"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/media?parent=6"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/categories?post=6"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/tags?post=6"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}