Scribd
Upload
2 views2 pages

Trapezoidal Integration in Excel

This document describes approximating an integral using the left and right Riemann sum rules with increasing numbers of subintervals. With 5 subintervals, the left sum (L) is 13.0777 and the right sum (R) is 14.8777. With 10 subintervals, L is 13.54439, R is 14.44439, and the midpoint rule sum (M) is 14.00280. With 20 subintervals, L and R converge closer to the exact value as the trapezoidal rule sum (T) reaches 13.99439 and the Simpson's rule sum (S) reaches 13.999997.

Uploaded by

Yusi Sulastri
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
2 views2 pages

Trapezoidal Integration in Excel

This document describes approximating an integral using the left and right Riemann sum rules with increasing numbers of subintervals. With 5 subintervals, the left sum (L) is 13.0777 and the right sum (R) is 14.8777. With 10 subintervals, L is 13.54439, R is 14.44439, and the midpoint rule sum (M) is 14.00280. With 20 subintervals, L and R converge closer to the exact value as the trapezoidal rule sum (T) reaches 13.99439 and the Simpson's rule sum (S) reaches 13.999997.

Uploaded by

Yusi Sulastri
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

Sheet1

Approximating an Integral [Link]


with n = 5 subintervals
Enter =f(x) in cell B6 & fill down cells B7 : B16.

x f(x) a= 1 (Enter a)
1 3.0000 b= 4 (Enter b)
1.3 3.4205
1.6 3.7947 h= 0.6
1.9 4.1352
2.2 4.4497
2.5 4.7434 L= 13.0777
2.8 5.0200 R= 14.8777
3.1 5.2820 M= 14.0111
3.4 5.5317
3.7 5.7706 T = 13.9777
4 6.0000 S = 13.99995 (with 10 subintervals)

Page 1
Approximating an Integral [Link]
with n = 10 subintervals
Enter =f(x) in cell B6 & fill down cells B7 : B26.

x f(x) a= 1 (Enter a)
1 3.0000 b= 4 (Enter b)
1.15 3.2171
1.3 3.4205 h= 0.3
1.45 3.6125
1.6 3.7947
1.75 3.9686 L= 13.54439
1.9 4.1352 R= 14.44439
2.05 4.2953 M= 14.00280
2.2 4.4497
2.35 4.5989 T= 13.99439
2.5 4.7434 S= 13.999997 (with 20 subintervals)
2.65 4.8836
2.8 5.0200
2.95 5.1527
3.1 5.2820
3.25 5.4083
3.4 5.5317
3.55 5.6524
3.7 5.7706
3.85 5.8864
4 6.0000

You might also like