1. (20 oints) Create a user-defined function called farZcel that converts temper

Question

1. (20 oints) Create a user-defined function called farZcel that converts temperature of petroleum fluid in Fahrenheit (F) to Celslus (C) using the formula TIC) (TIF)-32/9. The function should be visible to the spreadsheet so it can be called from a cel using the syntax-far2cel 2. (4onontg) Write compute the symmetric and anti-symmetric parts of this matrix seperately and display it below the siven VBA macro that reads in 5 x 5 matra an the attached Excel spreadsheet must matrix HINT Symmetric part of a matrix A, sym-A+ ATV2 Anti-symmetric part of Transpose of a matrix A is defined as A such that AJl AUA Asym·(A-A12 matris · 40points) create a VBA program that determines the root of the following function for the pen bracket f(x) =-0.5x2 + 25x + 4.5 Display the estimated error and calculated midpoint of the bracket after first two terations may stop the calculations after second iteration. HINT Function bisectfxi, xu, es, imax, xr, iter, ea) ter o Do You xr(xl xul/2 iter= iter + 1 fxr0 then ea absfxr-xold/xr) 100 end if test - fixl) ffoxr) 0 then

Explanation / Answer

Solution:

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.