linear adjustment in excel
 

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

linear adjustment in excel
 

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 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

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,

linear adjustment in excel
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


wrote in message
s.com...

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,