Quiz#3 NOT(Rubik's Cube)

Taurean,
Thanks for opening my eyes!
Fazza's solution is really elegant.
I 'thought' it was a 'series' solution with n expressions. And never even checked it out.
Now, I tried (honest) but could not figure it out. (Algebra is not a very strong point for me!)

I would be delighted if Fazza can throw some light. Thanks.

Array solution: would multiply each integer upto (and including) the given number X to itself. Sum all and then multiply with 6.

Fazza's solution: X*(X+1)*(2X+1) Can't wrap my brain around it.

What would be the solution if there was no multiplication with 6 at the end?
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Hi drsarao,

Here's one derivation. You will see that the actual series is for calculating SUM of SQUARES on one side of the cube.

The sum of the squares of the first n natural numbers is in its various forms:
sumSquaresNatNumbersFormulae.gif


So when we had to calculate it for all 6 sides the divisor 6 disappeared.
 
That is absolutely brilliant. I am with drsarao that I believed this could only be accomplished with some form of series expression and didn't realize that fazza's initial response wasn't giving that.

Thank you for the enlightenment.
 
Hi drsarao,

Here's one derivation. You will see that the actual series is for calculating SUM of SQUARES on one side of the cube.

The sum of the squares of the first n natural numbers is in its various forms:
sumSquaresNatNumbersFormulae.gif


So when we had to calculate it for all 6 sides the divisor 6 disappeared.

Plain Nirvana!

Thanks Srivallabha and Fazza.

So the original equation would be: ( X*(X+1)*(2X+1))/6
(multiplying by 6 in fact simplified the equation!)

PS
I honestly tried to follow the explanations in Ken Ward's Mathematics Pages. I have bookmarked it for future revisit!
 

Forum statistics

Threads
1,223,750
Messages
6,174,290
Members
452,554
Latest member
Louis1225

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top