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

2 views (last 30 days)
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?
clear all
T = readtable('C:\Users\SAS\Downloads\ABC.xlsx', 'Range' , 'F2:F154')
% Calculate daily counts

Answers (1)

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


Find more on Descriptive Statistics in Help Center and File Exchange




Community Treasure Hunt

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

Start Hunting!