Basic Statistics Help Please

[binar]

Fellow Forum Members,
I'm the kind of person that has always pronounced the word "statistics" as "sadistics". Nevertheless, I need to figure something out that invovles statistics and I'm wondering if Excel 2003 is the right tool. My objective is to figure out the total quantity of combinations the number range 1 through 44 has when it's combined with a second number range that also has number values of 1 through 44. I don't know what the statisical forumla is, but does Excel 2003 provide the function needed to figure this out? Better yet, can it generate a list of all the number combinations existing between two number sets made up of values 1 through 44 combined. Any help will be greatly appreciated. Thanks.

[Excelenator]

the "formula" for the number of combinations of two sets of 44 items

44*44 = 1936

As for listing out the combinations I'm not sure.

[Dav]

Ok you have the answer that if you are picking 1 from each range the answer is 1936

If you put =INT((ROW(a1)-1)/44)+1 in cell A1 and =MOD(ROW(a1)-1,44)+1 in cell b1 then select both and copy down to row 1936, they are all your possible combinations

Regards

Dav

[Excelenator]

Damn Dav that's AWESOME!!!

[Dav]

Excelenator

Not really, if i knew what i was doing, with macros like you do (you provided me with one yesterday, thanks again) it would be quicker doing 2 nested do loops, something along the lines of:

range("a1").select

for i = 1 to 44
for j = 1 to 44
Selection.Offset(x, 2).Value = i
Selection.Offset(x, 3).Value = j
x = x + 1
next j
next i


As i said my macro writing is not good, but i finally get on a course in a month so it should improve. i bet you could have changed this into the solution quicker than i wrote the formula. But as I said before I am ok with formulas but rubbish with macros

Regards

Dav