Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

How to export Matlab curve-fitted data to excel?

  1. Jul 27, 2010 #1
    Hi all,

    I have used matlab curve fit tool to curve-fit a set of x-y points. Now I want to export the curve-fitted y point to excel.

    Any idea how to do this?

    Thank you very much.
  2. jcsd
  3. Jul 28, 2010 #2

    Dr Transport

    User Avatar
    Science Advisor
    Gold Member

    write the coefficients to a .csv file and read them into excel
  4. Jul 29, 2010 #3
    Thank you for your reply.
    Could you explain more. Do you mean copy/paste the coeff of the resulted curve-fitted function to an excel file?
    I am using a Gaussian fit. It gives me the Gaussian expression which is defined by about 24 coefficients and these coefficients are given separately below the expression. Something like this:

    f(x) =
    a1*exp(-((x-b1)/c1)^2) + a2*exp(-((x-b2)/c2)^2) +

    and a1, b1, c1 and so on are defined below this expression.

    So I wonder if I copy/paste these coefficients to excel, and also the formula, how can I use it as a function in excel. I am not very familiar with excel.

    Thank you.
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook