Secant Activity Workshop, Exercises of Computer Applications

It talks about how secant method works on polynomial equations

Typology: Exercises

2021/2022

Uploaded on 05/15/2023

adrian-lyle-ricaza
adrian-lyle-ricaza 🇵🇭

1 document

1 / 3

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Names: Ricaza, Adrian Lyle; Uy, Paulxander
Course and Section: CHE 36 A
September 14, 2022
Secant Method
Step by Step Program Algorithm
1. Estimate the roots of the equation:
Assume the constant values:
2. Set the table as follows:
3. Set initial guesses for the x values:
pf3

Partial preview of the text

Download Secant Activity Workshop and more Exercises Computer Applications in PDF only on Docsity!

Names: Ricaza, Adrian Lyle; Uy, Paulxander Course and Section: CHE 36 A September 14, 2022

Secant Method

Step by Step Program Algorithm

  1. Estimate the roots of the equation: Assume the constant values:
  2. Set the table as follows:
  3. Set initial guesses for the x values:
  1. Set the functions for the functions of x 0 and x 1 =($D$10M7^4)+($D$11M7^3)+($D$12M7^2)+($D$13M7)+$D$14 (for x 0 ) =($D$10N7^4)+($D$11N7^3)+($D$12N7^2)+($D$13N7)+$D$14 (for x 1 )
  2. Set the function for the xn =N7-P7*((N7-M7)/(P7-O7)) (for xnew)
  3. Set x 0 = x 1 and x 1 = xn
  4. Iterate till the percent error is less than 0.01% =IF(ROUND((M15-N15)/M15,4)=0,"STOP","")