Project - Data Handling and Interpolation

x=readmatrix('VI.xlsx');

V=x(:,1);

I=x(:,2);

plot(V,I);

XP=[-17.3:0.1:0.9];

XP1=interp1(V,I,XP)

XP2=interp1(V,I,XP,'spline');

figure(1)

plot(V,I,'O',XP,XP1,':');

title('Linear interpolation');

figure(2)

plot(V,I,'b',XP,XP2,':')

title('spline interpolation');

filename=fopen('project.txt.m');

fclose(filename);

V =

-17.3000
-17.1000
-17.0000
-16.8000
-16.5000
-16.0000
-15.0000
-14.0000
-12.0000
-10.0000
-8.0000
-5.0000
-2.0000
-0.2000
0.0900
0.1900
0.2700
0.3900
0.4300
0.5000
0.5500
0.6000
0.6200
0.6500


I =

-28.0000
-24.0000
-19.0000
-14.0000
-9.0000
-6.0000
-4.0000
-3.0000
-2.0000
-1.3000
-1.0000
-0.6000
-0.3000
-0.1000
0
0
0
0.0100
0.0300
0.1700
0.4200
1.2300
1.9900
3.9100


XP =

Columns 1 through 17

-17.3000 -17.2000 -17.1000 -17.0000 -16.9000 -16.8000 -16.7000 -16.6000 -16.5000 -16.4000 -16.3000 -16.2000 -16.1000 -16.0000 -15.9000 -15.8000 -15.7000

Columns 18 through 34

-15.6000 -15.5000 -15.4000 -15.3000 -15.2000 -15.1000 -15.0000 -14.9000 -14.8000 -14.7000 -14.6000 -14.5000 -14.4000 -14.3000 -14.2000 -14.1000 -14.0000

Columns 35 through 51

-13.9000 -13.8000 -13.7000 -13.6000 -13.5000 -13.4000 -13.3000 -13.2000 -13.1000 -13.0000 -12.9000 -12.8000 -12.7000 -12.6000 -12.5000 -12.4000 -12.3000

Columns 52 through 68

-12.2000 -12.1000 -12.0000 -11.9000 -11.8000 -11.7000 -11.6000 -11.5000 -11.4000 -11.3000 -11.2000 -11.1000 -11.0000 -10.9000 -10.8000 -10.7000 -10.6000

Columns 69 through 85

-10.5000 -10.4000 -10.3000 -10.2000 -10.1000 -10.0000 -9.9000 -9.8000 -9.7000 -9.6000 -9.5000 -9.4000 -9.3000 -9.2000 -9.1000 -9.0000 -8.9000

Columns 86 through 102

-8.8000 -8.7000 -8.6000 -8.5000 -8.4000 -8.3000 -8.2000 -8.1000 -8.0000 -7.9000 -7.8000 -7.7000 -7.6000 -7.5000 -7.4000 -7.3000 -7.2000

Columns 103 through 119

-7.1000 -7.0000 -6.9000 -6.8000 -6.7000 -6.6000 -6.5000 -6.4000 -6.3000 -6.2000 -6.1000 -6.0000 -5.9000 -5.8000 -5.7000 -5.6000 -5.5000

Columns 120 through 136

-5.4000 -5.3000 -5.2000 -5.1000 -5.0000 -4.9000 -4.8000 -4.7000 -4.6000 -4.5000 -4.4000 -4.3000 -4.2000 -4.1000 -4.0000 -3.9000 -3.8000

Columns 137 through 153

-3.7000 -3.6000 -3.5000 -3.4000 -3.3000 -3.2000 -3.1000 -3.0000 -2.9000 -2.8000 -2.7000 -2.6000 -2.5000 -2.4000 -2.3000 -2.2000 -2.1000

Columns 154 through 170

-2.0000 -1.9000 -1.8000 -1.7000 -1.6000 -1.5000 -1.4000 -1.3000 -1.2000 -1.1000 -1.0000 -0.9000 -0.8000 -0.7000 -0.6000 -0.5000 -0.4000

Columns 171 through 183

-0.3000 -0.2000 -0.1000 0 0.1000 0.2000 0.3000 0.4000 0.5000 0.6000 0.7000 0.8000 0.9000


XP1 =

Columns 1 through 17

-28.0000 -26.0000 -24.0000 -19.0000 -16.5000 -14.0000 -12.3333 -10.6667 -9.0000 -8.4000 -7.8000 -7.2000 -6.6000 -6.0000 -5.8000 -5.6000 -5.4000

Columns 18 through 34

-5.2000 -5.0000 -4.8000 -4.6000 -4.4000 -4.2000 -4.0000 -3.9000 -3.8000 -3.7000 -3.6000 -3.5000 -3.4000 -3.3000 -3.2000 -3.1000 -3.0000

Columns 35 through 51

-2.9500 -2.9000 -2.8500 -2.8000 -2.7500 -2.7000 -2.6500 -2.6000 -2.5500 -2.5000 -2.4500 -2.4000 -2.3500 -2.3000 -2.2500 -2.2000 -2.1500

Columns 52 through 68

-2.1000 -2.0500 -2.0000 -1.9650 -1.9300 -1.8950 -1.8600 -1.8250 -1.7900 -1.7550 -1.7200 -1.6850 -1.6500 -1.6150 -1.5800 -1.5450 -1.5100

Columns 69 through 85

-1.4750 -1.4400 -1.4050 -1.3700 -1.3350 -1.3000 -1.2850 -1.2700 -1.2550 -1.2400 -1.2250 -1.2100 -1.1950 -1.1800 -1.1650 -1.1500 -1.1350

Columns 86 through 102

-1.1200 -1.1050 -1.0900 -1.0750 -1.0600 -1.0450 -1.0300 -1.0150 -1.0000 -0.9867 -0.9733 -0.9600 -0.9467 -0.9333 -0.9200 -0.9067 -0.8933

Columns 103 through 119

-0.8800 -0.8667 -0.8533 -0.8400 -0.8267 -0.8133 -0.8000 -0.7867 -0.7733 -0.7600 -0.7467 -0.7333 -0.7200 -0.7067 -0.6933 -0.6800 -0.6667

Columns 120 through 136

-0.6533 -0.6400 -0.6267 -0.6133 -0.6000 -0.5900 -0.5800 -0.5700 -0.5600 -0.5500 -0.5400 -0.5300 -0.5200 -0.5100 -0.5000 -0.4900 -0.4800

Columns 137 through 153

-0.4700 -0.4600 -0.4500 -0.4400 -0.4300 -0.4200 -0.4100 -0.4000 -0.3900 -0.3800 -0.3700 -0.3600 -0.3500 -0.3400 -0.3300 -0.3200 -0.3100

Columns 154 through 170

-0.3000 -0.2889 -0.2778 -0.2667 -0.2556 -0.2444 -0.2333 -0.2222 -0.2111 -0.2000 -0.1889 -0.1778 -0.1667 -0.1556 -0.1444 -0.1333 -0.1222

Columns 171 through 183

-0.1111 -0.1000 -0.0655 -0.0310 0 0 0.0025 0.0150 0.1700 1.2300 NaN NaN NaN