Please, can anyone explain how i can find the average of a set of data in batch using Spreadsheet.

I have over 200,000 arrays of data that i need to find its average in batches of 30. please is there an easy way i can do that?

Thanks

padeolu: Please, can anyone explain how i can find the average of a set of data in batch using Spreadsheet.

I have over 200,000 arrays of data that i need to find its average in batches of 30. please is there an easy way i can do that?

Thanks

Depending on ur competency in excel, u can programmatically code ur data to get wat u want. I want to assume u r an intermediate user, so lets work around it as I outlined below.

I assumed all ur data (200,000) ar in a single column e.g. column A (A1:A200,000) doubt if excel can reach dt range.

Now on d next column say column B, select B1:B30 (since u want ur average of every 30 count), click on merge to merge d cells (B1:B30).

Now inside d merged cells, type =average((B1:B30)) and press enter. Dt ll produce d average of d 1st 30 data opposite d merged cells.

Now click on d merged cells again (whr u hav ur 1st result), click and hold down d black dot at d down right corner then drag it down until u reach d last value in d opposite column A i.e A200,000.
U ll see all average values for d 30 consecutive data generated. U can then go ahead and format d work ur own way.

Still having issues, u can get back to me here for clarification. Let me kno if u get it.

Thanks a lot. I'll give it a try tonight and get back to you soonest.