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


Please Help Members By Posting Answers For Below Questions

What does the catalytic converter on an automobile really do?

599


is extractive distillationӞH

1709


If sum one has HAL placement paper plz mail me ,I m Chemical Engg.my id is er.kotnala@gmail.com

2049


What are the applications of screen analysis in the chemical industry?

574


i am a student of thapar university final year.can anybody please help me with the exam pattern of the companies:engineers india ltd. ; iocl ; UOP, HPCL. If psbl plz send me the previous years questions on this email id k_arora1987@yahoo.com. i d be really greatful

1919






Can asphalt be recycled to form a useful product?

624


What type of heat exchangers are most commonly used for a large-scale plant-cooling loop using seawater as the utility?

682


Explain how is waste heat boilers categorized?

607


Are there any alternatives to scraping a shell and tube if a capacity increase will make the pressure drop across the exchanger too large?

689


What is some common piping materials used to transport slurries?

705


What types of pneumatic conveying systems are typically used?

601


Why is a vacuum breaker used on shell and tube heat exchangers that are utilizing steam as the heating utility?

738


How can you separate hydrogen peroxide into hydrogen and oxygen?

651


What are some characteristics of bulk solids that can affect their ability to flow properly?

639


How can viscosity affect the design of a mixer?

667