This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

i want to do average of large set of data. For example 1,1,1,1,2,2,2,2,2,3,3,4,4,4,4,5,5,6,7,7,7,7,7,7

i need average of 1,1,1,1 and than 2,2,2,2,2 and than 33 and than 4444 and than 55 and than 6 and than 777777. is it possible ? can any one help me in this ?

=IF(MOD(ROW(),20)=1,AVERAGE(OFFSET(K1,,,20)),"") works but only same number of bin every time. here, bin is variable ...looking answer from some expert...

average.xlsx

i need average of 1,1,1,1 and than 2,2,2,2,2 and than 33 and than 4444 and than 55 and than 6 and than 777777. is it possible ? can any one help me in this ?

=IF(MOD(ROW(),20)=1,AVERAG

average.xlsx

Do more with

EXPERT OFFICE^{®} is a registered trademark of EXPERTS EXCHANGE^{®}

If so, in column H:

=ROUND(F1,1)

and in column I

=IF(H1=H2,"",AVERAGEIF($H$

Copy both down as far as required. The Average will show on the last entry for each value in F.

Thanks

Rob H

average--2-.xlsx

Thanks

Rob H

I have recommended this question be closed as follows:

Split:

-- Rob Henson (https:#a41833580)

-- Patrick Matthews (https:#a41832619)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

frankhelk

Experts-Exchange Cleanup Volunteer

## Premium Content

You need an Expert Office subscription to comment.Start Free Trial