Results 1 to 2 of 2

frequency formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-16-2012
    Location
    Denmark
    MS-Off Ver
    O365
    Posts
    256

    frequency formula

    I am trying to make a histogram and I used =FREQUENCY(B1:B200;D9:D19) to get the frequency but it seems that there is something wrong with my formula because

    1. for the 108.25-11.28 it shows more than 100 and i only have 100 data (should exclude zeros)
    2. I double check the data by making it in ascending order and it does not match
    Attached Files Attached Files
    Last edited by Elainefish; 07-09-2013 at 04:00 AM.

Thread Information

Users Browsing this Thread

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

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