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.
- 1 Answers
- 1718 Views
- I also Faced
- E-Mail Answers
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 difference between cfm (cubic feet per minute) and scfm (standard cubic feet per minute)?
Explain how can you quickly estimate the horsepower of a pump?
How can you control the ph level in our cooling water with respect to ammonia contamination?
Mention some of the specialized crushing methods?
Is there a difference in mtd (mean temperature difference) between 'e' and 'j' (divided flow) type shell and tube heat exchangers?
How does a tank-blanketing valve operate?
How can you quickly estimate the horsepower of a pump?
What are the different ways in which solids can be blended?
For what ration of Lengh/Dia. of tank (Jacketed tank), maximum heat transfer area is available?
What kind of concerns is associated with temperature pinch points in condensers?
What does the catalytic converter on an automobile really do?
what is load and what are the types of load?
What is some common piping materials used to transport slurries?
What steps can be taken to avoid stress corrosion cracking (SCC) in steel vessels used for storing anhydrous ammonia?
Name some factors to consider when trying choosing between a dry screw compressor and an oil-flooded screw compressor?
