Answer me. Use Microsoft Excel to investigate the following function: f(x) = ln(
ID: 3148106 • Letter: A
Question
Answer me.
Use Microsoft Excel to investigate the following function: f(x) = ln(x) Note that this function is undefined for values of x less than or equal to 0. Use the Newton-Raphson Method to find the root of the function. The analytical result is x = 1. The first derivative of the function is f'(x) =1/x Do not incorporate the first order numerical method for computing the derivative that was demonstrated in the second half of the notes for this topic. Use your spreadsheet to investigate various choices for the initial guess. Which of the following initial guesses result in computational errors? As you answer the question, use the graphic illustration in the notes to help visualize why errors might occur. Select one or more: a. 3 b. 2.75 c. 0.25 d. 2
Explanation / Answer
(a) x = 3
Can't calculate further because ln doesn't take negativ
(b) x = 2.75
Can't calculate further because ln doesn't take negative
(c) x = 0.25
(d) = x = 2
3 xn f(xn) f'(xn) f(xn)/f'(xn) xn-f(xn)/f'(xn) error% Iteration no. x ln(x) 1/x f/f' x-f/f' 1 3.000 1.099 0.333 3.296 -0.296 109.86% 2 -0.296 #NUM! -3.380 #NUM! #NUM! #NUM!Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.