CFD Online Logo CFD Online URL
www.cfd-online.com
[Sponsors]
Home > Forums > Main CFD Forum

How to get a formula from data.

Register Blogs Members List Search Today's Posts Mark Forums Read

Reply
 
LinkBack Thread Tools Display Modes
Old   September 12, 2000, 05:45
Default How to get a formula from data.
  #1
Q.Ronnie
Guest
 
Posts: n/a
hello, everyone.

Now I have a lot of data from simulation to be dealt with. The only thing I want to do is to summarize a formula with those data. For example, y=f(x1,x2,x3). CAN anyone tell me a thread about how to do to get a formula from a series of data.

Thank you.
  Reply With Quote

Old   September 12, 2000, 06:53
Default Re: How to get a formula from data.
  #2
A. Taurchini
Guest
 
Posts: n/a
Well, what you should do is interpolate your data in your computational domain, but there are a lot of ways for doing this. The simpler thing to do is defining a polinomial such as

a0 + a1x +a2x^2 + .... = y

where a0,... are the unknowns and x is your variable (you can easily extend this to multiple variable), and assign your data to this curve obtain the numerical coefficients a. The accuracy of course depends from the maximum exponent of the polinomial you choose. This is obviously not the best method but you can find a lot of bibliography on this argument (data interpolation). Just one more thing ... remember that the relation you'll find will be valid (with a certain error of course) only within your computational domain.

  Reply With Quote

Old   September 12, 2000, 18:43
Default Re: How to get a formula from data.
  #3
Anindya
Guest
 
Posts: n/a
Plot the data in a spreadsheet like excel. Now using excel graph plotting join the points with a line through the data. It might be linear, non-linear, exponential, power law, semi-log etc, etc.

Depending on what type of curve you choose, excel will automatically display the formula of the st-line or non-linear curve which you see on the plot.

Hope it helps.
  Reply With Quote

Old   September 13, 2000, 00:28
Default Re: How to get a formula from data.
  #4
Q.Ronnie
Guest
 
Posts: n/a
Thank you indeed. But i still don`t know how to extend one variable to multiple variables. And would you please tell me what bibliography should I refer to. I`am sorry for wasting your time.
  Reply With Quote

Old   September 13, 2000, 03:49
Default Re: How to get a formula from data.
  #5
A. Taurchini
Guest
 
Posts: n/a
Application like Excel and so on do exactly what I said, but of course they are useful for statistical data (spreadsheet were firstly made for economical study) but not at all for mathematical. I mean, does Excel give you the error of your (its...) approximation ? Of course NOT ! This means that for simple and rough study Excel it's good, but if you need some relevant data to compare with others you have to proceed with an interpolation scheme (usually more complex than what Excel can do).

The extension to multiple variable means you have to build a complete polinomial, like this (two variable x1,x2)

a0+a1(x1)+a2(x2)+a3(x1)^2+a4(x2)^2+a5(x1)(x2)+... =y

Bibliography. I may advise you a lot of books but none is in english (Italian, Russian ...), you'll find more explanation on every book of numerical methods. You may even search over the net ... As a first step try www.efunda.com/math/num_interpolation/num_interpolation.cfm

Bye.
  Reply With Quote

Old   September 13, 2000, 04:37
Default I really appreciate.
  #6
Q.Ronnie
Guest
 
Posts: n/a
  Reply With Quote

Old   September 13, 2000, 07:33
Default Re: How to get a formula from data.
  #7
Steve Amphlett
Guest
 
Posts: n/a
The best book I've found on this topic is by far:

INTRODUCTION TO LINEAR REGRESSION ANALYSIS Douglas C Montgomery & Elizabeth A Peck

AFFILIATION: Arizona State University; Coca-Cola Company

SOURCE: (New York City, New York, USA; John Wiley, 1992, Wiley series in probability and mathematical statistics - applied probability and statistics, 2nd ed., 540pp.)

- most of their stuff can be implemented quite easily in MATLAB.
  Reply With Quote

Old   September 13, 2000, 09:57
Default Re: I really appreciate.
  #8
A.Hassaneen
Guest
 
Posts: n/a
Beside all the aforementioned suggestions, I meight recommend you to read about the subject in one of the "deisgn of experiment" book. Also, if you have an access to one of the statistical packages (for example: SPSS or MINITAB) I was using the later for something like what you are looking for. Good luck
  Reply With Quote

Old   September 13, 2000, 21:43
Default HELP!!!
  #9
Hasib Iqbal
Guest
 
Posts: n/a
Dear CFD user,

I am totally new to CFD and would very much appreciate if you could possibly give me an idea of any books that are at a beginner level. Also any books that cover CFD for sprays.

Thanks
  Reply With Quote

Old   September 14, 2000, 03:25
Default Re: HELP!!!
  #10
A.Hassaneen
Guest
 
Posts: n/a
I meight suggest the book"Numerical Heat Transfer and Fluid Flow" by Patankar.
  Reply With Quote

Old   September 14, 2000, 05:09
Default Re: Interpolation
  #11
Lex
Guest
 
Posts: n/a
Hi You see I'm working at the same problem First of all you should know what for do you need this formula!!! If only for graphical demonstration - for example You don't need it at all ) As for me I prefer to work with splines they are just easier to use! For example using polinoms you can have problems with finding coefficients!!! You have to solve the linear system and so on May be Matlab will be enough for your purposes I don't know So if you are interested you can mail me for soon I'll have some source code and sure have some more ideas.

Yours Lex.Privalov
  Reply With Quote

Old   September 17, 2000, 00:28
Default Re: How to get a formula from data.
  #12
clifford bradford
Guest
 
Posts: n/a
perhaps the best thing would be for you to acquire som software package that does this right off the top of my head i can't think of one but you can check in ASME's "mechanical engineer" there's a software advertised each month in here that does this kind of thing. also you mathematician statistician friends can recommend one to you or any techniques to do it yourself.
  Reply With Quote

Old   September 25, 2000, 13:30
Default Re: Interpolation
  #13
kakollu
Guest
 
Posts: n/a
besides, polynomial fitting can lead to oscilations, so it is better to use splines!
  Reply With Quote

Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
【Help】"Error: Update_Time_Level: invalid data" Chen FLUENT 2 August 24, 2014 07:51
export data at nodes Meenu FLUENT 1 December 30, 2011 02:24
Problem in running ICEM grid in Openfoam Tarak OpenFOAM 6 September 9, 2011 17:51
CGNS vs Tecplot Data Format LWhitson2 Main CFD Forum 3 July 1, 2011 13:50
How to update polyPatchbs localPoints liu OpenFOAM Running, Solving & CFD 6 December 30, 2005 18:27


All times are GMT -4. The time now is 12:29.