how-to block ads
|
|
Uniqs:
232 |
Share Topic
 |
 |
|
|
|
| [Excel] periodic statistics I have some .csv data, containing 10 colums and lots of rows whose number can vary from 10k to several hundred k.
What I would like to do is get average, median, and stdev for every, say, 5000 rows, and append it to the end, and save the data as .xls.
I just did it by hand -- doable, but it's rather tedious and time consuming. How can I do this automatically?
TIA
--
Wacky Races 2012! | | |
|
 JohnInSJPremium
join:2003-09-22
San Jose, CA
 ·PHONE POWER
 ·Comcast
| said by aurgathor:I have some .csv data, containing 10 colums and lots of rows whose number can vary from 10k to several hundred k.
What I would like to do is get average, median, and stdev for every, say, 5000 rows, and append it to the end, and save the data as .xls.
I just did it by hand -- doable, but it's rather tedious and time consuming. How can I do this automatically?
TIA
with a vbscript or macro (same thing) - record macro next time you do it by hand, and that will give you a great start on a script.
--
My place : »www.schettino.us | |
|
