1 / 10

Workshop 2: Math Functions

Learn built-in mathematical functions & operator precedence in Excel, including examples on balloon behavior and solving equations. Enhance Excel skills today!

alarson
Download Presentation

Workshop 2: Math Functions

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. Workshop 2: Math Functions

  2. Built-in mathematical functions Operators Precedence • Math operators: +, -, *, / have different execution priorities • What would you expect from the following calculation: • = 1 + 2 – 3 * 4 / 8 ? • Excel assigns priority to operators as follows: • 1. (, ) highest priority • 2. * , / • 3. +, - lowest priority • Mathematics expressions are evaluated using these priorities • Example: 1 + 2 – 3 * 4 / 8 = 1.5 --> using priority • 1 + 2 – 3 * 4 / 8 = 0 -- > left to right

  3. Useful mathematical functions Balloon Behavior • The height and velocity of a hot-air balloon are described as: • h(t) = - 0.12t4 + 12t3 – 380t2 + 4100t + 220 • v(t) = - 0.48t3 + 36t2 - 760t + 4100 • where t is a number of hour after launch, h(t) is in meter, v(t) is in m/hr • Create a table showing height (m) and velocity (m/s) of balloon in a period of • 0 – 8 Hrs.

  4. Useful mathematical functions Balloon Behavior • When will the balloon reach its highest altitude? • This type of question usually arises, but how can we efficiently answer that? • Excel provide “Goal seek ” tool to help us • Goto main menu: Tool  Goal seek…

  5. Useful mathematical functions Balloon Behavior • At an altitude of 10000 m, how fast is the balloon climbing ? and • how long does it take to reach that altitude?

  6. Built-in mathematical functions Logarithmic & exponential functions

  7. Built-in mathematical functions Logarithmic & exponential functions

  8. Built-in mathematical functions Trigonometry functions Also available: = RADIANS(degree)  to convert deg.  rad. = DEGREES(radian)  to convert rad.  deg. = PI( )  Pi constant

  9. Built-in mathematical functions Matrix calculations Important: - The result appears on an active cell only - Use CTRL-SHIFT <ENTER> to copy array formula

  10. Introduction to Microsoft Excel Solving linear equations [A][x] = [B] [x] = [A]-1[B] 1 -2 0 3 2 -1 2 -2 4 -1 0.5 -1 A = B =

More Related