×
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

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.

Resources

Low-Volume Rapid Injection Molding With 3D Printed Molds
Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a partâ€™s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

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!