This task, for Donna Coles (Donna + dataviz), required complex computations, which she often found challenging to verify, due to the intricate steps leading to the final result. The final figure was only visible when hovering over a point on the graph. If there was a mismatch, it turned into a complex problem to pinpoint the error in the process.
Let’s break down this process. Given that we’re dealing with moving averages, we’ll need to utilise table calculations. So our first step is to organise the data and required calculations into a tabular format.