Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please show the steps of writing the VBA on excel! a Write a VBA user-defined function to convert a weight fraction (wi) into a mole
Please show the steps of writing the VBA on excel!
a Write a VBA user-defined function to convert a weight fraction (wi) into a mole fraction (xi) of a multi-component system. The formula is: M A X w > M 1 where Mi is the molecular weight of the i-th component. a) Test your function for a binary system of methanol in 2-propanol (isopropyl alcohol). Determine the mole fractions of methanol (as component A) for mixtures with the following weight fractions: WA= 0, 0.125, 0.250,0.375, 0.500, 0.750,0.900,0.950, 1.00 = b) Plot the results in part (a) with the mole fraction of methanol shown as a function of methanol weight fraction for the binary methanol/2-propanol system. c) Display the entire VBA code resulting from your programmed user function. Include your name as a commentStep 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