Engineering 25
EXCEL
Integration
Docsity.com
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Guidelines and tips
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Trapezoidal Integration using Excel: A Step-by-Step Guide, Slides of Calculus for Engineers
A detailed guide on how to perform trapezoidal integration using microsoft excel. It includes screenshots and equations to help students understand the concept and set up the integration strips. The document also provides a matlab code snippet for reference.
Typology: Slides
2012/2013
1 / 7
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download Trapezoidal Integration using Excel: A Step-by-Step Guide and more Slides Calculus for Engineers in PDF only on Docsity!
Engineering 25
EXCEL
Integration
Trapezoidal Integration by Excel
- Integrate using Excel
y e ( x ) (^ x )
x
8 sin 9 ln 7
= +
That is, Find
Show Game Plan on Next Slides
I [^ e ( x ) (^ x )] dx
x
x
x y (^) ∫
= +
8 sin 9 ln 7
Set Up Integration Strips
2 2.5 3 3.5 4
**-
-**
0
1
2
3
4
5
6
7
x
y
Integration Equations
- dA = [Avg Strip Hgt]*[Strip Width]
( )
( )
2
2
= = + −
= ⋅
= −
= +
∑ ∑ n n
N
n
n n
N
n
avg
n n
avg n n
A dA y y x x
dA y dx
dx x x
y y y
MATLAB Code
% Bruce Mayer, PE * 07Dec % ENGR36 * EXCEL integration Prob % file = Excel_Integ_Stem_0912.m % % Set up WhtBd Graphic to show % integration Strips % x = [1.7:.05:4.3] y = 8exp(-0.2x).sin(9x.^0.63) + log(sqrt(7x)) stem(x,y), grid, axis([1.6 4.4 -3.5 7])*