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