Remember Me?

#1
 wendyrose1034 Posts: n/a
How do I group multiple data entries in sub-groups

I have almost 7000 data points that I need to group in sub-groups of 13
before analysing the data to measure variance. Is there a formula or macro
that I can write, or do I have to group them manually? The data points have
to be grouped in 13 in the order they appear.
#2
 bj Posts: n/a

When you say group,
do you mean you want
to average them?
to do initial statistics on them etc.
do you wish to change from a 1x4000 to a 13x310 file

to change from a 1x4000 to a 13xYYY file
if your data is in column A and starts in row1

in C1 enter
=indirect("A"&((row()-1)*13-(column()-2)))
and copy to all cells between C1 and O310
(Note the exact lowest row depends on how many data points you actually have)
You will now have the data sorted into rows with 13 data points each

There are other things you can do depending on what you want to accomplish.

"wendyrose1034" wrote:

I have almost 7000 data points that I need to group in sub-groups of 13
before analysing the data to measure variance. Is there a formula or macro
that I can write, or do I have to group them manually? The data points have
to be grouped in 13 in the order they appear.

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post WIDBIS Excel Discussion (Misc queries) 1 June 29th 05 12:53 AM chris_rip Excel Discussion (Misc queries) 3 June 22nd 05 04:27 AM PAR Excel Worksheet Functions 1 June 10th 05 06:28 AM Ron Vetter Excel Discussion (Misc queries) 1 April 29th 05 08:02 PM GNAC SID Excel Discussion (Misc queries) 2 February 7th 05 05:09 PM

All times are GMT +1. The time now is 09:27 PM.