Project - Data Handling and Interpolation

[num,txt,raw]=xlsread('D:\interpolation.xlsx')

% interpolation in the range of volt at V=-17.3:0.1:09

Volt=[-17.3 -17.1 -17 -16.8 -16.5 -16 -15 -14 -12 -10 -8 -5 -2 -0.2 0.09 0.19 0.27 0.39 0.43 0.5 0.55 0.6 0.62 0.65];

I=[-28 -24 -19 -14 -9 -6 -4 -3 -2 -1.3 -1 -0.6 -0.3 -0.1 0 0 0 0.01 0.03 0.17 0.42 1.23 1.99 3.91];

volt=interp1(Volt,I,-17.3);

volt1=interp1(Volt,I,0.1);

volt2=interp1(Volt,I,09);

[Volt,I]=meshgrid (-17.3:0.1:0.9);

z=I.*exp(-volt.^2-I.^2);

figure(1); surf(Volt,I,z); title('data interpolation');

num =

-17.3000 -28.0000
-17.1000 -24.0000
-17.0000 -19.0000
-16.8000 -14.0000
-16.5000 -9.0000
-16.0000 -6.0000
-15.0000 -4.0000
-14.0000 -3.0000
-12.0000 -2.0000
-10.0000 -1.3000
-8.0000 -1.0000
-5.0000 -0.6000
-2.0000 -0.3000
-0.2000 -0.1000
0.0900 0
0.1900 0
0.2700 0
0.3900 0.0100
0.4300 0.0300
0.5000 0.1700
0.5500 0.4200
0.6000 1.2300
0.6200 1.9900
0.6500 3.9100

txt =

1×2 cell array

{'V (Volt)'} {'I (mAmp)'}

raw =

25×2 cell array

{'V (Volt)'} {'I (mAmp)'}
{[-17.3000]} {[ -28]}
{[-17.1000]} {[ -24]}
{[ -17]} {[ -19]}
{[-16.8000]} {[ -14]}
{[-16.5000]} {[ -9]}
{[ -16]} {[ -6]}
{[ -15]} {[ -4]}
{[ -14]} {[ -3]}
{[ -12]} {[ -2]}
{[ -10]} {[ -1.3000]}
{[ -8]} {[ -1]}
{[ -5]} {[ -0.6000]}
{[ -2]} {[ -0.3000]}
{[ -0.2000]} {[ -0.1000]}
{[ 0.0900]} {[ 0]}
{[ 0.1900]} {[ 0]}
{[ 0.2700]} {[ 0]}
{[ 0.3900]} {[ 0.0100]}
{[ 0.4300]} {[ 0.0300]}
{[ 0.5000]} {[ 0.1700]}
{[ 0.5500]} {[ 0.4200]}
{[ 0.6000]} {[ 1.2300]}
{[ 0.6200]} {[ 1.9900]}
{[ 0.6500]} {[ 3.9100]}