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).



Question 30 – Solve the simultaneous equation using simple Excel program : r + s – t = 7..

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

Post New Answer

More Chemical Engineering Interview Questions

List the advantages and disadvantages of a pfr?

0 Answers  


Is four stage graphite steam jet ejector is possible. Any body can provide its design

0 Answers   Atul,


what is the purpose of capacitor? and capacitor load means what? how does it connect?

0 Answers  


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.

1 Answers  


what is ejector capacity and ejector economy

1 Answers  






Explain what are the disadvantages of using gear pumps?

0 Answers  


Explain the Deacon reaction?

2 Answers  


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).

1 Answers  


How much maximum power can be generated by 320v, 10kg-cm synchronous motor if shaft is rotated mechanically at 50 to 60 rpm?

0 Answers  


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.

1 Answers  


wha is Adsorption column chromatography?

0 Answers  


how to calculate overall heat transfer coefficient in insulated pipeline? Please give a answer with formula

2 Answers   NPCIL,


Categories
  • Civil Engineering Interview Questions Civil Engineering (5085)
  • Mechanical Engineering Interview Questions Mechanical Engineering (4451)
  • Electrical Engineering Interview Questions Electrical Engineering (16632)
  • Electronics Communications Interview Questions Electronics Communications (3918)
  • Chemical Engineering Interview Questions Chemical Engineering (1095)
  • Aeronautical Engineering Interview Questions Aeronautical Engineering (239)
  • Bio Engineering Interview Questions Bio Engineering (96)
  • Metallurgy Interview Questions Metallurgy (361)
  • Industrial Engineering Interview Questions Industrial Engineering (259)
  • Instrumentation Interview Questions Instrumentation (3014)
  • Automobile Engineering Interview Questions Automobile Engineering (332)
  • Mechatronics Engineering Interview Questions Mechatronics Engineering (97)
  • Marine Engineering Interview Questions Marine Engineering (124)
  • Power Plant Engineering Interview Questions Power Plant Engineering (172)
  • Textile Engineering Interview Questions Textile Engineering (575)
  • Production Engineering Interview Questions Production Engineering (25)
  • Satellite Systems Engineering Interview Questions Satellite Systems Engineering (106)
  • Engineering AllOther Interview Questions Engineering AllOther (1379)