Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3. You have already learned the formula for the Trapezoid rule. This is a perfect situation for using VBA and a For Loop. Use the

image text in transcribedimage text in transcribed

3. You have already learned the formula for the Trapezoid rule. This is a perfect situation for using VBA and a For Loop. Use the data that was given to for problem 3,4 , which is X (conversion) and 1/ra (the inverse of consumption rate). Recall that we are going to integrate this data from X=0 to X=0.8, and further remember that after integrating you will need to multiply by 100 mol/min (and further recall that you already did this once, so you know the answer that should come out!). The only trick here is that you will want to use one equation when dealing with the first data point OR the last data point. To do this, you will use a For Loop with a counter "i", and inside the For Loop, you will use an If statement to treat the first and last data point in one way, and the rest of the data in another. First, copy the data from HW#8 into columns A and B on an excel sheet. Pull the data from the spreadsheet using Range variable types and the Set command. Ask the user for the number of data POINTS in an input box. You can find the delta X value in multiple ways, so l'll leave that to you. Print the value of your answer into cell C10. DO NOT HARDCODE the sequence of factors, i.e., 1,2,2,2,2,2,2,2,1

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

Heat And Mass Transfer Fundamentals And Applications

Authors: Yunus Cengel, Afshin Ghajar

6th Edition

0073398195, 978-0073398198

More Books

Students also viewed these Chemical Engineering questions

Question

Write a short note on - JUDICIARY

Answered: 1 week ago

Question

Explain Promotion Mix.

Answered: 1 week ago

Question

Explain the promotional mix elements.

Answered: 1 week ago

Question

1. There are many social organisations around us?

Answered: 1 week ago

Question

1. Specify (the values for H).

Answered: 1 week ago