Smoothed curve new x and y coordinates

I have X and Y data on excel

I imported the table to matlab and plotted the curve and then smoothed it.

How can i get the new values of X and Y of the smoothed curve ?

Thank You

[Askic V]

The question should be how to get smoothed Y values, because X values should stay the same.

Probably as an output from your smoothing function or whatever you applied on the Y data.

y_smooth = smooth(Y)

[Akira Agata]

I believe smoothdata function's help page will be some help.

Answer 1

[Naren]

Refer to the below code which possibly resolves your problem.

data = readtable('mydata.xlsx');
x = data.X; % Assuming the column with X data is named "X"
y = data.Y; % Assuming the column with Y data is named "Y"

% Smooth the curve using moving average
windowSize = 5;
smoothY = movmean(y,windowSize);

% You can plot the both and compare for better understanding

figure;
plot(x,y);
hold on;
plot(x,smoothY);

%export the smoothed data into a excel file
smoothData = table(x,smoothY) % table containing smoothed y values.
writetable(smoothData,'smoothed_data.xlsx');

This code assumes that your X and Y data are in separate columns in your Excel file named "mydata.xlsx". The code reads in the data using the readtable() function, and then extracts the X and Y data into separate variables, and then applies a moving average smoothing to the Y data using the movmean() function.

Finally, the smoothed data is saved to a new Excel file using the writetable() function. The new file will contain two columns, one for X and one for the smoothed Y values.

Refer the documentation below for further information.

Moving mean - MATLAB movmean (mathworks.com)

[Corey Silva]

The smoothdata function will help you out here.

You can simply use the table as an input to this function.

>> smoothdata(t,"movmean") % smoothes the data contained in the table t with the "movmean" method