Sum of a series: Difference between revisions
Content added Content deleted
m (→{{header|Phix}}: added syntax colouring the hard way) |
(→{{header|Excel }}: Added an Excel LAMBDA version) |
||
Line 809: | Line 809: | ||
printf( 1, "%.15f\n", sum( 1, 1000 ) )</lang> |
printf( 1, "%.15f\n", sum( 1, 1000 ) )</lang> |
||
=={{header|Excel}}== |
|||
===LAMBDA=== |
|||
Binding the names '''sumOfSeries''', and '''inverseSquare''' to the following lambda expressions in the Name Manager of the Excel WorkBook: |
|||
(See [https://www.microsoft.com/en-us/research/blog/lambda-the-ultimatae-excel-worksheet-function/ LAMBDA: The ultimate Excel worksheet function]) |
|||
Excel automatically lifts a function over a scalar to a function over an array: |
|||
{{Works with|Office 365 betas 2021}} |
|||
<lang lisp>sumOfSeries |
|||
=LAMBDA(f, |
|||
LAMBDA(n, |
|||
SUM( |
|||
f(SEQUENCE(n, 1, 1, 1)) |
|||
) |
|||
) |
|||
) |
|||
inverseSquare |
|||
=LAMBDA(n, |
|||
1 / (n ^ 2) |
|||
)</lang> |
|||
{{Out}} |
|||
{| class="wikitable" |
|||
|- |
|||
|||style="text-align:right; font-family:serif; font-style:italic; font-size:120%;"|fx |
|||
! colspan="2" style="text-align:left; vertical-align: bottom; font-family:Arial, Helvetica, sans-serif !important;"|=sumOfSeries(inverseSquare)(A2) |
|||
|- style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff;" |
|||
| |
|||
| A |
|||
| B |
|||
|- |
|||
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 1 |
|||
| style="font-weight:bold" | N terms |
|||
| style="font-weight:bold" | Sum of inverse square series |
|||
|- |
|||
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 2 |
|||
| style="text-align:right; font-weight:bold" | 1 |
|||
| style="text-align:right; background-color:#cbcefb" | 1 |
|||
|- |
|||
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 3 |
|||
| style="text-align:right; font-weight:bold" | 10 |
|||
| style="text-align:right" | 1.5497677311665408 |
|||
|- |
|||
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 4 |
|||
| style="text-align:right; font-weight:bold" | 100 |
|||
| style="text-align:right" | 1.63498390018489 |
|||
|- |
|||
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 5 |
|||
| style="text-align:right; font-weight:bold" | 1000 |
|||
| style="text-align:right" | 1.64393456668156 |
|||
|} |
|||
=={{header|Ezhil}}== |
=={{header|Ezhil}}== |