Use a loop in vba to generate two columns of data (x and f(x)) for the plot of
f(x) = x2 - 4sin(x) over the range -5 < x < 5 with increments equal to 0.1.
use newton’s method to solve for the roots of the equation f(x) = x2 - 4sin(x). identify the
ranges of the initial guess that will lead to one root or the other.
use newton’s method to solve for the root in problem 1.19 of last week’s fluid mechanics homework.
fit the data in the file class03data. xls, which contains vapor pressure data for cylcohexane as a function of the temperature, to a wagner model. this should be done using excel’s solver function by minimizing the least-squares residual. generate a fully formatted, professional semilogy plot that includes the original data and the wagner fit. test using an objective function of (psat - pcalc) and then again with the objective function (psat - pcalc)/psat. which provides a better fit and why? cyclohexane has critical parameters ( pc = 40.75 bar and tc = 553.54 k ) and the wagner model is given as:
psat = pc exp[ ( a + b /2 + c + d )/( 1 - ) ] where = 1 - t/tc