Average of selected elements in Matlab

1 次查看（过去 30 天）
Hoai An Nguyen
Hoai An Nguyen 2020-12-24
评论： weikang zhao 2020-12-24
I have a data file, first column is Month, second column is Demand. I want to calculate the Moving Average of month 4 (=(month 1+2+3)/3) and so on. Then, I want to display the results in the 3rd column. How can I do?
Instead of using Excel, I want to use Matlab to calculate this. Please help me :(((

请先登录，再回答此问题。

采纳的回答

weikang zhao
weikang zhao 2020-12-24
编辑：weikang zhao 2020-12-24
easy, use "conv"
x=conv(a(:,2),[1/3,1/3,1/3]);
the first element and the second element of 'x' are useless.
have fun
  4 个评论
显示 2更早的评论
weikang zhao
weikang zhao 2020-12-24
opps, 'x' is a column vector
a(:,3)=[nan,nan,nan,x(3:11).'].';

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by