Results 1 to 5 of 5

Frequency distribution

Threaded View

  1. #1
    Registered User
    Join Date
    08-28-2017
    Location
    Poland
    MS-Off Ver
    2016
    Posts
    2

    Frequency distribution

    Hi

    I have a worksheet with data (ACTIVITY, START_DATE, END_DATE). I will have 10 000 records. I need to do a table with time intervals (00:01-00:15, ... , 23:45-23:59) with frequency of my data. For example: 00:01-00:15 - 5 activities , 00:16-00:30 - 3 activities etc. Activities may by long and include in several time intervals.

    I attach worksheet and please help.
    Attached Files Attached Files

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. 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