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

3 Ansichten (letzte 30 Tage)
SAS
SAS am 7 Jun. 2020
Bearbeitet: Maximilian Schönau am 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)

Melden Sie sich an, um diese Frage zu beantworten.

Antworten (1)

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

Kategorien

Mehr zu Descriptive Statistics finden Sie in Help Center und File Exchange

Tags

Produkte


Version

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by