Menu Close

Curve fitting in Microsoft Excel 2010

Curve fitting is the process of constructing a curve, or mathematical function, that has the best fit to a series of data points, possibly subject to constraints. Curve fitting can involve either interpolation, where an exact fit to the data is required, or smoothing, in which a “smooth” function is constructed that approximately fits the data.

To fit a curve in Microsoft Excel 2010:

  1. Tool to be used.

The Solver in Excel will be used for the curve fitting. The Solver was not added in by default. To add the Solver into Excel:

  • Click on “Options” under File to open the Options window
  • Select Add-Ins and Excel Add-Ins. Click on Go button (Figure 1) to open the Add-Ins window

    Figure 1
  •  Check Solver Add-in and click on OK (Figure 2)

 

Figure 2
  • Click on Data on Excel. The Solver will appear on Analysis (Figure 3)

 

Figure 3
  1. Work on curve fitting
  • Put the x, y data in Excel (Figure 4) and plot the data as X Y Scatter chart (Figure 5).

 

Figure 4Figure 5

 

  • Estimate the best function to match data chart. (y = a*x^2 + b*x +c in this example)
  • Fill the column E, F, G and H as Figure 4.
    • The formula for column E is: =H$96*C96*C96+H$97*C96+H$98
    • The formula for column F is: =(D96-E96)^2
    • The formula for cell F166 is: =SUM(F96:F115)
    • The column H is the parameters a, b and c initial value. They are set to 1. in this example. Different initial value may result different fitting result.
  • Click on Solver and fill the Solver parameters as Figure 6. Click on Solve button

    Figure 6

 

  •  The Solver result window will appear as Figure 7. Check Return to Solver Parameters Dialog and click on OK button

 

Figure 7
  • Click on Solve on Solver Parameters window and OK on Solver results window until the value in cell F166 in this example to unchanging.
  • The Least Square curve fitting results are as Figure 8

  

Figure 8

