discontinuous data in excel

Home > Statistics Every Writer Should Know > The Stats Board > Discusssion

discontinuous data in excel
Message posted by Rebecca Smith (via 195.99.125.204) on August 10, 2001 at 4:14 AM (ET)

Does anybody have experience of discontinuous data (eg possible values are 'positive' 'negative' and 'trace') handling in Excel? Is there a way to use FREQUENCY to count occurrences of each value or do you have to count by hand?

READERS RESPOND:
(In chronological order. Most recent at the bottom.)

Re: discontinuous data in excel
Message posted by darius (via 200.23.217.10) on August 13, 2001 at 11:08 AM (ET)

It's easer to use

=COUNTIF(RANGE,">1")
=COUNTIF(RANGE,"<0")

Re: discontinuous data in excel
Message posted by Rebecca Smith (via 195.99.125.204) on August 15, 2001 at 11:21 AM (ET)

I eventually gave in, called them '1', '2' and '3' and then used 'Histogram'.

thanks

Your $5 contribution helps cover part the $500 annual cost of keeping this site online.