Project - Data Handling and Interpolation

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.

VV =[-17.2 -17.1 -13.8 -13.5 -13.0 -12.5 -11 -9 -5.76 -6 -1 0.11 0.25 0.5 0.61]’

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

Your Answers

Aim :

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.

VV =[-17.2 -17.1 -13.8 -13.5 -13.0 -12.5 -11 -9 -5.76 -6 -1 0.11 0.25 0.5 0.61]’

Answer:

plot(VVolt,ImAmp,'-ob','MarkerFacecolor','r','linewidth',3);

VV = interpl(VVolt,ImAmp)

VVolt=-17.3:0.1:0.9;

xlabel('voltage');

ylabel('current');

fileidl=fopen('C:\users\suman\Documents\week3.xlsx','r')

fileid=fopen('C:\users\suman\Documents\Matlab basics\project.txt','w')

VV =[-17.2 -17.1 -13.8 -13.5 -13.0 -12.5 -11 -9 -5.76 -6 -1 0.11 0.25 0.5 0.61];

VVolt=-17.3:0.1:0.9;

c=interpl(VV,VVolt);

fprintf(fileid,'%d',VV)

figure

plot((-28:-14),VV,'o',VVolt,c,'*');

ylabel('voltage');

xlabel('current');

legend('VV','c');

THE MATLAB PROGRAMMES WITH THE MAPS ARE UPLODED AS FILE BELOW