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'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
Get step-by-step solutions from verified subject matter experts
