Comparing two curves in excel
Comparing two curves in excel
(OP)
Dear all,
Could you please tell me how I can compare two curves in excel?
I have a master curve from experiment data, I would like to compare this master curve with the one that I get from simulation?
Could you please tell me how I can compare two curves in excel?
I have a master curve from experiment data, I would like to compare this master curve with the one that I get from simulation?





RE: Comparing two curves in excel
your file has experimental and simulation data graphed together, which compares them.
to come up with an idea of how accurately your simulation predicts experimental results, you could try plotting simulation vs experiment when using the same conditions for both. and the closer this plotted line is to y=x, the better your simulation is at figuring out the actual results.
RE: Comparing two curves in excel
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Comparing two curves in excel
Perhaps if you could explain more clearly what sort of comparison you would like to see, we could be more helpful. As clindeman noted, by having the two sets of data on one graph, it is a comparison.
-- MechEng2005
RE: Comparing two curves in excel
Thanks for your answer, but what do you mean by saying same conditions?
IRStuff:
Thanks for your answer, Unfortunately it is not possible. Then I should also put the corresponding values
MechEng2005:
Thanks for your answer.
I have a curve, I am attaching it again in 97 format.
I would like see how much deviation do I have in simulation?
Maybe some numbers or something.
In the file, I want to compare TENSION curves.
At the end I would like to get, TENSION curve from simulation deviates .... from that of experiment.
RE: Comparing two curves in excel
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Comparing two curves in excel
your comparison table at the end looks like this:
Strain Exp Sim
0 0.01 0.0092
1 0.02 0.021
2 0.03 0.0299
RE: Comparing two curves in excel
The problem is I do not know how to do it. That was why I was asking. Could you please tell me how to do it? It is really important for me.
clindeman:
I am entering Stress and Strain(experiment) data into simulation. I am taking simulation data. So comparison is something that you already have seen. Now I see what you mean. However, the problem is, I do not have the stress values for the same STRAIN values from EXPERIMENT and SIMULATION. If I take the SIMULATION's strain values as reference, then I do not have EXPERIMENT's stress values at the corresponding STRAINs.
RE: Comparing two curves in excel
I suppose Excel must have some splining functions, because it will fit a spline to your data, but as far as I know there is no way to access the spline parameters. If you know of a way I'd be very interested to hear it.
An Excel User Defined Function to fit a spline to XY data can be downloaded from:
ht
I hope the instructions in the spreadsheet are self explanatory, but if not, please ask.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Comparing two curves in excel
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: Comparing two curves in excel
After looking at the data, the first thing I would do is try to get a better view of the relevant information. The curve/data for compression simulation can be removed since you have no values to compare it to. Similarily, the experimental data with strain greater than about .007 can be removed, since you don't have simulation for comparison. Enlarge the graph a little and the difference between the curves is much easier to see than with all the irrelevant data included. This still does not give you meaningful mathematical comparison, but just makes the curves easier to view.
The other thing is that there are two distinct ranges that exhibit different behavior. This is expected as you are obviously looking at the elastic and plastic regions. I would divide each set of data into two ranges and try to fit a curve to only the range you are interested in. For example, I removed all the data with strain values less than 0.1. Fitting a exponential trendline to the remaining data for each set gave a pretty nice fit.
To add a trendline, right click the data on the graph, and select "Add trendline". A window will appear asking for the type. As I said, I tried an exponential curve. Then, select the "options" tab and put a check mark in "Display equation on chart" and "Display R2 value".
With all of the above steps, I was able to get the following information for strain ranging from ~0.1 to ~0.7:
Experimental: 13.607e^.970x
Simulation: 13.660e^1.023x
("x" indicates the strain)
The R2 value for both curves was <0.998
Using the equations to approximate each curve, I plugged in a test value for strain (0.20) and received stress values that differed by approximatly 0.24. At a strain of 0.68 (at the left side of the chart, where the trendlines are clearly farther apart, I got a difference of about 1.07.
I hope you followed what I have done and it provides some help. If this is not what you are looking for or you need a more accurate or descriptive analysis, I think you will need to find a good statistics book or similar.
-- MechEng2005
RE: Comparing two curves in excel
Thank you very much. I did it like this!
RE: Comparing two curves in excel
This is the square of the PEARSON function.