+ Reply to Thread
Results 1 to 3 of 3

Measure how far away the last missing value - relative frequency question

  1. #1
    Registered User
    Join Date
    10-04-2013
    Location
    Szentendre, Hungary
    MS-Off Ver
    Excel 2003
    Posts
    78

    Measure how far away the last missing value - relative frequency question

    Hi guys,

    I'm examining and mulling over the relative frequency. And I have absolutely no clue, how to solve the following thing.
    For example, I have a sequence with values 1, 2, 3, and 4.
    I would like to measure how far away the last, missing 4th value after any 3 values occured in the sequence. Of course 3 values can be repeating itself, so the measured distance can be varied.

    So, for example, this is is the sequence:
    2 1 2 3 1 4 1 3

    1. After the first 4 values it is clear that the value '4' is the missing value, and the distance is 4 cells.
    2. And then examinig the next value, still the '4' is missing, so at the next cell, the missing value still the '4', and the distance is now 5 cells.
    4. And then the '4' occurs, so examining which is the last one missing value, and that is the value '2', the distance is 3 cells.
    And so on... The missing value and the distance are change as we moving to the next and the next values in the sequence.

    I made an explanatory JPG about this thing and also I attached the excel file.

    Can somebody help me about this one?

    Thank you in advance!

    relarivefreq_missing_value_question.jpg
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-09-2013
    Location
    Oshawa, Canada
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Measure how far away the last missing value - relative frequency question

    I'm not sure what result you are really after but hopefully my attachment helps

    It identifies with yes or no if a series of four numbers has 1,2,3, and/or 4 within it.
    For example it quickly identifies that every series contains a 2.
    Attached Files Attached Files
    If anyone has helped - Add Reputation

  3. #3
    Registered User
    Join Date
    10-04-2013
    Location
    Szentendre, Hungary
    MS-Off Ver
    Excel 2003
    Posts
    78

    Re: Measure how far away the last missing value - relative frequency question

    Hi Thom7890!

    No, it isn't quite like I was seeking after, but I've got help in another excel forum. Because I saw after a short time, nobody's interested in my problem.
    But it is really good you posted an answer, because now I reminded that I should post the solution too.

    So this is the solution, which has been posted for me on another forum:


+ 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. Help with relative frequency percentages
    By disco75 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-03-2014, 11:08 AM
  2. How to graph a Relative frequency distribution???
    By globulous in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-29-2007, 05:25 AM
  3. [SOLVED] Calculate relative frequency?
    By mlh0654 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-11-2006, 11:15 AM
  4. [SOLVED] relative-frequency histogram
    By eschorer in forum Excel General
    Replies: 0
    Last Post: 03-19-2006, 09:15 PM
  5. histograms - frequency and relative frequency?
    By confusedstudent in forum Excel General
    Replies: 2
    Last Post: 02-08-2006, 04:25 AM
  6. [SOLVED] Missing floating Macro Toolbar. Can't change to relative referenc
    By GLovell in forum Excel General
    Replies: 1
    Last Post: 06-16-2005, 07:05 PM
  7. Replies: 1
    Last Post: 02-28-2005, 12:06 AM

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