1 / 12

ENGR 179 EXCEL for Scientists and Engineers

ENGR 179 EXCEL for Scientists and Engineers. Lecture 2: Fall 2004 Instructor: Sherman Wiggin. What is a derivative? The derivative is among the most useful mathematical entities used in defining engineering problems.  It is usually associated with a function.

dawn-bryan
Download Presentation

ENGR 179 EXCEL for Scientists and Engineers

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ENGR 179EXCELforScientistsandEngineers Lecture 2: Fall 2004 Instructor: Sherman Wiggin

  2. What is a derivative? The derivative is among the most useful mathematical entities used in defining engineering problems.  It is usually associated with a function. A function is a mathematical formula used to define or model behavior.  Derivatives also have a geometrical interpretation.  They represent the slope or the tangent at the point.

  3. Making A Derivative Workbook Typing in the Headers Let’s add a little more color to the sheet

  4. Building the Body of the Workbook • Making a series of numbers • Type in 2 to 3 of a set of numbers in this case 0, 0.1, 0.2. • Then select all three cells and drag. The numbers will automatically increment by 0.1

  5. Mathematical Entry Format Now let’s insert the function. Next the analytical solution

  6. Mathematical Entry Format • Next we need to put in the formulas for forward backward and central methods • After doing this we will drag the formulas down the entire length of the time column

  7. Graphing Results • Now the results can be graphed to compare the accuracy of a given method • We will select the data we want and then after creating the graph we can go back and alter one data series to create a combined chart. In this case line and bar graphs.

  8. What is an Integral • Integrals can be considered as the inverse of the derivative. It is also a summation (addition) in the limit.  • It easiest shown to be equal to the area under the curve of a function.

  9. Integral Workbook Using Numerical Methods

  10. Worksheet Set Up • For this function the Left Rectangular Integration overestimates the value. • The Right Rectangular Integration underestimates the value. • The Trapezoidal method looks much like the rectangular method with the exception that only half of the first and last data points are used. This small modification can often produce large increases in accuracy.

  11. The Inclined Plane Problem • Normal Force • Force Down the Plane • Friction Force

  12. Incline Plane Problem • Motion is impending when the force down the plane is equal to the maximum static friction force. • By graphing these values this point can be determined by the intersection of the two lines.

More Related