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 |
Question 87 - According to Hardy-Weinberg Equation, p x p + 2 x p x q + q x q = 1 where p = dominant allele frequency and q = recessive allele frequency. Let p + q = 1. Fraction of population has 2 copies of the p gene = p x p. Fraction of population has 2 copies of the q gene = q x q. Fraction of population has a copy of p gene and a copy of q gene = 2 x p x q. In a small town, the allele frequency is q = 0.2 for a recessive gene, the delta-32 mutation, that gives human protection from HIV infection. (a) Find the allele frequency a dominant gene, p. (b) What percent of the population has at least a copy of the gene that cause the population either immune to HIV or less susceptible to the disease?
Any idea on recombinant protein expression?
repected sir i have given gate exam today.......... if i ll get the better rank in that ....what is the next process .....shall i give another one test......or wat....i dint get properlly..... plz help me or mail me on Nish_gasti@yahoo.co.in
what is fund flow definition
Question 8 - A local utility burns coal having the following composition on a dry basis : Carbon (C) 83.05 %, hydrogen (H) 4.45 %, oxygen (O) 3.36 %, nitrogen (N) 1.08 %, sulfur (S) 0.7 % and ash 7.36 %. Calculate the ash free composition of the coal with reference to C, H, O, N and S.
what is difference between open loop system & close loop system by overview.
Question 108 - (a) The correct statement about both the average value of position (<x>) and momentum (<p>) of a 1-dimensional harmonic oscillator wavefunction is <x> = <p> = 1 - x. Find the value of x. (b) The probabilities of finding a particle around points A, B and C in the wavefunction y = f(x) are P(A), P(B) and P(C) respectively. Coordinates are A (3,5), B (4,-10) and C (6,7). Arrange P(A), P(B) and P(C) in term of a < b < c, when | y-coordinate | signifies the probability.
what are the major problem comes in the production process
2 Answers Atul, Deepak Fertilisers,
ACCOUNTING AND FINANCIAL ENGINEERING - EXAMPLE 34.26 : In a construction accounting for a biochemical processing plant, $A has been spent to date, and another $B is expected required to complete the construction project. The biochemical processing plant is expected to generate a total revenue of $C. Calculate the : (a) estimated total costs; (b) percentage completion of project; (c) total estimated profit; (d) profit to date.
Name some guidelines for designing for liquid and gas velocities in process plant piping?
Question 43 - In a non-dilute absorber, the inlet gas stream consists of 8 mol % carbon dioxide in nitrogen. By contact with room temperature water at atmospheric pressure, 65 % of the carbon dioxide from a gas stream has been removed. (a) Find the mole ratio of carbon dioxide and nitrogen gases at inlet and outlet gas streams. (b) The Henry’s Law provides y = 1640 x for carbon dioxide in water. Find the mole ratio when x = 0.0000427. Mole ratio is y / (1 - y) for y.
Explain the use of gear pumps in motor?
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)