Hi. Thanks for stopping by my question. Would you know how I can analyze data to give you the most common range, for a more meaningful analysis? I guess it would require that we define some parameters, but what are those parameters, and would this be a formula or array? Essentially, it would be, conceptually, like a scatterplot, but without the plot itself. I just want the data to be automatically analyzed to output the most common ranges. You probably already got what I'm asking, but here's a quick, unsophisticated example, assume 1 column like this:
3
91
95
96
96.5
89
157
177
175
181
250
299
301
793
So, I'd want the output for the above example to be:
1st most common range of values: 89-96.5
2nd most common range of values: 177-181
3rd most common range of values: 299-301
I'm not sure how/where I'd tell Excel what constitutes a "range", or how this even works.
Thanks for showing me the right direction/formula/array, since I think this might be more meaningful than just looking for 1 value that represents "mode", when often, there is no single number that occurs more than once in a data set and more meaningful data appears in clusters that are probably just ranges. Thanks for helping me out and guiding me down the right path.
3
91
95
96
96.5
89
157
177
175
181
250
299
301
793
So, I'd want the output for the above example to be:
1st most common range of values: 89-96.5
2nd most common range of values: 177-181
3rd most common range of values: 299-301
I'm not sure how/where I'd tell Excel what constitutes a "range", or how this even works.
Thanks for showing me the right direction/formula/array, since I think this might be more meaningful than just looking for 1 value that represents "mode", when often, there is no single number that occurs more than once in a data set and more meaningful data appears in clusters that are probably just ranges. Thanks for helping me out and guiding me down the right path.
