Ch4_6 - 1 Section 4.6 Root Finding Using Excel Excel has a...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Next Previous Section 4.6: Root Finding Using Excel 11 ® Excel has a root finding tool called “Goal Seek" ® Located under “Data” tab, and “What-If Analysis” ® Solves for roots of equations ® We can also make use of a "Macro" ® Located under “Developer" tab ® Records multiple key stroke operations ® Streamlines the use of Goal Seek and other Excel operations ® We will demonstrate the use of both Goal Seek and a Macro to find the roots of our example cubic function 1 x 2 x 5 0 x 18 0 x f 2 3 + - - = . . ) ( Section 4.6: Root Finding Using Excel
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Next Previous Section 4.6: Root Finding Using Excel 22 Step 1: make a graph of f(x) vs. x 1 2 5 . 0 18 . 0 ) ( 2 3 + - - = x x x x f This isn't required, but it makes visualizing the roots easier
Background image of page 2
Next Previous Section 4.6: Root Finding Using Excel 33 Step 2: enter formula data and xinitial in cells Enter an initial value for x in a cell Enter the formula for f(x) in other cell
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Next Previous Section 4.6: Root Finding Using Excel 44 Step 3: start Goal Seek, and enter cell locations Select:
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 11

Ch4_6 - 1 Section 4.6 Root Finding Using Excel Excel has a...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online