What is the formula for calculating the sum of squares?
The company for calculating the sum of squares is n(n+ 1)(2n+ 1)/6. Sum of squares is a common calculation company, which is used to solve the sum of squares of several continuous natural numbers. It is often used to solve mathematical problems about square numbers, and the results obtained are also called "pyramid number" or "pyramid number", also known as square number sequence.
Second, how to calculate the sum of squares with Excel
1, through a simple example, understand how to use Excel. First, according to the table below, in the box in the "D2" column, enter an equal sign, which represents the symbol of the input function.
2. Then, in box D2, continue the operation after the equal sign, enter the English word "sumsq", and then the system will pop up relevant functions right below the English. At this time, double-click and click.
When everything is ready, it is almost finished. At this time, as long as you select the column sum with the mouse, the following phenomena will appear in the table. In the box of D2, the word "= sumsq (A2: C2" will pop up.
4. After the words "= sumsq (A2: C2" appear, press Enter, and the system will automatically calculate the result and display it in the D2 frame. If you want to calculate the sum of squares of the following lines, just hold down D2 and pull it down. In addition, directly enter "sumsq (2 2,3)" in the box to get the result.
Here, let's first introduce what is the formula for calculating the sum of squares and how to calculate the sum of squares with Excel. You got it? The calculation of the sum of squares is still used by many companies and can be realized by multiple softwares.