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 |
List the advantages and disadvantages of a pfr?
Is four stage graphite steam jet ejector is possible. Any body can provide its design
what is the purpose of capacitor? and capacitor load means what? how does it connect?
ACCOUNTING AND FINANCIAL ENGINEERING - EXAMPLE 34.27 : A biochemical engineering consultancy applies construction accounting in its finance. Its project began on 1 January 2010. Total revenue generated from the project was $9000. On 1 January 2011 as the budget, $2000 had been spent, with $6000 expected. However, the project cost increased latter, causing deviation from its initial budget on 1 January 2012, where $7000 had been spent, with $1400 expected. Let (estimated total cost) = (spent cost) + (expected cost to be spent), (percentage completion) = 100 (spent cost) / (estimated total costs), (total expected profits) = (total revenue) - (estimated total costs). Calculate : (a) total expected profits on 1 January 2011 and 1 January 2012; (b) estimated total cost as and not as the budget; (c) percentage completion of the project since the project began, in the first and second years.
what is ejector capacity and ejector economy
Explain what are the disadvantages of using gear pumps?
Explain the Deacon reaction?
Question 91 - In the application of Theory of Spectrometry in spectrophotometer, let n = N x C x V, V = A x t, e = a x N where n = number of molecules, N = Avogadro's number, V = volume of cuvette, A = area of cuvette, t = thickness of cuvette, C = concentration of fluid in the cuvette, e = extinction coefficient, a = effective area of molecule. (a) By using calculus in dI = -I x a x N x C x dt, prove that ln (I / Io) = -a x N x C x t, where dI is the small difference in I and dt is the small difference in t. I = intensity of light. Io = initial intensity of light. (b) Show by calculations that ln (Io / I) = e x C x t based on the answer in the previous question (a). (c) Find the equation of log (Io / I) as a function of e, C and t based on the answer in the previous question (b).
How much maximum power can be generated by 320v, 10kg-cm synchronous motor if shaft is rotated mechanically at 50 to 60 rpm?
THERMODYNAMIC - EXAMPLE 10.1 : The water is superheated steam at 440 degree Celsius and 17.32 megapascals. Estimate the enthalpy of the steam above. From the steam table for water at 440 degree Celsius, enthalpy of steam, h at 18 megapascals is 3103.7 kilojoules per kilogram and at 16 megapascal is 3062.8 kilojoules per kilogram. Assume that h = mP + c where P is pressure; m and c are constants at fixed temperature with small differences in P.
wha is Adsorption column chromatography?
how to calculate overall heat transfer coefficient in insulated pipeline? Please give a answer with formula