COMPUTER PROGRAMMING FOR ENGINEERS - EXAMPLE 17.1 : 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.

Answer Posted / kangchuentat

COMPUTER PROGRAMMING FOR ENGINEERS - ANSWER 17.1 : 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 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Where barrel pump use?

1407


I want previous year question paper of ONGC for chemical engg.

1786


Explain why does catalytic converter used in an automobile?

552


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

621


What is the ignititon temprecher of Diesel,Petrol&Carosion oil.

2697






What is load?

684


Explain how can you keep our seawater used for heat rejection clean before entering our heat exchangers?

578


Specific Heat of Bagasse at 50% moisture, 40% moisture and 25% moisture?

2521


What are some common causes of control valve noise?

582


Hi, I am in need of interview questions from Engineers india limited in chemical engineering.if any one has kindly post it to me soon.

5480


Dielectric materials in static fields

1781


What is an effective means of removing silicon from aluminum?

647


How can viscosity affect the design of a mixer?

667


how did you spend today

1672


could any one plzz give me the placement tech papers taken by iocl,and bpcl in chemical stream..... my id is.... mishra.gaurang@gmail.com

1756