Question: ( Problem 1 - use Excel ) For this problem, use the following data file on Canvas: HW 3 P 1 _ Data.xIsx The data
Problem use Excel
For this problem, use the following data file on Canvas:
HWPData.xIsx
The data set represents a reactor's shell temperature as
it is being quenched over a span of minutes, and you
wish to examine the time rate of temperature change
for the system.
a Using this data and a secondorder finite central
difference formula for the first derivative,
~~
approximate the time rate of temperature change
where possible in Column C Highlight the rate at
minutes.
b Create a user function in VBA to approximate the
second derivative, using the following
secondorder finite central difference formula:
~~
Place your results where possible in Column D
Highlight the second derivative approximation at
minutes.
c Display the entire VBA code resulting from your
programmed user function created for part b Include
your name as a comment.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
