| T O P I C R E V I E W |
| O-2 |
Posted - 04/26/2013 : 07:43:15 AM
Origin Ver. and Service Release (Select Help-->About Origin): 8.5
Operating System: Win. 7
I have two worksheets containing each containing a time column and a second parameter. I would like to plot the two parameters against one another. The problem is that the timestamps are out of sync with one another (and also taken at different sampling rates), so plotting row n against row n will not be meaningful.
It's clear that I need to do some form of interpolation and I have heard that there is a way to do this built into Origin. To make it clear here is an example of the type of problem: -
Data set 1: -
t Y1
1879.71979 3.9975
1879.7898 3.9977
1879.85981 3.9972
1879.92982 3.9975
1879.99982 3.9978
Data set 2: -
t Y2
1879.72875 0.07526
1879.72885 0.07204
1879.72895 0.06559
1879.72905 0.07526
1879.63615 0.08815
How can you plot Y1 vs Y2 for a given range of t?
Thank you for any help you can give me. |
| 3 L A T E S T R E P L I E S (Newest First) |
| snowli |
Posted - 04/26/2013 : 11:55:28 AM
Hi DrBob,
Thank you for helping replying it.
BTW if user wants to plot col(E) against col(D) and both of them are Y, you don't have to set col D as X.
With nothing selected in worksheet, click the plot type, e.g. scatter.
Then in Plot Setup dialog.
You can specify col D to be X
Column E to be Y.
Col E will be plotted against col D.
Also in Origin 9, you can just highlight col(E) to plot first.
Then right click the plot and choose Change X context menu. Change X to be col(D).
Thanks, Snow Li
OriginLab Corp.
quote:
Originally posted by Drbobshepherd
O-2,
Origin has an easy way to interpolate one dataset to another.
Assuming Dataset1 is in columns A and B, and Dataset2 is in columns C and D,
1. Be sure cols A and C are of type X. If not, set them by using the Type tool in the top ToolBar or in the Properties window.
2. Sort Dataset2 by selecting cols C,D; then right-click and select Sort/Ascending.
3. Add a column for interpolated Dataset1 values.
4. Select the new column, right-click and select Set Column Values in the pop-up menu.
5. Enter the following in the formula window: Col(B)(Col(C))
6. Click on OK to generate your interpolated values.
Change Column D to type X, select columns D and E, and then plot.
Remember when using "Set Column Values", square brackets are used to assign cell values; parentheses are for assigning interploated values.
DrBob
|
| Drbobshepherd |
Posted - 04/26/2013 : 10:49:56 AM
O-2,
Origin has an easy way to interpolate one dataset to another.
Assuming Dataset1 is in columns A and B, and Dataset2 is in columns C and D,
1. Be sure cols A and C are of type X. If not, set them by using the Type tool in the top ToolBar or in the Properties window.
2. Sort Dataset2 by selecting cols C,D; then right-click and select Sort/Ascending.
3. Add a column for interpolated Dataset1 values.
4. Select the new column, right-click and select Set Column Values in the pop-up menu.
5. Enter the following in the formula window: Col(B)(Col(C))
6. Click on OK to generate your interpolated values.
Change Column D to type X, select columns D and E, and then plot.
Remember when using "Set Column Values", square brackets are used to assign cell values; parentheses are for assigning interploated values.
DrBob |
| matthew@originlab.com |
Posted - 04/26/2013 : 10:31:00 AM
Hi,
You can do this sort of interpolation by going to Analysis > Mathematics > Interpolate/Extrapolate Y from X.
You can create a range of X values for which you wish to compare the 2 parameters, select the column with these X values as the "X Values to Interpolate". For the Input range, you will want to select the columns containing one of your two datasets. You can then select which interpolation method you wish to use and interpolate the data, and repeat the interpolation for the other dataset.
You should then be able to plot the two parameters against each other. Let me know if any of this was unclear or if you have further questions.
Matthew
OriginLab |
|
|
