Question: ( Problem 1 - use Excel ) For this problem, use the following data file on Canvas: HW 3 P 1 _ Data.xIsx The data

(Problem 1- use Excel)
For this problem, use the following data file on Canvas:
HW3P1_Data.xIsx
The data set represents a reactor's shell temperature as
it is being quenched over a span of 80 minutes, and you
wish to examine the time rate of temperature change
(dTdt) for the system.
(a) Using this data and a second-order finite (central)
difference formula for the first derivative,
df(xi)dx~~f(xi+1)-f(xi-1)2x
approximate the time rate of temperature change
(where possible) in Column C. Highlight the rate at 10
minutes.
(b) Create a user function in VBA to approximate the
second derivative, (d2Tdt2), using the following
second-order finite (central) difference formula:
d2f(xi)dx2~~f(xi+1)-2f(xi)+f(xi-1)(x)2
Place your results (where possible) in Column D.
Highlight the second derivative approximation at 10
minutes.
(c) Display the entire VBA code resulting from your
programmed user function created for part (b). Include
your name as a comment.
 (Problem 1- use Excel) For this problem, use the following data

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!