+ Reply to Thread
Results 1 to 2 of 2

Finding Frequency for Data

  1. #1
    Registered User
    Join Date
    03-22-2014
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    8

    Finding Frequency for Data

    Dear Sir,

    Please find attached file.

    I am trying to find the frequency of interval 348.75 to 11.25 using the frequency function.
    I only know how to find from 0 to 11.25 but do not know how to find for 348.75 to 11.25

    regards & Thanks
    Attached Files Attached Files
    Last edited by AppleMonster; 04-06-2014 at 07:51 AM.

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

    Re: Finding Frequency for Data

    A
    B
    C
    D
    E
    F
    G
    1
    DD Direction Count
    2
    128
    N
    1223
    3
    207
    NNE
    548
    4
    249
    NE
    285
    5
    310
    ENE
    289
    6
    263
    E
    249
    7
    252
    ESE
    321
    8
    231
    SE
    486
    9
    237
    SSE
    558
    10
    169
    S
    603
    11
    253
    SSW
    342
    12
    5
    SW
    355
    13
    136
    WSW
    362
    14
    145
    W
    341
    15
    13
    WNW
    654
    16
    10
    NW
    810
    17
    131
    NNW
    1334


    The array formula in G2:G17 is

    =FREQUENCY(MOD(A2:A8761+11.25, 360), 360*{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16}/16)
    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)

Similar Threads

  1. Finding intermediate points for graph plotting.
    By Dapos1993 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-08-2013, 12:37 PM
  2. Finding Frequency of data
    By kavin in forum Excel General
    Replies: 3
    Last Post: 09-10-2012, 10:41 AM
  3. Plotting Data in a Graph
    By RotorBladeGuy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-10-2012, 03:42 AM
  4. Plotting the frequency of a word (no-numerical data)
    By nbn22385 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-03-2007, 07:29 PM
  5. [SOLVED] Plotting Frequency data
    By ffteng in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-25-2006, 12:10 PM

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