1. (20 points) Create a user-defined function called far2cel that converts tempe

Question

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

Explanation / Answer

Solution:

I have solved 1 please repost others.

1.)

code:

Function far2cel(Fahrenheit)

far2cel = (CDb1(Fahrenheit) - 32) / 5 + 32

far2cel = Round(far2cel, 2)

MsgBox Fahrenheit & "(Fahrenheit) = " & far2cel & "(Celcious)", , "Conversion Result"

End Function

I hope this helps, please let me know in case of any doubt. Thumbs up if this helped..

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.