Answered step by step
Verified Expert Solution
Link Copied!

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 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.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

How is a stereotype different from a prototype?

Answered: 1 week ago

Question

5. What are the main sources of profit in defensive marketing?

Answered: 1 week ago