MathGroup Archive 2011

[Date Index] [Thread Index] [Author Index]

Search the Archive

create/insert information for missing data points

  • To: mathgroup at
  • Subject: [mg119880] create/insert information for missing data points
  • From: lillydogy <lillydogy at>
  • Date: Mon, 27 Jun 2011 07:32:55 -0400 (EDT)

how do I create and insert information for missing data? 

have an experiment running in military time, and sometimes it has missing data points, sometimes three missing data points in a row or more.
I want to take the average of the two adjacent (joining) data points and insert for the missing point/s. for example, these would be the missing points inserted for the example below. {305,38.5},{311,40.5},{312,40.5},{313,40.5}. 

before :( 

after :) 

btw, these are millitary times, so it goes 959,1000....1059,1100... etc because there are only 60 minutes in an hour. there would be no such thing as 1392, because 1:92pm does not exist.

this is another example of how the data looks

  • Prev by Date: Re: what's in a name? (legal and conventional constructions of identifiers)
  • Next by Date: Stylesheet questions
  • Previous by thread: Re: NSolve...
  • Next by thread: Re: create/insert information for missing data points