linear adjustment in excel

  • Thread starter Thread starter simonwdavis
  • Start date Start date
S

simonwdavis

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 a linear adjustment on 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,
simon
 
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?
 
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 what basis do you want to interpolate (or extrapolate?) your data? They
do not increase linearly, they are not proportional to row. If it's just to
"look nice", are you willing to compromise the data for that purpose?

- Jon
 
Back
Top