+ Reply to Thread
Results 1 to 5 of 5

Frequency distribution

Hybrid View

  1. #1
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    27,152

    Re: Frequency distribution

    [initial response deleted]

    After looking at your data, I don't think your question is well-formulated. You have activities with a Start and Stop time. For a given interval, what you do want to count?

    The number of activities that start in that interval
    The number of activities that end in that interval
    The number of activities that have any portion of time in that interval

    For questions like this it's always helpful to include a sample of what you want the result to be.
    Last edited by 6StringJazzer; 08-28-2017 at 03:36 PM.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  2. #2
    Registered User
    Join Date
    08-28-2017
    Location
    Poland
    MS-Off Ver
    2016
    Posts
    2
    I would like to count The number of activities that have any portion of time in that interval



    Quote Originally Posted by 6StringJazzer View Post
    [initial response deleted]

    After looking at your data, I don't think your question is well-formulated. You have activities with a Start and Stop time. For a given interval, what you do want to count?

    The number of activities that start in that interval
    The number of activities that end in that interval
    The number of activities that have any portion of time in that interval

    For questions like this it's always helpful to include a sample of what you want the result to be.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to plot frequency distribution graph with 2 distribution plots
    By escpolina in forum Excel Charting & Pivots
    Replies: 18
    Last Post: 08-16-2017, 10:22 AM
  2. Unbind a frequency distribution
    By AGSwift in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-13-2017, 02:29 PM
  3. [SOLVED] Frequency Distribution Example Question
    By zanshin777 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-27-2015, 04:22 PM
  4. Histogram from frequency distribution?
    By fluffyemu in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-19-2012, 07:02 AM
  5. Frequency distribution and histogram
    By case in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-22-2010, 08:42 PM
  6. Frequency distribution
    By Ms MIS in forum Excel General
    Replies: 1
    Last Post: 04-06-2005, 01:06 PM
  7. [SOLVED] Sorting - Frequency distribution.
    By Stats guru in forum Excel General
    Replies: 2
    Last Post: 04-04-2005, 12:16 AM

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