Project - Data Handling and Interpolation

perform the interpolation in the range of -17.3:0.1:0.9.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.

AIM :-(i) Read the excel file in the Matlab program and perform the interpolation in the range of -17.3:0.1:0.9

(ii)Generate the interactive plot for the interpolated data and store them in a text file.

SOLUTIONS :-

*To read excel file in matlab programming:

% Read the data from the Excel file
data = readtable('VI.xlsx');

% Extracting the voltage and current data
voltage = data{:,1};
current = data{:,2};

*To perform the interpolation in the range of -17.3:0.1:0.9 :

% Define the range of x-values for the interpolation
x = -17.3:0.1:0.9;

% Performing linear interpolation on the data
interpolated_current = interp1(voltage, current, x, 'linear');

* Generate the interactive plot for the interpolated data and store them in a text file:

% Generate an interactive plot of the interpolated data
plot(x, interpolated_current, 'LineWidth', 2);
title('Interpolated Current vs. Voltage');
xlabel('Voltage (V)');
ylabel('Current (A)');
grid on;

% Save the interpolated data to a text file
save('interpolated_data.txt', 'data_to_save', '-ascii');
output_file = 'interpolated_data.txt';
output_data = [x',interp'];
dlmwrite(output_file, output_data, 'delimiter', '\t', 'precision', 6);

*To find missing interpolated data:

% Find any missing interpolated data
missing_data = x_interp(isnan(I_interp));

% Print the missing data to the console
if isempty(missing_data)
disp('No missing interpolated data found.')
else
fprintf('Missing interpolated data:\n')
fprintf('%f\n', missing_data)
end.

Conclusion: by performing the above codes we can read excel file, interpolate the data, and also we can find the interpolated missing data .

All the results are attached below in the form of screenshots , excel file and others.