Question: Please write this out in EXCEL please I'm so lost and don't even know how to approach this 1. (20 pt) Implement the false position

Please write this out in EXCEL please I'm so lost and don'tPlease write this out in EXCEL please I'm so lost and don't even know how to approach this

1. (20 pt) Implement the false position root finding algorithms using EXCEL. Program a worksheet that can do the iterations based on the false position method. Your worksheet should show the results as well as the relative percent errors of iterations. Test your worksheets using any equation with known solutions. 2. (20 pt) Consider a uniform beam subjected to a linearly increasing distributed load (see figure). The equation for the resulting deflection is: y = wo (-x5 + 2Lx3 L4x) 120 E IL Use the EXCEL program developed in Part (1) to determine the point of maximum deflection (the value of x where dy/dx = 0), and to determine the maximum deflection. Use the following parameter values in your computation: L = 600 cm, E = 50,000 kN/cm, I = 30,000 cm", and wo = 2.5 kN/cm. 1. (20 pt) Implement the false position root finding algorithms using EXCEL. Program a worksheet that can do the iterations based on the false position method. Your worksheet should show the results as well as the relative percent errors of iterations. Test your worksheets using any equation with known solutions. 2. (20 pt) Consider a uniform beam subjected to a linearly increasing distributed load (see figure). The equation for the resulting deflection is: y = wo (-x5 + 2Lx3 L4x) 120 E IL Use the EXCEL program developed in Part (1) to determine the point of maximum deflection (the value of x where dy/dx = 0), and to determine the maximum deflection. Use the following parameter values in your computation: L = 600 cm, E = 50,000 kN/cm, I = 30,000 cm", and wo = 2.5 kN/cm

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!