Question: Write a VBA sub procedure to use Newtons method to find a root of a cubic equation. Note, make your program as user friendly as

Write a VBA sub procedure to use Newtons method to find a root of a cubic equation. Note, make your program as user friendly as possible.

Use your program to find a root of f(x) = x^3 - 4x^2 + x 1 using a convergence criteria of 10^-8

In excel :)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Write a VBA sub procedure to use Newton's method to find a root of a cubic equation. Use your program to find a root of f(x) = x^3-4x^2+x-1 using a convergence criteria of 10^(-8)

Q:

In this problem, you will use Bisection method to find a root of a polynomial. Write a C program to find a root of a cubic polynomial p(x)=a x^3 + b x^2 +c x +d=0 in the interval [-50,50] if it...

Q:

>>>, please solve The following cost data pertain to the operations of Montgomery Department Stores, Inc., forthe month of July. Corporate legal office salaries 3 62.600 Apparel Department cost of...

Q:

Please use Python Write a program that finds the average of a series of numbers entered by the user. As in the previous problem, the program will first ask the user how many numbers there are. Note:...

Q:

Activity #1: Root Finding You are to write a program that will find a root of a cubic polynomial. A cubic polynomial is of the form: f(x) = Ax3 + Bx2 + Cx + D Background. All polynomials have some...

Q:

1. Create a User defined VBA Function that calculates the rate of diffusion (diffusivity) of te. Carbon in Iron (Fe). Make sure that the function is in a module. See page 2 for equation and values 2....

Q:

Show a picture of the completion of a successful run that does not usethe test value from the Example Output section 2. Declare a variable in your main function of type int, called S. 3. Get user...

Q:

1. Find the root of f(x)=x-2e** 1. Write a python program to perform bisection. 1. Use this program with a = 0 and b = 0. 2. Find the root of f(x)=x-2e** 1. Write a python program to perform the...

Q:

Root Finding To be done as a team As a team, you are to write a program that will find a root of a cubic polynomial. A cubic polynomial is of the form: A root of the polynomial is a value, x, such...

Q:

COMPLETE ALL THE QUESTIONS 1) Make a version of X.32[7] where the element type is a template argument. [10] ( 2.5) Given an Itor class like the one in X.32[8], consider how to provide iterators for...

Q:

(a) Assuming that each cubic centimeter of water has a mass of exactly 1 g, find the mass of 1.39 cubic meter of water. (b) Suppose that it takes 11.2 hours to drain a container of 61.0 m of water....

Q:

At August 31, 2015, the end of the current fiscal year, Beady Engineering Inc. had the following account balances: Instructions Prepare the balance sheet presentation for Beady Engineering Inc.s...

Q:

31. Explain the accounting for contract modifications.

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

In an Excel Pivot Table, how is a Fact/Measure Column repeated?

Q:

In Gender Pay Equity Studies in the Federal Service, how can comparisons be ensured across Job of Comparable Worth?

Q:

In the Federal Evaluation System (FES), what standards are used in the Job Evaluation Process?