70 likes | 156 Views
Engineering 25. EXCEL Integration. Bruce Mayer, PE Registered Electrical & Mechanical Engineer BMayer@ChabotCollege.edu. Trapezoidal Integration by Excel. Integrate using Excel. That is, Find. Show Game Plan on Next Slides. The Function Plotted. Set Up Integration Strips.
E N D
Engineering 25 EXCELIntegration Bruce Mayer, PE Registered Electrical & Mechanical EngineerBMayer@ChabotCollege.edu
Trapezoidal Integration by Excel • Integrate using Excel • That is, Find • Show Game Plan on Next Slides
Integration Equations • dA = [Avg Strip Hgt]*[Strip Width]
MATLAB Code % Bruce Mayer, PE * 07Dec09 % 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 = 8*exp(-0.2*x).*sin(9*x.^0.63) + log(sqrt(7*x)) stem(x,y), grid, axis([1.6 4.4 -3.5 7])