Rolling aggregates of any function with one simple formula!
Making use of the brand-spanking-new ability to pass functions as arguments to other functions, this video follows up to a blog post I made in May 2022 to mimic the functionality of the Pandas rolling module to calculate aggregates over rolling windows of a vector.
The accompanying blog post:
https://www.flexyourdata.com/blog/exc...
The gist for the function:
https://gist.github.com/ncalm/341e69d...
A practice file:
https://github.com/ncalm/social_conte...
#excel #data #exceltips #statistics