×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Are you an
Engineering professional?
Join Eng-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

how to fit a correlation to meassured data in excel

 Forum Search FAQs Links MVPs

how to fit a correlation to meassured data in excel

(OP)
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

RE: how to fit a correlation to meassured data in excel

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.

RE: how to fit a correlation to meassured data in excel

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: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.

RE: how to fit a correlation to meassured data in excel

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

RE: how to fit a correlation to meassured data in excel

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

RE: how to fit a correlation to meassured data in excel

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: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!