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

2 ビュー (過去 30 日間)
SAS
SAS 2020 年 6 月 7 日
編集済み: Maximilian Schönau 2020 年 6 月 7 日
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)

回答 (1 件)

Maximilian Schönau
Maximilian Schönau 2020 年 6 月 7 日
編集済み: Maximilian Schönau 2020 年 6 月 7 日
To use a moving average filter in Matlab, use:
M = movmean(A,k)

カテゴリ

Help Center および File ExchangeDescriptive Statistics についてさらに検索

製品


リリース

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by