We are using Codap for a physics lesson that uses a NetLogo model. We know we can use a summary table with parent level functions to get a summarizing average for data, but we’d like students to be able to compute running/moving averages for current as the model runs or retroactively after they have collected data for an entire run. What I mean by this is an average at each stage of the model run. We could do this with the data for the table in excel with the formula =average(instantaneous current$1, instantaneous current1) and drag the formula down through other cells of the table such that it changes to =average(instantaneous current$1, instantaneous current3) and etc. [Here I am using “instantaneous current” as the column header that would normally be a letter in excel].
Is there any way to perform a similar function in Codap with the mean formula?