How to export Matlab curve-fitted data to excel?

  • Context: MATLAB 
  • Thread starter Thread starter Si14
  • Start date Start date
  • Tags Tags
    Data Excel Matlab
Join the discussion
Registration is free. Ask a follow-up in this thread, or start your own.
2 replies · 8K views
Si14
Messages
75
Reaction score
0
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.
 
Physics news on Phys.org
Dr Transport said:
write the coefficients to a .csv file and read them into excel

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.