Bisection/Regula Falsi/Secant methods in excel

f(x)= (xb*EXP(A-(B/T+C)))+(xt*EXP(A-(B/T+C)))-Pt
a (in K) 353.15
b (in K) 383.15
x1= 0.4
x2= 0.6
Pt (in KPa)= 101.325
Check True
Anitoine Constants A B C
B(1) 14.1603 2948.78 -44.5633
T(2) 14.2515 3242.38 -47.1806
T-K
P-KPa

Iteration a f(a) b f(b)
1 353.15 -38.1629142275649 383.15 51.622781205
2 368.15 -1.02403009098319 383.15 51.622781205
3 368.15 -1.02403009098319 375.65 23.120052579
4 368.15 -1.02403009098319 371.9 10.534323681
5 368.15 -1.02403009098319 370.025 4.6305300557
6 368.15 -1.02403009098319 369.0875 1.7725657843
7 368.15 -1.02403009098319 368.61875 0.3666551867
8 368.384375 -0.33058334103502 368.61875 0.3666551867
9 368.384375 -0.33058334103502 368.5015625 0.0175610421
10 368.4429688 -0.15662975602406 368.5015625 0.0175610421
11 368.4722656 -0.06956402280196 368.5015625 0.0175610421
12 368.4869141 -0.0260089085877 368.5015625 0.0175610421
13 368.4942383 -0.00422578802655 368.5015625 0.0175610421
14 368.4942383 -0.00422578802655 368.49790039 0.0066671633
15 368.4942383 -0.00422578802655 368.49606934 0.0012205717
16 368.4951538 -0.00150263713694 368.49606934 0.0012205717




Answer (in °C) 95.34515381

, xr=(a+b)/2 f(xr)
368.15 -1.024030091
375.65 23.12005258
371.9 10.53432368
370.025 4.630530056
369.0875 1.772565784
368.61875 0.366655187
368.384375 -0.330583341
368.5015625 0.017561042
368.44296875 -0.156629756
368.47226563 -0.069564023
368.48691406 -0.026008909
368.49423828 -0.004225788
368.49790039 0.006667163
368.49606934 0.001220572
368.49515381 -0.001502637
368.49561157 -0.00014104