Question 30 – Solve the simultaneous equation using simple Excel program : r + s – t = 7, 2r – s = 0, 3r + 2t = 15. Explain the use of functions of MINVERSE and MMULT together with the keyboard C (Ctrl) + S (Shift) + E (Enter).
Answer / kang chuen tat (malaysia - pen
Answer 30 : By using Microsoft Excel, r = 3.22, s = 6.44, t = 2.67. MINVERSE, or =minverse is used to inverse the 3 x 3 matrix with constants of r, s, t. MMULT, or =mmult can be used to obtain the answers by functions (inversed matrix of 3 x 3, constants of 7 and 0 and 15). CSE is an Excel function to perform quick calculations for the cells. 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 |
marketing procedure of iocl
ENVIRONMENTAL ENGINEERING - QUESTION 22.1 : In order to predict the wastewater production, the population number has to be understood. The population data is : 72000 (for year 1961 or P-1961), 85000 (for year 1971 or P-1971), 110500 (for year 1981 or P-1981). (a) Find the average population increase, or [ (P-1981 - P-1971) + (P-1971 - P-1961) ] / 2. (b) Find the average percentage population increase, or [ (P-1981 - P-1971) / P-1971 + (P-1971 - P-1961) / P-1961 ] / (2) X 100. (c) Find the incremental increase or P-1981 - 2 (P-1971) + P-1961. (d) Let Po = P-1981. After 2 decades or n = 2, the population is P-2001. By using arithmetical increase method, find P-2001 = Po + n (Answer for a). (e) By using incremental increase method, find P-2001 = (Answer of d) + n (n + 1) (Answer of c) / 2. (f) By using geometrical increase method, find P-2001 = Po [ 1 + (Answer of b) / 100 ] ^ n where ^ is power sign, or 1 ^ 2 = 1 x 1 = 1. (g) If the actual P-2001 = 184000, which method of estimation is more accurate, based on your answer in (d), (e) and (f)?
What are demand of crotonaldehyde99% in the worldand its international market ?
whats the allowed tolerance of pipe to pipe butt joint mismatching
What are the steps required to design a vapor-liquid separator or flash drum?
Question 66 – The drag coefficient Cd = 0.05 and lift coefficient Cl = 0.4 for a levelled flow aircraft are measured. The velocity of the aircraft is v = 150 ft / s with its weight W = 2677.5 pound-force. (a) Find the value of the lift of the aircraft, L, when it is also its weight. (b) The drag of the aircraft, D = Cd M, L = Cl M. Find the value of D. (c) The power required is P = Dv. If 1 pound-force x (ft / s) = 1.356 W, find the value of P in the unit of Watt or W.
what is the speed of a rotary drier
Question 86 - (a) Male with genotype GGmm and phenotype gray wingless mates with female with genotype ggMM and phenotype black winged in fruit flies. G is dominant to g in color. M is dominant to m in wing shape. If the actual distribution of the second generation of the fruit flies was as follow : 890 gray wingless, 900 black winged, 115 gray winged, 95 black wingless, calculate the recombination frequency betwen the two genes and distance in recombination units. Let 1 map unit = 1 % recombination. (b) A DNA molecule has 180 base pairs and 20 % adenine. How many cytosine nucleotides are present in this molecule of DNA?
Explain how can you determine the proper pipe thickness for a slurry line?
How much will be the increment for postal assistant yearly?
What is the purpose of capacitor?
What are the effects of oils on the properties of Polyolefins?
Civil Engineering (5086)
Mechanical Engineering (4456)
Electrical Engineering (16639)
Electronics Communications (3918)
Chemical Engineering (1095)
Aeronautical Engineering (239)
Bio Engineering (96)
Metallurgy (361)
Industrial Engineering (259)
Instrumentation (3014)
Automobile Engineering (332)
Mechatronics Engineering (97)
Marine Engineering (124)
Power Plant Engineering (172)
Textile Engineering (575)
Production Engineering (25)
Satellite Systems Engineering (106)
Engineering AllOther (1379)