ENGINEERING MATHEMATICS - EXAMPLE 8.4 : Let 1 ^ 1 = 1, 2 ^ 2 = 4, 3 ^ 3 = 27. By using the Excel computer programming - either by Solver or Goal Seek, find the value of v for the Van der Waals equation (P - a / v ^2) (v - b) = RT where a = 18.82, b = 0.1193, P = 2, R = 0.082, T = 5000 for benzene. Describe briefly how to use Solver and Goal Seek in Excel program of computer to find the solution quickly.



ENGINEERING MATHEMATICS - EXAMPLE 8.4 : Let 1 ^ 1 = 1, 2 ^ 2 = 4, 3 ^ 3 = 27. By using the Excel co..

Answer / kangchuentat

ENGINEERING MATHEMATICS - ANSWER 8.4 : Rearranging the equation gives P v^3 - (Pb + RT) v^2 - av + ab = 0. By using Excel program of computer v = 0.19322. Solver : FILE -> Options -> Add-Ins -> Solver Add-in. Goal seek : DATA -> What-If-Analysis -> Goal Seek. In both functions, Set cell / Objective, To value / Value Of, By changing cell / Changing Variable Cells should be used where To value / Value Of = 0, By changing cell / Change Variable Cells is the assumed v value, Set cell / Objective is the equation of function. The answer is given by Kang Chuen Tat; PO Box 6263, Dandenong, Victoria VIC 3175, Australia; SMS +61405421706; chuentat@hotmail.com; http://kangchuentat.wordpress.com.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Chemical Engineering Interview Questions

What steps can be taken to avoid stress corrosion cracking (SCC) in steel vessels used for storing anhydrous ammonia?

0 Answers   ABC,


Explain the procedure to estimate the friction factor involved in heat exchanger tubes?

0 Answers  


What step should be taken in process industries if the process variable is oscillating?

0 Answers   HPCL,


Solve the first order differential equation : (Z 1)(dy/dx) = xy in term of ln |y| = f(x). Z = (x)(x).

1 Answers  


What is minimum flow required of NG having BTU value of 920 btu/scf for flame stability of LBTU gas of BTU value 220 BTU/SCF against the flow 80KPPH.

0 Answers  






ENVIRONMENTAL ENGINEERING - QUESTION 22.3 : A well delivers 225 US-gallons per minute of water to a chemical plant during normal system operation. (a) Calculate its flowrate in the unit of mega US-gallon per day or MGD. (b) The following formula is written next to the chlorine feed point : (chlorine feed rate, lb / day) = (flowrate, MGD) X (dose, mg / L) x (8.34). If this formula is correct, then what should the chlorine feed rate to be in pounds per day (lb / day) if the desired dose is 2 mg / L. (c) Prove by calculations that the constant 8.34 in the formula next to the chlorine feed point is correct. Let 1 US-gallon = 3.78541 L and 1 mg = 0.0000022046 pound.

1 Answers  


What is an effective means of removing silicone from aluminum?

0 Answers  


ACCOUNTING AND FINANCIAL ENGINEERING - EXAMPLE 34.28 : In the development of a small engineering facility for biochemical processing, completed contract method is applied in its construction accounting. In a short contract period, let the (contract price) = A. Let the (costs to date) = B; (estimated cost to complete) = C. (a) Find the values of : (i) estimated total costs; (ii) total estimated profit; (iii) percent completion to date. (b) If the project contract is 100 % completed : (i) find the total gross profit recognized; (ii) what is the exact numerical value of C?

1 Answers  


Explain the process of including heat exchangers in ammonia refrigeration system?

0 Answers  


NATURAL GAS ENGINEERING - QUESTION 26.2 : (a) The Hyperion sewage plant in Los Angeles burns 8 million cubic feet of natural gas per day to generate power in United States of America. If 1 metre = 3.28084 feet, then how many cubic metres of such gas is burnt per hour? (b) A reservoir of natural gas produces 50 mole % methane and 50 mole % ethane. At zero degree Celsius and one atmosphere, the density of methane gas is 0.716 g / L and the density of ethane gas is 1.3562 mg / (cubic cm). The molar mass of methane is 16.04 g / mol and molar mass of ethane is 30.07 g / mol. (i) Find the mass % of methane and ethane in the natural gas. (ii) Find the average density of the natural gas mixture in the reservoir at zero degree Celsius and one atmosphere, by assuming that the gases are ideal where final volume of the gas mixture is the sum of volume of the individual gases at constant temperature and pressure. (iii) Find the average density of the natural gas mixture in the reservoir at zero degree Celsius and one atmosphere, by assuming that the final mass of the gas mixture is the sum of mass of the individual gases. Assume the gases are ideal where mole % = volume % at constant pressure and temperature.

1 Answers  


For a Vernier scale of representative fraction (RF) = 1 / 25, calculate the length of the scale for the reading up to 4 metres.

1 Answers  


What are the disadvantages of using gear pumps?

0 Answers  


Categories
  • Civil Engineering Interview Questions Civil Engineering (5085)
  • Mechanical Engineering Interview Questions Mechanical Engineering (4451)
  • Electrical Engineering Interview Questions Electrical Engineering (16632)
  • Electronics Communications Interview Questions Electronics Communications (3918)
  • Chemical Engineering Interview Questions Chemical Engineering (1095)
  • Aeronautical Engineering Interview Questions Aeronautical Engineering (239)
  • Bio Engineering Interview Questions Bio Engineering (96)
  • Metallurgy Interview Questions Metallurgy (361)
  • Industrial Engineering Interview Questions Industrial Engineering (259)
  • Instrumentation Interview Questions Instrumentation (3014)
  • Automobile Engineering Interview Questions Automobile Engineering (332)
  • Mechatronics Engineering Interview Questions Mechatronics Engineering (97)
  • Marine Engineering Interview Questions Marine Engineering (124)
  • Power Plant Engineering Interview Questions Power Plant Engineering (172)
  • Textile Engineering Interview Questions Textile Engineering (575)
  • Production Engineering Interview Questions Production Engineering (25)
  • Satellite Systems Engineering Interview Questions Satellite Systems Engineering (106)
  • Engineering AllOther Interview Questions Engineering AllOther (1379)