Q2

1. (20 points) Create a user-defined function called far2cel that converts temperature of petroleum fluid in Fahrenheit (F) to Celsius (C) using the formula T(C) = 5*[T(F)-321/9. The function should be visible to the spreadsheet so it can be called from a cell using the syntax "- far2cell 2. (40 points) Write a VBA macro that reads in 5 x 5 matrix in the attached Excel spreadsheet. It must compute the symmetric and anti-symmetric parts of this matrix separately and display it below the givern matrix. HINT: Symmetric part of a matrix A, Sym 3(A+ A')/2; Anti-symmetric part of a matrix A, Asym = (A-AT)/2; Transpose of a matrix A is defined as AT such that A( : A(j,i). 3. (40 points) Create a VBA program that determines the root of the following function for the given bracket of (-5, xu :10) using BISECTION METHOD: f(x) =-0.5x2 + 2.5x + 4.5 Display the estimated error and calculated midpoint of the bracket after first two iterations, You may stop the calculations after second iteration HINT Function bisect(xl, xu, es, imax, xr, iter, ea) iter = 0 Do xrold =xr xr = (xl + xu)/2 iter = iter + 1 if xr0then ea - abstxr-xold)/xr) 100 end if test - f(xl)"fxr) if test