Project - Data Handling and Interpolation
%%Taking Data from excel sheet
data=readmatrix ('VI.xlsx'); %opening excel file
V=data(:,1); %reading first column
I=data(:,2); %reading data from 2nd column
figure(1)
plot(V,I,'r+')
legend('DATA PROVIDED')
title('DATA POINTS GIVEN IN QUESTION')
%USE THE INTERPOLATION
% interpolation in the range of -17.3:0.1:0.9
xq =[-17.3:0.1:0.9];
figure(2)
Iq1 = interp1(V,I,xq); %USING INTERP1 COMMAND
plot(V,I,'o',xq,Iq1,':.');
xlim([-17.3 0.9]);
legend('MISSING DATA POINT IN THE CURVE')
title('(DATA POINT FOUND USING LINEAR INTERPOLATION');
Iq2 = interp1(V,I,xq,'spline');
figure(3)
plot(V,I,'*',xq,Iq2,':.');
grid;
title('spline Interpolation');
%SAVING TEXT FILE
fileID = fopen('lab_data.txt','W'); %saving file in text file
fprintf(fileID,'%8s %10s\n','V(volt)','I(mAmp)');
fprintf(fileID,'%f %f\n',Iq1);
fclose(fileID);
