是否可以根据标准计算过去 5 天内的平均值?
我正在尝试找出过去 5 天内和过去 10 天内某些 NBA 数据点的平均值。例如,我想知道对手在过去 5 天内允许了多少次 FG。我还想计算对手在该时间范围内允许对特定位置进行多少次 FG。我该怎么做呢?我已将原始数据附加在下面的 googlesheet 中。
https://docs.google.com/spreadsheets/d/1HYliF8kjfTsf9ursxo0yi5SDF02ZruZXeK-WRdxDhmg/edit?usp=sharing
我希望能够根据 H 列中的对手对 M 列中的数据进行平均以及 A 列中的日期。最终我还想根据 AB 列中的位置对数据进行平均。我很感谢指导!
I am trying to find the average of certain NBA data points over the last 5 and last 10 days. I want to know, for example, how many FG an opponent allowed over the last 5 days. I also want to calculate how many FG an opponent allowed over that time frame to a specific position. How could I go about doing that? I have attached the raw data in a googlesheet below.
https://docs.google.com/spreadsheets/d/1HYliF8kjfTsf9ursxo0yi5SDF02ZruZXeK-WRdxDhmg/edit?usp=sharing
I want to be able to average the data in column M, based on the opponent in column H as well as the date in column A. Eventually I would like to also average that data based on the position, which is in column AB. I appreciate the guidance!
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
每个 OPP 最近 10 天 FG 值的平均值:
连续 5 天将 11 更改为 6
average of last 10 days of FG values per each OPP:
for 5 days change 11 to 6