Forum Discussion
Measure of how concentrated or scattered values are
For those interested and for future reference, I posted this question on the FreeMathHelp forum where a very helpful Dr. Peterson put me on the right track: https://www.freemathhelp.com/forum/threads/measure-of-how-concentrated-or-scattered-values-are.131291/. Basically, you treat the timeline data as a frequency table (which in a certain sense it is actually) and then apply statistical measures like InterQuartile Range (IQR), standard deviation, and/or others.
Which then leads to the next problem, namely how to get this done in Excel, discussed here: Percentiles from frequency table, also solved (using Power Query).
For those interested and for future reference, I posted this question on the FreeMathHelp forum where a very helpful Dr. Peterson put me on the right track: https://www.freemathhelp.com/forum/threads/measure-of-how-concentrated-or-scattered-values-are.131291/. Basically, you treat the timeline data as a frequency table (which in a certain sense it is actually) and then apply statistical measures like InterQuartile Range (IQR), standard deviation, and/or others.
Which then leads to the next problem, namely how to get this done in Excel, discussed here: Percentiles from frequency table, also solved (using Power Query).