View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
j_erussell01 j_erussell01 is offline
external usenet poster
 
Posts: 1
Default How can I change 0's in the data set to do a LOG with base 2?

I'm analyzing a large data set (80 columns, 800 rows) and some of my values
are 0, but I need to find out how to incoporate/exclude them, because I need
to do a Log with a base 2 on each value in all 80 categories. I'm trying to
calculate the Shannon-Wiener Index on each column (if that helps).