dslreports logo
 
    All Forums Hot Topics Gallery
spc
Search similar:


uniqs
376

aurgathor
join:2002-12-01
Lynnwood, WA

aurgathor

Member

[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

JohnInSJ
Premium Member
join:2003-09-22
Aptos, CA

JohnInSJ

Premium Member

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.