Forum Discussion
Frequency distribution for unique values
I have a list of tree species and need to figure out the frequency distribution for each species. I know how to get a list of the unique tree species =SORT(UNIQUE(A1:A30)). However I'm unsure how to ...
The 'best' answer depends on where this study is going, what additional information relating to the trees, their maturity, their condition, their location/habitat, and what you wish to demonstrate. For example, if you wanted a geographical distribution you might have formulas such as
= LAMBDA(species,habitat,LAMBDA(selected,
LET(
distinct, UNIQUE(FILTER(species, habitat=selected)),
count, GROUPBY(distinct, distinct, COUNTA),
count
)
))(species, habitat)(selectedHabitat)