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.
Answer Posted / 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 View All Answers
What is difference between overall heat transfer coefficient & individual heat transfer coefficient?
if i added hypo before DM plant so i will affect my resins of anion or cation. if affect it so do prevent what kind of step should be taken to remove hypo before DM inlet?
What is quicklime and what are the uses?
What are the apt definitions for apparent power, active power and reactive power? Explain about different types of lamps?
how should i prepare for my placements.i am a student of chemical eng,final year,thapar university
Can large temperature differences in vaporizers cause operational problems?
How many grams per liter would there be in a 0.35 n (normality) citric acid solution?
y we do not differ b/w atomic mass and atomic wieght? from engrtauseef2008@gmail.com
What are the strategies acquired to cure tube vibration and exchangers in a shell?
What is gibbs free energy?
What is a "saltation velocity"?
What step should be taken in process industries if the process variable is oscillating?
Explain some of the consequences of an undersized kettle type reboiler?
What are the steps taken to operate a tank-blanketing valve?
What are some good strategies for curing tube vibration in shell and tube exchangers?