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 the apt definitions for apparent power ,active power and reactive power?and explanation about different types of lamps?
What are demand of crotonaldehyde99% in the worldand its international market ?
How much steam required for 1MW power production form 30 bar G super heated steam(350 C), outlet of turbine 4.5 bar
Name some guidelines for designing for liquid and gas velocities in process plant piping?
A shiny brown colored element ‘x’ on heating in air becomes black in cooler name the element ‘x’and black colored compound formed?
sir,please give me some exam paper for referance. Thanks & Regards,
What are the design considerations for a piping system for the transfer of slurries?
oil field interview question
What is the basic difference between dispersion & distribution in any polymer blend or alloy??
At what temperature is glass fused to steel in the making of glass-lined equipment?
Is it advisable to cool a fin fan by spraying demineralized water on it?
Why is post-weld heat treatment (stress relieving) sometimes necessary for welded vessels?
what is mass flow rate of steam of 7 kg/cm2 pressure in 1 inch id. pipe.
pleas tell me about chemical engineering apptitude test..
Explain the different ways in which solids can be blended?