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

3 visualizaciones (últimos 30 días)
SAS
SAS el 7 de Jun. de 2020
Editada: Maximilian Schönau el 7 de Jun. de 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)

Iniciar sesión para responder a esta pregunta.

Respuestas (1)

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

Categorías

Más información sobre Descriptive Statistics en Help Center y File Exchange.

Etiquetas

Productos


Versión

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by