Project - Data Handling and Interpolation

Q )

Project :

In a laboratory experiment, data of voltage and current has been recorded and the same is attached in an excel file ( Click on this link 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 and store them in a text file.

Key Highlights:

• Graphical solutions are more visual and appealing
• Interpolation of data
• Read excel file
• Write to text file

Deliverables:

• Find missing data and save it in text
• Interpolate the data set
• Save your program and attach the same.
• Save txt file and upload in attachment

p= xlsread('V_I.xlsx');

v=p(:,1);
i=p(:,2);
x=-17.3:0.1:0.9;

y= interp1(v,i,x);
figure(1);
plot(v,i,'bo',x,y,':');
xlabel('voltage (v)');
ylabel('current (i)');
legend({'actual value', 'interpolated value'},'location','southeast');
grid;

fileID=fopen('interp_data.txt','w');
fprintf(fileID,'%10s %15s\n','v','i');
fprintf(fileID,'%f %f\n',y);
fclose(fileID);