37 comments on “Curve fitting in Microsoft Excel 2010

  1. Very wonderful info can be found on this web blog.

  2. alia on said:

    thanks man but can i ask you to insert figure 4
    i have a problem in fill the column E,F,G,H
    wuld you please help me

  3. Bobby Balcom on said:

    Simply want to say your article is as astounding. The clearness in your post is simply excellent and i can assume you are an expert on this subject. Fine with your permission let me to grab your RSS feed to keep up to date with forthcoming post. Thanks a million and please carry on the rewarding work.

  4. I simply had to thank you so much once again. I’m not certain what I would have followed without the actual information documented by you concerning this subject. It actually was an absolute distressing situation for me personally, however , taking note of the very professional way you solved the issue took me to cry for joy. I am grateful for the assistance and then hope you find out what a powerful job that you’re putting in training people by way of a blog. I am sure you haven’t got to know all of us.

  5. Marion Barry on said:

    Some really fantastic information, Gladiola I found this. “So long as little children are allowed to suffer, there is no true love in this world.” by Isodore Duncan.

  6. Rubi Moderski on said:

    Interesting article. It is quite unfortunate that over the last years, the travel industry has already been able to to handle terrorism, SARS, tsunamis, bird flu virus, swine flu, and also the first ever entire global economic downturn. Through all of it the industry has really proven to be robust, resilient and dynamic, getting new methods to deal with difficulty. There are continually fresh issues and chance to which the sector must yet again adapt and act in response.

  7. GGU 0059 on said:

    I thought leaving this pingback awesome feature

  8. Hi there, I found your web site via Google while searching for a related topic, your site came up, it looks great. I have bookmarked it in my google bookmarks.

  9. Donella Jorski on said:

    We absolutely love your blog and find many of your post’s to be just what I’m looking for. Would you offer guest writers to write content for you? I wouldn’t mind creating a post or elaborating on a few of the subjects you write with regards to here. Again, awesome site!

  10. I and also my buddies came studying the great recommendations on your website and then instantly I had a horrible feeling I never thanked the web site owner for those tips. Most of the people ended up absolutely happy to study them and now have seriously been tapping into these things. Thanks for turning out to be so thoughtful and for deciding on some tremendous resources most people are really wanting to know about. My honest apologies for not expressing appreciation to you sooner.

  11. kacamata original on said:

    Simply wanna input that you have a very decent site, I like the pattern it really stands out.

  12. Elke Ilasin on said:

    I went over this site and I conceive you have a lot of superb information, saved to favorites (:.

  13. Clemente Fernendez on said:

    Good blog post. What I would like to bring about is that laptop or computer memory is required to be purchased when your computer is unable to cope with everything you do by using it. One can set up two good old ram boards having 1GB each, by way of example, but not certainly one of 1GB and one of 2GB. One should make sure the car maker’s documentation for one’s PC to make certain what type of memory is needed.

  14. adwokat warszawa on said:

    Valuable info. Lucky me I discovered your site by chance, and I am shocked why this accident did not happened earlier! I bookmarked it.

  15. Nery Soisson on said:

    What i do not understood is if truth be told how you’re no longer actually a lot more neatly-appreciated than you may be right now. You’re very intelligent. You recognize thus considerably in relation to this subject, produced me individually believe it from a lot of numerous angles. Its like men and women don’t seem to be involved unless it is something to do with Woman gaga! Your individual stuffs outstanding. At all times maintain it up!

  16. Tania Patria on said:

    This really answered my downside, thank you!

  17. I am not sure where you are getting your information, but great topic. I needs to spend some time learning much more or understanding more. Thanks for excellent info I was looking for this information for my mission.

  18. Komik Naruto on said:

    Good blog! I truly love how it is easy on my eyes and the data are well written. I’m wondering how I might be notified when a new post has been made. I have subscribed to your RSS which must do the trick! Have a nice day! “If you are going to do something wrong at least enjoy it.” by Leo C. Rosten.

  19. Macrobid Side Effects on said:

    This is a topic which is close to my heart… Many thanks! Exactly where are your contact details though?

  20. You have brought up a very superb points , thankyou for the post.

  21. Macrobid Dose on said:

    I blog frequently and I truly appreciate your information. This article has truly peaked my interest. I’m going to bookmark your blog and keep checking for new information about once per week. I subscribed to your RSS feed too.

  22. Tretorn Canvas T56 on said:

    This paragraph is in fact a nice one it helps new the web people, who
    are wishing in favor of blogging.

  23. Pingback: You sir, are awesome!

  24. Pingback: Hayden Vanschuyver

  25. Μy soousе anԀ I stumbled over ɦerе from a differеոt weЬsite and thought I may as well cҺeck things
    out. I like what I ѕee so now i am following ʏou.
    Look forաard to looking at your web page again.

    Alsօ visit myy webpage – tens machine on neck

  26. parajumpers denali on said:

    It’s ѵery easy to find out any topic on web as compared to
    textbooҝs, aѕ I found this piece of ԝriting at this web site.

  27. Thank ƴou for the good writeup. It in fаct was a amusement accοunt it.
    Loօk advanced to far added agreеable from you! By the way,
    how could we communіcаte?

  28. Woա, fantаstic blog layout! How lߋng Һave you been bloցging for?

    you maԀe blօgging look easy. The overall look of your web site is excellent,
    as well ɑs the content!

    Feel free to surf to my wеb-site Tens Pain Units

  29. Elton on said:

    I all the time emailed this wеblog post page to all my
    associates, as if lіke to read it afterward my friends will too.

    my website; tens unit reviews epinions (Elton)

  30. låna pengar med säkerhet on said:

    Hey! This is my first visit to your blog! We are a collection of volunteers and starting a new initiative in
    a community in the same niche. Your blog provided
    us valuable information to work on. You have done a extraordinary job!

    Here is my website – låna pengar med säkerhet

  31. This post is in fact a fastidious one it assists new internet users, who are wishing in favor of blogging.

  32. tens unit pads amazon on said:

    Hi there! This is kind of off tοpiuc but I ոeeԁ some guidance from
    an established blog. Is it hard tо set up your own blog?

    I’m nоt very techincal but Ӏ can figure things oսt
    pretty quick. I’m thinking about setting up my own but I’m not sure where
    to start. Do you have any tiρs or suggeѕtions? Cheers

    Feel free to visit my site:tens unit pads amazon

  33. Pingback: Google

  34. Admiring the ρersisteոce you pսt into yߋur blog and detailed infoгmation you offer.

    It’s nice to come across a blog every once
    in a while that isn’t the same unwanted rehashed material.
    Excеllent read! I’ve saved your site and I’m inclսding your RSS feeds tօ my Google account.

    Visit my web blog :: roofing tߋols, unlimited-limousine.com,

  35. Pingback: Gregory Smith

  36. I was recommended this web site by my cousin. I am not sure whether this post is written by him
    as no one else know such detailed about my problem. You are amazing!
    Thanks!

  37. Does your website have a contact page? I’m having trouble locating it
    but, I’d like to shoot you an email. I’ve got some creative ideas for your
    blog you might be interested in hearing. Either way, great
    blog and I look forward to seeing it improve over time.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

* Copy This Password *

* Type Or Paste Password Here *

18,519 Spam Comments Blocked so far by Spam Free Wordpress

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>