Create a vba function that will return the root of function

Assignment Help Civil Engineering
Reference no: EM13304217

Create a VBA function that will return the root of the function e-x -x = 0 using the Newton-Raphson method. The input parameter for the function should be the initial guess for the root. Turn in your code for the VBA function.

Reference no: EM13304217

Questions Cloud

What is the profit margin : Firm has a retention ratio of 45 percent and a sustainable growth rate of 6.2 percent. The capital intensity ratio is 1.2 and the debt-equity ratio is 0.64. What is the profit margin?
Explain functional areas of operations : What are integrated information systems? Describe the difference between functional areas of operations and business processes. Give examples of a business process.
Making organization-wide decisions and establishing the plan : Which of the following types of managers is responsible for making organization-wide decisions and establishing the plans and goals that affect the entire organization>
Calculate the change in the spheres internal energy in kj : During the process 40 kJ of heat is transferred from the sphere, while the sphere receives energy in the form of work equal to 20kcal. calculate the change in the sphere's internal energy in kJ.
Create a vba function that will return the root of function : Create a VBA function that will return the root of the function e-x -x = 0 using the Newton-Raphson method. The input parameter for the function should be the initial guess for the root. Turn in your code for the VBA function.
Which of the following statements is most incorrect : A 10-year corporate bond has an annual coupon rate of 9%. The bond is currently selling at premium. Which of the following statements is most incorrect?
What is the cost of equity based on the dcf approach : Assume that you are a consultant to Morton Inc., and you have been provided with the following data: D1 = $1.00; P0 = $25.00; and g = 6% (constant). What is the cost of equity based on the DCF approach?
Major ecological imbalance on earth : Major ecological imbalance on Earth is between the human species and the rest of Earth''s biota - What are two specific actions we could do to achieve a balance (for example, recycling)? Here is the critical part:
What might be reasonable costs of capital for average-risk : Suppose a firm estimates its cost of capital for the coming year to be 10 percent. What might be reasonable costs of capital for average-risk, high-risk, and low-risk projects?

Reviews

Write a Review

Civil Engineering Questions & Answers

  Di-atomic ideal gas

Air can be assumed as a di-atomic ideal gas. Find the final temperature and the amount of work ( in kW) required for air compression at a rate of 100 mol/s , from an initial condition of 1 bar an 25 C to 10 bar; for the following ways:

  How to determine the diameter of a drilled shaft pile

Using 1630.56 kN as the ultimate capacity determine the diameter of a drilled shaft pile that would have the same ultimate capacity and depth embedment (11.5 m) using the FHWA method. Neglect shaft resistance. Use a F.S. of 2

  Tension in the horizontal cable

The center of gravity of the crane is 10 ft from the pin, and the crane weighs 200 lb. What is the tension in the horizontal cable.

  Calculate the partial pressure exerted by each gas

A 30-liter volume of gas at 25 degrees C contains 12 g of methane (CH4), 1 g of nitrogen (N2), and 15 g of carbon dioxide (CO2). Calculate (a) the moles of each gas present, (b) the partial pressure exerted by each gas, and (c) the total pressure ..

  What will be the total vehicle delay

Assuming D/D/1 queuing, what will be the total vehicle delay?

  Determine the ntu values for each sampling port depth

The packed tower was 30 cm in diameter with sampling ports located at packing depths of 0,2,4,6,8,10, and 12 meters. The loading of water to the tower was 0.039 m^3/(m^2/s), and the temperature of groundwater was 10 degrees celcius.

  Supervisors technicians and skiled workers in dangerous work

As a project manager on site where work for 3 km long tunnel has been undertaken the site is remote and takes about 2 days to travel to nearest town supervisors technicians and skiled workers in dangerous work.

  What is the 2-4-6-trichlorophenol concentration in ppm

A 500 L (132 gal) tank contains 255 mg/L 2,4,6-trichlorophenol dissolved in trichloroethylene (TCE). What is the 2,4,6-trichlorophenol concentration in ppm Assume the temperature of the system is 20 degrees C.

  Determine the depth that will result upstream during design

The design discharge is 9.5 m^3/sec and the inlet will be submerged but not the outlet. Determine the depth that will result upstream (above the invert) during the design flood event.

  Determine what was the major principal stress at failure

A consolidated-drained triaxial test on a normally consolidated clay yielded a friction angle of 28°. If the all-round confining pressure during the test was 140 kN/m2, what was the major principal stress at failure.

  Convert all quantities to si units then convert it to mph

Assume the plane is flying at an altitude of 32,810 ft (10 km), where the temperature is -8 C and the pressure is 250 mb. The Pitot-static tube measures a piezometric pressure difference corresponding to 1.206 psi. What is the airspeed in both m/s..

  What is the net upward force exerted

the pressure inside a commercial airliner is maintained at 1.00 ATM. what is the net upward force exerted on a (1.0 m)(200 cm) cabin door if the outside pressure is 0.30 ATM?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd