Answered step by step
Verified Expert Solution
Question
1 Approved Answer
( 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started