Question 27 – By using Excel or other easiest programming package, explain

Question 27 – By using Excel or other easiest programming package, explain how I, the integral of sin x dx from 0 to 3.142 could be approximated using random number. Find the exact value of I.

Question Posted / kang chuen tat (malaysia - pen

1 Answers
1716 Views
I also Faced
E-Mail Answers

Question 27 – By using Excel or other easiest programming package, explain how I, the integral..

Answer / kang chuen tat (malaysia - pen

Answer 27 : When Excel is used, let column A=RAND() and column B=ASIN(A1). Stretch the columns A and B vertically. The data is transferred to Word, then reinserted into column C and D in order to prevent changes in column A. By using the sort function from the lowest to highest, arrange the data in column C and D, followed by trapezoidal rule performance in column E=0.5*(C1+C2)*(D2-D1). The 2 times summation of values in column E will approximate I≈2 gradually as the random numbers used increase. Exact value of I = -2(-1) = 2 units. 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

CHEMICAL ENERGY BALANCE - EXAMPLE 11.5 : According to Margules Equation, P = x(1) p(1) g(1) + x(2) p(2) g(2) for a two-component mixture where P is bubble pressure, x is mole fraction, p is saturation pressure, g is constant given by ln g(1) = x(2) A x(2). Find the value of A as a constant when P = 1.08 bar, p(1) = 0.82 bar, p(2) = 1.93 bar in a 50 : 50 mole fraction mixture. Estimate the pressure required to completely liquefy the 30 : 70 mixture using the same equation, by proving P = 1.39 bar. Take note that ln g(2) = x(1) A x(1), ln g(1) = x(2) A x(2).

1 Answers

QUANTUM CHEMISTRY AND CHEMICAL ENGINEERING - EXAMPLE 31.2 : (a) Let | - > = 1 | x > + 0 | y >, | | > = 0 | x > + 1 | y >. Find the value of 2 | x > + 3 | y > in term of | - > and | | >. (b) Let m to be the reduced mass. Find the value of m in term of Ma and Mb where 1 / m = 1 / Ma + 1 / Mb.

1 Answers

What are the types of load?

0 Answers

i am going to appear vedanta written test so plz can any body suggest me for this on madhu.5393@gmail.com

0 Answers

What are the Major Utility Systems in a Pharma Plant? How are they interrelated?

0 Answers

Why do we apply on iron articles?

0 Answers

ENGINEERING NUMERICAL METHODS - EXAMPLE 19.3 : There are 2 simultaneous equations : (A1) x + (B1) y = D1 and (A2) x + (B2) y = D2. (a) By using Excel program, find the values of x and y when A1 = 80, A2 = 150, B1 = 52, B2 = 100, D1 = 3.5 and D2 = 2.3. (b) Write the expression of Excel in the form of =MMULT(MINVERSE(W:X),Y:Z) in order to get the values of x and y. W, X, Y and Z may be A1, A2, B1, B2, D1 and D2.

1 Answers

Please help me send me questions for HPCL written test of Chemical Branch.I will be highly thankful to u...

0 Answers TCE,

can u tel me d question paper of gail?

0 Answers HPCL,

Define octane number?

0 Answers

Experiment constitutes 1000 ml of 10 ppm dye solution and 0.2 g catalyst mixed in beaker. How to calculate the initial of concentration?

1 Answers

What is a surfactant?

0 Answers

For more Chemical Engineering Interview Questions Click Here