# How to do moving average for x and y data points in a scatter plot?

47 views (last 30 days)
Vidushi Koliyan on 23 Apr 2023
Commented: Image Analyst on 23 Apr 2023
I have soil moisture (x) data in the first column and correlation(y) data in the second column. I want a moving average line through the scatter plot of x and y data.I am getting a line which is connecting all the points which seems quite wrong.
Can somebody help me with this?
Thank you so much.
##### 2 CommentsShow 1 older commentHide 1 older comment
Vidushi Koliyan on 23 Apr 2023
Below is the code I used for 10 points. But it doesn't include x data. I want to see how moving average will look like with x y data.
x = DATA(:,1);
y = DATA(:,2);
plot(x,y,'xr-')
N = 8;
V = ones(1,N)/N;
Z = conv(y,V,'same')
hold on
plot(x,Z,'b-')

Dyuman Joshi on 23 Apr 2023
Moved: Image Analyst on 23 Apr 2023
It's not clear to me what exactly do you want to achieve.
You say 10 points, but you use N=8.
"I want to see how moving average will look like with x y data. "
Do you mean like this?
x = DATA(:,1);
y = DATA(:,2);
scatter(x,y,'xr')
N = 8;
%Moving mean of both x and y data
arr=movmean(DATA,N,1);
hold on
plot(arr(:,1),arr(:,2),'b-') Image Analyst on 23 Apr 2023
Garbage in garbage out. I think that even after smoothing the data points are unreliable. What is the time (called "x" by you instead of "t") sampling rate of this soil mosture device? What time period is it over? Milliseconds, seconds, hours, weeks, months? There seems to be little correlation between adjacent time points and I would not expect that for soil moisture unless the time points were very far apart.