Forum Discussion
Solved
Excel Formula Problem
Hi, I have an excel sheet with thousands of rows four individual persons and hundreds of columns of categories. Each four consecutive columns can be clubbed as category. I want to do an analysis of t...
For best analysis change your structure from crosstabular form into a flat table:
Person - Category - Sub - Type - Value
Then it is just a matter of a quick pivot table.
formula enter in excel sheet
Species name Frequency % Density Relative frequency (RF) Relative density(RD) IVI=RF+RD ni/N Paspalum sp 85 5.4 13.2192846 #DIV/0! Cynodon dactylon 65 10.9 10.1088647 #DIV/0! Dracocephalum moldavica 78 3.9 12.13063764 #DIV/0! Centella asiatica 40 3.15 6.220839813 #DIV/0! Alternanthera sp 50 2.45 #DIV/0! #DIV/0! cyperus sp 50 2.85 #DIV/0! #DIV/0! Eclipta sp 5 0.45 #DIV/0! #DIV/0! Spilanthes sp 35 1.05 #DIV/0! #DIV/0!