View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
[email protected] simonwdavis@gmail.com is offline
external usenet poster
 
Posts: 2
Default linear adjustment in excel


hmm. i think what i want is to stretch the data based on a few anchor
points (let's say the start, middle, and end of each data column),
such that every column is the same length.

The actual data is about 30 rows long, and represents data sampled
from different places (in the brain), so i don't know if i can insert
median data in the gaps.


On Aug 24, 1:16 pm, dlw wrote:
I would just calculate the average (or median?) of the column and plug that
into the gaps. Or do you want some kind of automatic thing?

" wrote:

I am trying to take a set of columns of numbers and adjust them so
they are all the same length.


I.e., i have data that looks like


1 0.2454
2 0.2423 0.2544
3 0.3124 0.4234 0.5436
4 0.5343 0.2423 0.5432
5 0.2532 0.4531 0.6542
6 0.2342 0.5432 0.6344
7 0.5434 0.5234
8 0.4532


i'd like to do alinearadjustmenton the data BY COLUMN, such that
everyone is the same number of data points. Smoothing isn't really
what i want (i think), since that would distort the absolute values of
the data.


any ideas?


thanks,