Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Adjustment - Help | Excel Worksheet Functions | |||
automatic adjustment | Excel Discussion (Misc queries) | |||
Inflation Adjustment | Excel Discussion (Misc queries) | |||
Copy without Adjustment | Excel Discussion (Misc queries) | |||
Excel should allow independent zoom adjustment of split panes | Excel Discussion (Misc queries) |