20162016韓劇推薦|討論2016韓劇推薦推薦好看的韓劇推薦與韓劇推薦2016韓劇排行榜前十名 , 好看的韓劇推薦 , 2016韓劇收視率

想請問一下
以A2~10為被平均範例, B1~E1為移動平均數,

B4=(A2+A3)/$B$1 往下拉
C5=(A2+A3+A4)/$C$1 往下拉
D6=(A2+A3+A4+A5)/$D$1 往下拉
E7=(A2+A3+A4+A5+A6)/$E$1 往下拉

目前是用這種粗略公式,問題是打到20移動平均我就昏了,而且最近還要重打.....

____A___B___C___D___E
1_______2___3____4___5
2___3_________________
3___6_________________
4___9__4.5_____________
5___4__7.5___6_________
6___2__6.5___6.3__5.5___
7___7___3____5___5.2__4.8
8___8__4.5___4.3__5.5__5.6
9___2__7.5___5.6__5.2___6
10__8___5___5.6___4.7__4.6

以上均為手算~若有錯誤~純屬我手殘....

有沒有能理解的大師能指點一下

有沒有更方便一點的公式?

This entry passed through the Full-Text RSS service — if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers. Five Filters recommends: 'You Say What You Like, Because They Like What You Say' - http://www.medialens.org/index.php/alerts/alert-archive/alerts-2013/731-you-say-what-you-like-because-they-like-what-you-say.html