Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations KootK on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to fit a correlation to meassured data in excel

Status
Not open for further replies.
themroc

themroc

Chemical
Sep 7, 2006
76
In the attached excel sheet (interpolation.xls) measured friction factor data are shown as a function of Reynolds. The data are for different packing densities. 30 = lowest packing 80 = highest packing.

As it can be seen the values are strongly decreasing with higher Reynolds number.
Applying the excel trend lines does not give a good fit.
The power function fits well until a Reynolds number of 100 but for higher values I can not find a suitable fit.
Can anyone propose a software package which is able to apply trendlines for such kind of curves.
What kind of mathematical equation would fit the data?
Ideally a two dimensial function which gives
f = f(reynolds; packing density)

Any sugestion apreciated
 
Replies continue below

Recommended for you

Sort by date Sort by votes
Use an linear trendline in Excel. Manipulate your raw data using a function that you think will linearize the correlation. Try a few functions, see how the linear trendline matches up (desired slope = 1:1) and revise your function to improve it.
 
Upvote 0 Downvote
It very much depends on what you are trying to do. Bribyk's approach is the best one if you are merely trying to interpolate using a function, but if you are trying to validate some underlying physics then you are better off normalising back to the theoretical curve, and then trying to explain the differences.

Having said that I rather think your difficulty is not so much in getting the shape vs Re, your packing density effect looks far more non linear on the log-log curve.

Cheers

Greg Locock

SIG:please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
 
Upvote 0 Downvote
If the cost doesn't bother you, look/get Tablecurve 2D from Systat. This runs about $500 and change, but is far and away the most complete curve fitting and analysis software available.

Orenda
 
Upvote 0 Downvote
As Greg suggests take the log of both the x and y axes and plot those. You can fit an almost exact quadratic through this new data, from which you can tranpose the variables back to the original data, to obtain a formula.

corus
 
Upvote 0 Downvote
I fiddled around a bit and got a pretty good agreement, looks like the correction for the packing density is just log(packing density).

As Corus says a quadratic of log(Re) seems to be a reasonable fit.

However the error plot of what I have left is extremely complex, are those real data points?

Cheers

Greg Locock

SIG:please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MK_0202
  • Locked
  • Question
How to Increase Minor Axis Bending for Rolled-H section 1
Replies
7
Views
7K
Agent666
Agent666
YungPlantEng
  • Locked
  • Question
Automation of coding historical failure data?
Replies
1
Views
731
IRstuff
IRstuff
Ocman76
  • Locked
  • Question
How is the Buoyancy Reduction Factor Equation derived?
Replies
1
Views
831
IRstuff
IRstuff
Souvik Singh Rathore
  • Locked
  • Question
How to use Lame's parameter 'A' while converting x,y coordinate into zeta,eta coordinate (FEA)
Replies
1
Views
698
IRstuff
IRstuff
hacksaw
  • Locked
  • Question
Hilbert-Huang Transforms and FIV Data
Replies
1
Views
227
GregLocock
GregLocock

Part and Inventory Search

Sponsor

Back
Top Bottom