Is there a way to use a vector function to take the average of every row's standard deviation? i.e.
=AVERAGE(STDEV(1:1),....,STDEV(15:15))
The following does NOT work (understandably)
{=AVERAGE(STDEV(1:15)}
because the STDEV() function takes the whole double array, instead of simply each row, so this ends up being simply the STDEV() function.
Thanks!
=AVERAGE(STDEV(1:1),....,STDEV(15:15))
The following does NOT work (understandably)
{=AVERAGE(STDEV(1:15)}
because the STDEV() function takes the whole double array, instead of simply each row, so this ends up being simply the STDEV() function.
Thanks!