Project - Data Handling and Interpolation

Project :

In a laboratory experiment, data of voltage and current has been recorded and the same is attached in an excel file ( VI.xlsx ). Read the excel file in the Matlab program and perform the interpolation in the range of -17.3:0.1:0.9. Generate the interactive plot for the interpolated data. Additionally, compute the current values for given voltages below and store them in a text file.

% Data Handling & Interpolation

clc
clear all
file=xlsread('VI.xlsx') % Importing data from Excel sheet (VI.xlsx data is given)
format compact;
V=file(:,1) % Extracting the voltage data from Excel
I=file(:,2) % Extracting the current data from Excel
x=-17.3:0.1:0.9; % Interpolation voltage range
y=interp1(V,I,x,'spline'); % Interpolation of current value for the given voltage
subplot(211);
plot(V,I,'o',x,y) % plotting graph between V&I using given data & holding
grid on % showing grid
title('voltage vs current') % title on graph 'voltage vs current'
xlabel('voltage') % labeling on x axis 'voltage'
ylabel('current') % labeling on y axis 'current'
grid on % showing grid

%%
vv=[-17.2
-17.1
13.8
-13.8
-13.5
-13
-12.5
-11
-9
-5.76
-6
-1
0.11
0.11
0.25
0.5
0.61]
II=interp1(V,I,VV) % Interpolation of current value for the given voltage
z=[VV II]

fileID = fopen('VVII.txt','W'); % writing the text file of the interpolation data
fprintf(fileID, '%6s %12s\n','VV','II'); % printing the data on the text file
fprintf(fileID,'%6.2f %12.8f\n',z); % printing the data on the text file
fclose(fileID); % closing the file

following solution is obtained in command window

file =
-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
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
vv =
-17.2000
-17.1000
13.8000
-13.8000
-13.5000
-13.0000
-12.5000
-11.0000
-9.0000
-5.7600
-6.0000
-1.0000
0.1100
0.1100
0.2500
0.5000
0.6100

The plot (figure) is attached below in the attachment.

And program and result are attached below.