Project - Data Handling and Interpolation
Answer:
% Data handling and Interpolation
clear all;
clc;
Y=xlsread('VI.xlsx'); %Reading the data from excel file
V=Y(:,1); %voltage as a 1st column
I=Y(:,2); %current as a second column
Xq=(-17.3:0.1:0.9);
Yq=interp1(V,I,Xq,'spline'); %interpolate the data
figure(1);plot(V,I,'o',Xq,Yq,':.');grid; %plot the interpolated data
xlabel('V');ylabel('I(mA)');title('Interpolation');
%writing the interpolated data in the text file
fid=fopen('interp_data.txt','w');
for i=1:length(Yq)
fprintf(fid,'%d %d \n',Xq(i),Yq(i));
end
fclose(fid);

Data saved in the text file:
-1.730000e+01 -28
-1.720000e+01 -2.817343e+01
-1.710000e+01 -24
-17 -19
-1.690000e+01 -1.586853e+01
-1.680000e+01 -14
-1.670000e+01 -1.223534e+01
-1.660000e+01 -1.050222e+01
-1.650000e+01 -9
-1.640000e+01 -7.880609e+00
-1.630000e+01 -7.106199e+00
-1.620000e+01 -6.591485e+00
-1.610000e+01 -6.251180e+00
-16 -6
-1.590000e+01 -5.767031e+00
-1.580000e+01 -5.538852e+00
-1.570000e+01 -5.316414e+00
-1.560000e+01 -5.100668e+00
-1.550000e+01 -4.892566e+00
-1.540000e+01 -4.693058e+00
-1.530000e+01 -4.503096e+00
-1.520000e+01 -4.323632e+00
-1.510000e+01 -4.155616e+00
-15 -4
-1.490000e+01 -3.857400e+00
-1.480000e+01 -3.727091e+00
-1.470000e+01 -3.608015e+00
-1.460000e+01 -3.499111e+00
-1.450000e+01 -3.399322e+00
-1.440000e+01 -3.307586e+00
-1.430000e+01 -3.222845e+00
-1.420000e+01 -3.144041e+00
-1.410000e+01 -3.070112e+00
-14 -3
-1.390000e+01 -2.932800e+00
-1.380000e+01 -2.868222e+00
-1.370000e+01 -2.806131e+00
-1.360000e+01 -2.746392e+00
-1.350000e+01 -2.688869e+00
-1.340000e+01 -2.633427e+00
-1.330000e+01 -2.579931e+00
-1.320000e+01 -2.528246e+00
-1.310000e+01 -2.478236e+00
-13 -2.429766e+00
-1.290000e+01 -2.382701e+00
-1.280000e+01 -2.336905e+00
-1.270000e+01 -2.292243e+00
-1.260000e+01 -2.248580e+00
-1.250000e+01 -2.205780e+00
-1.240000e+01 -2.163709e+00
-1.230000e+01 -2.122230e+00
-1.220000e+01 -2.081210e+00
-1.210000e+01 -2.040511e+00
-12 -2
-1.190000e+01 -1.959575e+00
-1.180000e+01 -1.919277e+00
-1.170000e+01 -1.879178e+00
-1.160000e+01 -1.839354e+00
-1.150000e+01 -1.799878e+00
-1.140000e+01 -1.760825e+00
-1.130000e+01 -1.722269e+00
-1.120000e+01 -1.684284e+00
-1.110000e+01 -1.646943e+00
-11 -1.610323e+00
-1.090000e+01 -1.574496e+00
-1.080000e+01 -1.539536e+00
-1.070000e+01 -1.505519e+00
-1.060000e+01 -1.472517e+00
-1.050000e+01 -1.440606e+00
-1.040000e+01 -1.409859e+00
-1.030000e+01 -1.380351e+00
-1.020000e+01 -1.352156e+00
-1.010000e+01 -1.325347e+00
-10 -1.300000e+00
-9.900000e+00 -1.276161e+00
-9.800000e+00 -1.253771e+00
-9.700000e+00 -1.232744e+00
-9.600000e+00 -1.212993e+00
-9.500000e+00 -1.194431e+00
-9.400000e+00 -1.176973e+00
-9.300000e+00 -1.160531e+00
-9.200000e+00 -1.145020e+00
-9.100000e+00 -1.130352e+00
-9 -1.116443e+00
-8.900000e+00 -1.103204e+00
-8.800000e+00 -1.090550e+00
-8.700000e+00 -1.078395e+00
-8.600000e+00 -1.066651e+00
-8.500000e+00 -1.055233e+00
-8.400000e+00 -1.044054e+00
-8.300000e+00 -1.033028e+00
-8.200000e+00 -1.022067e+00
-8.100000e+00 -1.011087e+00
-8 -1
-7.900000e+00 -9.887352e-01
-7.800000e+00 -9.772823e-01
-7.700000e+00 -9.656460e-01
-7.600000e+00 -9.538314e-01
-7.500000e+00 -9.418433e-01
-7.400000e+00 -9.296865e-01
-7.300000e+00 -9.173659e-01
-7.200000e+00 -9.048864e-01
-7.100000e+00 -8.922529e-01
-7 -8.794702e-01
-6.900000e+00 -8.665433e-01
-6.800000e+00 -8.534769e-01
-6.700000e+00 -8.402761e-01
-6.600000e+00 -8.269455e-01
-6.500000e+00 -8.134902e-01
-6.400000e+00 -7.999149e-01
-6.300000e+00 -7.862246e-01
-6.200000e+00 -7.724242e-01
-6.100000e+00 -7.585184e-01
-6 -7.445123e-01
-5.900000e+00 -7.304106e-01
-5.800000e+00 -7.162182e-01
-5.700000e+00 -7.019400e-01
-5.600000e+00 -6.875810e-01
-5.500000e+00 -6.731458e-01
-5.400000e+00 -6.586395e-01
-5.300000e+00 -6.440669e-01
-5.200000e+00 -6.294329e-01
-5.100000e+00 -6.147423e-01
-5 -6.000000e-01
-4.900000e+00 -5.852162e-01
-4.800000e+00 -5.704220e-01
-4.700000e+00 -5.556540e-01
-4.600000e+00 -5.409485e-01
-4.500000e+00 -5.263420e-01
-4.400000e+00 -5.118711e-01
-4.300000e+00 -4.975720e-01
-4.200000e+00 -4.834814e-01
-4.100000e+00 -4.696356e-01
-4 -4.560711e-01
-3.900000e+00 -4.428244e-01
-3.800000e+00 -4.299319e-01
-3.700000e+00 -4.174301e-01
-3.600000e+00 -4.053554e-01
-3.500000e+00 -3.937443e-01
-3.400000e+00 -3.826333e-01
-3.300000e+00 -3.720587e-01
-3.200000e+00 -3.620572e-01
-3.100000e+00 -3.526650e-01
-3.000000e+00 -3.439188e-01
-2.900000e+00 -3.358548e-01
-2.800000e+00 -3.285097e-01
-2.700000e+00 -3.219198e-01
-2.600000e+00 -3.161216e-01
-2.500000e+00 -3.111516e-01
-2.400000e+00 -3.070462e-01
-2.300000e+00 -3.038419e-01
-2.200000e+00 -3.015751e-01
-2.100000e+00 -3.002823e-01
-2.000000e+00 -3.000000e-01
-1.900000e+00 -3.006944e-01
-1.800000e+00 -3.020511e-01
-1.700000e+00 -3.036855e-01
-1.600000e+00 -3.052130e-01
-1.500000e+00 -3.062490e-01
-1.400000e+00 -3.064090e-01
-1.300000e+00 -3.053082e-01
-1.200000e+00 -3.025622e-01
-1.100000e+00 -2.977863e-01
-1 -2.905959e-01
-9.000000e-01 -2.806065e-01
-8.000000e-01 -2.674334e-01
-7.000000e-01 -2.506920e-01
-6.000000e-01 -2.299977e-01
-5.000000e-01 -2.049660e-01
-4.000000e-01 -1.752122e-01
-3.000000e-01 -1.403517e-01
-2.000000e-01 -1.000000e-01
-1.000000e-01 -5.588917e-02
0 -1.821838e-02
1.000000e-01 7.049587e-04
2.000000e-01 -1.616659e-04
3.000000e-01 2.282514e-04
4.000000e-01 1.285246e-02
5.000000e-01 1.700000e-01
6.000000e-01 1.230000e+00
7.000000e-01 1.004334e+01
8.000000e-01 3.907006e+01
9.000000e-01 1.011102e+02