Smoothed daily count of each column by applying a moving average filter of length 7

1 view (last 30 days)
SAS
SAS on 7 Jun 2020
Edited: max on 7 Jun 2020
I am trying to read F column data from an excel file and then using command of smooth to solve the problem. But it is giving errors. How can we smooth data of this column by applying average filter of length 7?
clc
clear all
T = readtable('C:\Users\SAS\Downloads\ABC.xlsx', 'Range' , 'F2:F154')
% Calculate daily counts
yy=smooth(T)

Answers (1)

max
max on 7 Jun 2020
Edited: max on 7 Jun 2020
To use a moving average filter in Matlab, use:
M = movmean(A,k)

Products


Release

R2020a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!