Hey,
I came across this article that illustrates, plots, explains and ultimately helped me understand what filter to choose for my next projects:
Copy paste from its conclusion:
Averaging: easy to implement and understand.
Running average: can use a lot of memory; usually not a good choice for an Arduino sketch.
Exponential filter: easy to change the amount of filtering using a weight; doesn’t need much memory; easy to implement with our Arduino filter library.