- Thread starter jdpaul127
- Start date

There are about 230 million to list. Does excel have that range?Excel is the easy part, since you can actually list all sets of 5 integers between 1 and 47.

- Joined
- Jun 18, 2007

- Messages
- 18,820

What would be the sum of those 5 integers?So i guess this is the best way to word this real problem.

Find allsets of 5 integers that average to 23and fall between 1 and 47. Also can this be done in excel.

- Joined
- Apr 12, 2005

- Messages
- 10,169

With some rational and severe removal.There are about 230 million to list. Does excel have that range?

- Joined
- Jan 29, 2005

- Messages
- 8,559

So i guess this is the best way to word this real problem.

Find all sets of 5 integers that average to 23 and fall between 1 and 47. Also can this be done in excel.

If one looks at this expansion at the term \(\displaystyle 2425131x^{115}\) we see the count is 2425131 sets of five integers \(\displaystyle 2\le n\le 46\) that have an average of \(\displaystyle 23\)There are about 230 million to list. Does excel have that range?

And you got this from excel by what method?If one looks at this expansion at the term \(\displaystyle 2425131x^{115}\) we see the count is 2425131 sets of five integers \(\displaystyle 2\le n\le 46\) that have an average of \(\displaystyle 23\)

And you got this from excel how!Mathematica is showing 28447 length 5 partitions of 23x5=115 using the integers lying between 1 and 47 inclusive, allowing repeats.

- Joined
- Jan 29, 2005

- Messages
- 8,559

Actually that is the number of ways that the number 115 can be gotten using integers from 2 to 46.And you got this from excel by what method?

I now think that is a gross overcount. That is, \(\displaystyle 24+45+46=115\) is counted six times.

I do not know how to correct for that.

On another note. There is a style-manual for test contributors. It gives advice on generally accepted ways to word difficult phrases.

Here is an example. \(\displaystyle n\) is an integer

Now hold on, before anyone objects: what does between mean? Is \(\displaystyle 1\) between \(\displaystyle 1~\&~9~?\)

On the other hand, saying \(\displaystyle n\) is an integer