+ Reply to Thread
Results 1 to 3 of 3

Frequency of Negative Numbers

  1. #1
    Registered User
    Join Date
    04-04-2012
    Location
    Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    1

    Frequency of Negative Numbers

    I am trying to use the Frequency function but many of my values are negative numbers. How do I set the bin values to accurately capture all of the data? Of my 906 data points, only 756 are being counted (sum of all the frequencies). The values range from -206 to 135. I have the bin column set to the following:

    -206
    -99
    -67
    -35
    -27
    -19
    -11
    -3
    -1
    0
    2
    10
    18
    26
    34
    66
    98


    Any help is appreciated!!

  2. #2
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: Frequency of Negative Numbers

    Please attach a copy of your workbook. At least the data with Frequency analisys.

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Frequency of Negative Numbers

    The FREQUENCY array should be one cell taller than the bins array. The last FREQUENCY value is the count of data values greater than the last bin.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1