Interpolation in excel with uneven amount of dataHow do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?How do I properly clean up Excel interop objects?How to create strings containing double quotes in Excel formulas?Interpolating data points in ExcelReturn empty cell from formula in ExcelWhat is correct content-type for excel files?Excel to CSV with UTF8 encodingShortcut to Apply a Formula to an Entire Column in ExcelHow to avoid using Select in Excel VBAInterpolating uneven data with SciPy
What does a black-and-white Puerto Rican flag signify?
What does a Nintendo Game Boy do when turned on without a game cartridge inserted?
Killing a star safely
Cargo capacity of a kayak
How can I deal with someone that wants to kill something that isn't supposed to be killed?
What is a "staved" town, like in "Staverton"?
My current job follows "worst practices". How can I talk about my experience in an interview without giving off red flags?
Does Mathematica 12 support GT 730 CUDA?
Quickest way to move a line in a text file before another line in a text file?
Is there an English word to describe when a sound "protrudes"?
Source for "everyone has a specific area of Torah that they're naturally drawn to"
Trivial non-dark twist in dark fantasy
I am a dual citizen of United States and Mexico, can I use my Mexican license in california when visiting?
MITM on HTTPS traffic in Kazakhstan 2019
How to pass array of values in lualatex?
If hash functions append the length, why does length extension attack work?
Is it better to merge "often" or only after completion do a big merge of feature branches?
Do I have to mention my main character's age?
Has Peter Parker ever eaten bugs?
Why is DC so, so, so Democratic?
What are "the high ends of castles" called?
Stellen - Putting, or putting away?
Can I make Ubuntu 18.04 switch between multiple windows of the program by just clicking the icon?
Oriented vector bundle with odd-dimensional fibers
Interpolation in excel with uneven amount of data
How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?How do I properly clean up Excel interop objects?How to create strings containing double quotes in Excel formulas?Interpolating data points in ExcelReturn empty cell from formula in ExcelWhat is correct content-type for excel files?Excel to CSV with UTF8 encodingShortcut to Apply a Formula to an Entire Column in ExcelHow to avoid using Select in Excel VBAInterpolating uneven data with SciPy
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I have a base data set which includes elevation and dept. then I have my own data set that has depth and corresponding temperature value for this depth. there is more data points in the measured data. I need to calculate the true vertical depth of this MD_data.
I am trying to interpolate the measured depth to the elevation but cannot figure it out either with excel or matlab.
Could anyone help.
For example:
Base data:
Elevation MD_1
5.13 0
2.9 3
0.68 6
and then my own data:
MD_data temp
0.71 11.01
0.76 11.0086
0.81 10.9663
0.86 10.9318
0.91 10.9182
0.96 10.8929
1.01 10.8746
1.06 10.8506
1.11 10.8495
1.16 10.8333
1.21 10.8162
1.26 10.8273
1.31 10.8178
1.36 10.7959
1.41 10.8046
1.46 10.7864
1.51 10.7972
1.56 10.7994
1.61 10.7878
1.66 10.7709
1.71 10.7745
1.76 10.7559
1.81 10.7559
1.86 10.751
1.91 10.7483
1.96 10.7508
2.01 10.7433
2.06 10.7393
2.11 10.7199
2.16 10.7167
2.21 10.7288
2.26 10.7073
2.31 10.6963
2.36 10.7073
2.41 10.7071
2.46 10.6846
2.51 10.6646
2.55 10.6653
2.6 10.6644
2.65 10.6406
2.7 10.6254
2.75 10.6189
2.8 10.6079
2.85 10.6008
2.9 10.5731
2.95 10.5565
3 10.5586
3.05 10.5456
3.1 10.5236
3.15 10.5166
3.2 10.4955
3.25 10.4893
3.3 10.4689
3.35 10.425
3.4 10.4066
3.45 10.426
3.5 10.368
3.55 10.3387
3.6 10.3343
3.65 10.3008
3.7 10.2471
3.75 10.2524
3.8 10.2117
3.85 10.1843
3.9 10.1568
3.95 10.1285
4 10.125
4.05 10.0546
4.1 10.0416
4.15 10.0153
4.2 9.99575
4.25 9.94704
4.3 9.9299
4.35 9.89131
4.4 9.8462
4.45 9.83795
4.5 9.76133
4.55 9.73264
4.6 9.68054
4.65 9.65384
4.7 9.6216
4.75 9.61552
4.8 9.52464
4.84 9.52095
4.89 9.47829
4.94 9.44347
4.99 9.41413
5.04 9.36617
5.09 9.33437
5.14 9.28475
5.19 9.25456
5.24 9.23113
5.29 9.19137
5.34 9.14046
5.39 9.11016
5.44 9.07665
5.49 9.04492
5.54 8.97973
5.59 8.94247
5.64 8.90707
5.69 8.85949
5.74 8.81783
5.79 8.77764
5.84 8.73316
5.89 8.69131
5.94 8.64269
5.99 8.62218
6.04 8.57532
excel matlab excel-formula interpolation
edited Mar 26 at 13:50
HansHirse
3,1935 gold badges11 silver badges31 bronze badges
asked Mar 26 at 13:38
alexalex
11 bronze badge
add a comment |
I have a base data set which includes elevation and dept. then I have my own data set that has depth and corresponding temperature value for this depth. there is more data points in the measured data. I need to calculate the true vertical depth of this MD_data.
I am trying to interpolate the measured depth to the elevation but cannot figure it out either with excel or matlab.
Could anyone help.
For example:
Base data:
Elevation MD_1
5.13 0
2.9 3
0.68 6
and then my own data:
MD_data temp
0.71 11.01
0.76 11.0086
0.81 10.9663
0.86 10.9318
0.91 10.9182
0.96 10.8929
1.01 10.8746
1.06 10.8506
1.11 10.8495
1.16 10.8333
1.21 10.8162
1.26 10.8273
1.31 10.8178
1.36 10.7959
1.41 10.8046
1.46 10.7864
1.51 10.7972
1.56 10.7994
1.61 10.7878
1.66 10.7709
1.71 10.7745
1.76 10.7559
1.81 10.7559
1.86 10.751
1.91 10.7483
1.96 10.7508
2.01 10.7433
2.06 10.7393
2.11 10.7199
2.16 10.7167
2.21 10.7288
2.26 10.7073
2.31 10.6963
2.36 10.7073
2.41 10.7071
2.46 10.6846
2.51 10.6646
2.55 10.6653
2.6 10.6644
2.65 10.6406
2.7 10.6254
2.75 10.6189
2.8 10.6079
2.85 10.6008
2.9 10.5731
2.95 10.5565
3 10.5586
3.05 10.5456
3.1 10.5236
3.15 10.5166
3.2 10.4955
3.25 10.4893
3.3 10.4689
3.35 10.425
3.4 10.4066
3.45 10.426
3.5 10.368
3.55 10.3387
3.6 10.3343
3.65 10.3008
3.7 10.2471
3.75 10.2524
3.8 10.2117
3.85 10.1843
3.9 10.1568
3.95 10.1285
4 10.125
4.05 10.0546
4.1 10.0416
4.15 10.0153
4.2 9.99575
4.25 9.94704
4.3 9.9299
4.35 9.89131
4.4 9.8462
4.45 9.83795
4.5 9.76133
4.55 9.73264
4.6 9.68054
4.65 9.65384
4.7 9.6216
4.75 9.61552
4.8 9.52464
4.84 9.52095
4.89 9.47829
4.94 9.44347
4.99 9.41413
5.04 9.36617
5.09 9.33437
5.14 9.28475
5.19 9.25456
5.24 9.23113
5.29 9.19137
5.34 9.14046
5.39 9.11016
5.44 9.07665
5.49 9.04492
5.54 8.97973
5.59 8.94247
5.64 8.90707
5.69 8.85949
5.74 8.81783
5.79 8.77764
5.84 8.73316
5.89 8.69131
5.94 8.64269
5.99 8.62218
6.04 8.57532
excel matlab excel-formula interpolation
edited Mar 26 at 13:50
HansHirse
3,1935 gold badges11 silver badges31 bronze badges
asked Mar 26 at 13:38
alexalex
11 bronze badge
add a comment |
I have a base data set which includes elevation and dept. then I have my own data set that has depth and corresponding temperature value for this depth. there is more data points in the measured data. I need to calculate the true vertical depth of this MD_data.
I am trying to interpolate the measured depth to the elevation but cannot figure it out either with excel or matlab.
Could anyone help.
For example:
Base data:
Elevation MD_1
5.13 0
2.9 3
0.68 6
and then my own data:
MD_data temp
0.71 11.01
0.76 11.0086
0.81 10.9663
0.86 10.9318
0.91 10.9182
0.96 10.8929
1.01 10.8746
1.06 10.8506
1.11 10.8495
1.16 10.8333
1.21 10.8162
1.26 10.8273
1.31 10.8178
1.36 10.7959
1.41 10.8046
1.46 10.7864
1.51 10.7972
1.56 10.7994
1.61 10.7878
1.66 10.7709
1.71 10.7745
1.76 10.7559
1.81 10.7559
1.86 10.751
1.91 10.7483
1.96 10.7508
2.01 10.7433
2.06 10.7393
2.11 10.7199
2.16 10.7167
2.21 10.7288
2.26 10.7073
2.31 10.6963
2.36 10.7073
2.41 10.7071
2.46 10.6846
2.51 10.6646
2.55 10.6653
2.6 10.6644
2.65 10.6406
2.7 10.6254
2.75 10.6189
2.8 10.6079
2.85 10.6008
2.9 10.5731
2.95 10.5565
3 10.5586
3.05 10.5456
3.1 10.5236
3.15 10.5166
3.2 10.4955
3.25 10.4893
3.3 10.4689
3.35 10.425
3.4 10.4066
3.45 10.426
3.5 10.368
3.55 10.3387
3.6 10.3343
3.65 10.3008
3.7 10.2471
3.75 10.2524
3.8 10.2117
3.85 10.1843
3.9 10.1568
3.95 10.1285
4 10.125
4.05 10.0546
4.1 10.0416
4.15 10.0153
4.2 9.99575
4.25 9.94704
4.3 9.9299
4.35 9.89131
4.4 9.8462
4.45 9.83795
4.5 9.76133
4.55 9.73264
4.6 9.68054
4.65 9.65384
4.7 9.6216
4.75 9.61552
4.8 9.52464
4.84 9.52095
4.89 9.47829
4.94 9.44347
4.99 9.41413
5.04 9.36617
5.09 9.33437
5.14 9.28475
5.19 9.25456
5.24 9.23113
5.29 9.19137
5.34 9.14046
5.39 9.11016
5.44 9.07665
5.49 9.04492
5.54 8.97973
5.59 8.94247
5.64 8.90707
5.69 8.85949
5.74 8.81783
5.79 8.77764
5.84 8.73316
5.89 8.69131
5.94 8.64269
5.99 8.62218
6.04 8.57532
excel matlab excel-formula interpolation
edited Mar 26 at 13:50
HansHirse
3,1935 gold badges11 silver badges31 bronze badges
asked Mar 26 at 13:38
alexalex
11 bronze badge
I have a base data set which includes elevation and dept. then I have my own data set that has depth and corresponding temperature value for this depth. there is more data points in the measured data. I need to calculate the true vertical depth of this MD_data.
I am trying to interpolate the measured depth to the elevation but cannot figure it out either with excel or matlab.
Could anyone help.
For example:
Base data:
Elevation MD_1
5.13 0
2.9 3
0.68 6
and then my own data:
MD_data temp
0.71 11.01
0.76 11.0086
0.81 10.9663
0.86 10.9318
0.91 10.9182
0.96 10.8929
1.01 10.8746
1.06 10.8506
1.11 10.8495
1.16 10.8333
1.21 10.8162
1.26 10.8273
1.31 10.8178
1.36 10.7959
1.41 10.8046
1.46 10.7864
1.51 10.7972
1.56 10.7994
1.61 10.7878
1.66 10.7709
1.71 10.7745
1.76 10.7559
1.81 10.7559
1.86 10.751
1.91 10.7483
1.96 10.7508
2.01 10.7433
2.06 10.7393
2.11 10.7199
2.16 10.7167
2.21 10.7288
2.26 10.7073
2.31 10.6963
2.36 10.7073
2.41 10.7071
2.46 10.6846
2.51 10.6646
2.55 10.6653
2.6 10.6644
2.65 10.6406
2.7 10.6254
2.75 10.6189
2.8 10.6079
2.85 10.6008
2.9 10.5731
2.95 10.5565
3 10.5586
3.05 10.5456
3.1 10.5236
3.15 10.5166
3.2 10.4955
3.25 10.4893
3.3 10.4689
3.35 10.425
3.4 10.4066
3.45 10.426
3.5 10.368
3.55 10.3387
3.6 10.3343
3.65 10.3008
3.7 10.2471
3.75 10.2524
3.8 10.2117
3.85 10.1843
3.9 10.1568
3.95 10.1285
4 10.125
4.05 10.0546
4.1 10.0416
4.15 10.0153
4.2 9.99575
4.25 9.94704
4.3 9.9299
4.35 9.89131
4.4 9.8462
4.45 9.83795
4.5 9.76133
4.55 9.73264
4.6 9.68054
4.65 9.65384
4.7 9.6216
4.75 9.61552
4.8 9.52464
4.84 9.52095
4.89 9.47829
4.94 9.44347
4.99 9.41413
5.04 9.36617
5.09 9.33437
5.14 9.28475
5.19 9.25456
5.24 9.23113
5.29 9.19137
5.34 9.14046
5.39 9.11016
5.44 9.07665
5.49 9.04492
5.54 8.97973
5.59 8.94247
5.64 8.90707
5.69 8.85949
5.74 8.81783
5.79 8.77764
5.84 8.73316
5.89 8.69131
5.94 8.64269
5.99 8.62218
6.04 8.57532
excel matlab excel-formula interpolation
excel matlab excel-formula interpolation
edited Mar 26 at 13:50
HansHirse
3,1935 gold badges11 silver badges31 bronze badges
asked Mar 26 at 13:38
alexalex
11 bronze badge
edited Mar 26 at 13:50
HansHirse
3,1935 gold badges11 silver badges31 bronze badges
asked Mar 26 at 13:38
alexalex
11 bronze badge
edited Mar 26 at 13:50
HansHirse
3,1935 gold badges11 silver badges31 bronze badges
edited Mar 26 at 13:50
HansHirse
3,1935 gold badges11 silver badges31 bronze badges
edited Mar 26 at 13:50
HansHirse
3,1935 gold badges11 silver badges31 bronze badges
3,1935 gold badges11 silver badges31 bronze badges
asked Mar 26 at 13:38
alexalex
11 bronze badge
asked Mar 26 at 13:38
alexalex
11 bronze badge
asked Mar 26 at 13:38
alexalex
11 bronze badge
11 bronze badge
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Interpolation is fairly easy in Matlab. Check out interp1(): https://www.mathworks.com/help/matlab/ref/interp1.html
If you provide the 3-row data as x and v (column 2 and column 1 respectively), and the first column n-row as xq you'll get back the corresponding elevations for your n-row data.
Keep in mind that you should have some idea of how you want to interpolate. Linear interpolation vs. cubic interpolation vs. others will produce different results. That link will have some documentation as to which method does what.
answered Mar 26 at 14:09
dwethdweth
786 bronze badges
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55358547%2finterpolation-in-excel-with-uneven-amount-of-data%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Interpolation is fairly easy in Matlab. Check out interp1(): https://www.mathworks.com/help/matlab/ref/interp1.html
If you provide the 3-row data as x and v (column 2 and column 1 respectively), and the first column n-row as xq you'll get back the corresponding elevations for your n-row data.
Keep in mind that you should have some idea of how you want to interpolate. Linear interpolation vs. cubic interpolation vs. others will produce different results. That link will have some documentation as to which method does what.
answered Mar 26 at 14:09
dwethdweth
786 bronze badges
add a comment |
Interpolation is fairly easy in Matlab. Check out interp1(): https://www.mathworks.com/help/matlab/ref/interp1.html
If you provide the 3-row data as x and v (column 2 and column 1 respectively), and the first column n-row as xq you'll get back the corresponding elevations for your n-row data.
Keep in mind that you should have some idea of how you want to interpolate. Linear interpolation vs. cubic interpolation vs. others will produce different results. That link will have some documentation as to which method does what.
answered Mar 26 at 14:09
dwethdweth
786 bronze badges
add a comment |
Interpolation is fairly easy in Matlab. Check out interp1(): https://www.mathworks.com/help/matlab/ref/interp1.html
If you provide the 3-row data as x and v (column 2 and column 1 respectively), and the first column n-row as xq you'll get back the corresponding elevations for your n-row data.
Keep in mind that you should have some idea of how you want to interpolate. Linear interpolation vs. cubic interpolation vs. others will produce different results. That link will have some documentation as to which method does what.
answered Mar 26 at 14:09
dwethdweth
786 bronze badges
Interpolation is fairly easy in Matlab. Check out interp1(): https://www.mathworks.com/help/matlab/ref/interp1.html
If you provide the 3-row data as x and v (column 2 and column 1 respectively), and the first column n-row as xq you'll get back the corresponding elevations for your n-row data.
Keep in mind that you should have some idea of how you want to interpolate. Linear interpolation vs. cubic interpolation vs. others will produce different results. That link will have some documentation as to which method does what.
answered Mar 26 at 14:09
dwethdweth
786 bronze badges
answered Mar 26 at 14:09
dwethdweth
786 bronze badges
answered Mar 26 at 14:09
dwethdweth
786 bronze badges
answered Mar 26 at 14:09
dwethdweth
786 bronze badges
786 bronze badges
add a comment |
add a comment |
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55358547%2finterpolation-in-excel-with-uneven-amount-of-data%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
