dslreports logo
site
 
    All Forums Hot Topics Gallery
spc

spacer




how-to block ads


Search Topic:
uniqs
329
share rss forum feed


aurgathor

join:2002-12-01
Lynnwood, WA
kudos:1
Reviews:
·Frontier Communi..

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


JohnInSJ
Premium
join:2003-09-22
Aptos, CA
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