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
i have done B.TECH in che.tech.and doing MBA . why you doing mba why u have not join any job.
hello sir..iam keen to sit for iocl interview..please forward sample iocl questions to my id: kunal_kv06@yahoo.co.in
Explain some good strategies for curing tube vibration in shell and tube exchangers?
Calculate the line size for a cooling water line with a volumetric flowrate of 1200m3/h of water. Density of water = 1000kg/m3
Difference between Synthetic foaming agents V/S Protien based foaming agent?
What are the effects of oils on the properties of Polyolefins?
What are the applications of screen analysis in the chemical industry?
Explain what are the assumptions made on conservation equation?
have any one question paper of institute of plasma research center for aptitute as well as technical?
Is there a handy way to determine if a horizontal pipe is running full if the flow rate is known?
What effect does choking a vertical thermosiphon have on the heat transfer rate?
What information is needed to specify a mixer?
what is the purpose of capacitor? and capacitor load means what? how does it connect?
What type of pump may be appropriate for a liquid near saturation, a low flow rate, and very limited npsha (net positive suction head available)?
What are the some common causes of control valve noise?