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

Question 37 - Calculate the bubble temperature T at P = 85-kPa for a binary liquid with x(1) = 0.4. The liquid solution is ideal. The saturation pressures are Psat(1) = exp [ 14.3 - 2945 / (T + 224) ], Psat(2) = exp [ 14.2 - 2943 / (T + 209) ] where T is in degree Celsius. Please take note that x(1) + x(2) = 1. Please take note that y(1) + y(2) = 1, y(1) = [ x(1) * Psat(1) ] / P, y(2) = [ x(2) * Psat(2) ] / P, * is multiplication. P is in kPa.

1 Answers  


QUANTUM CHEMISTRY AND CHEMICAL ENGINEERING - EXAMPLE 31.9 : When an algebraic product is defined on the space, the Lie bracket is the commutator [x,y] = xy - yx according to Lie algebra in mathematics. If [p,x] f(x) = px f(x) - xp f(x), p = -ih d / dx, find the value of [p,x] in term of i and h.

1 Answers  


Need to design filter...Length and diamter of shell

1 Answers  


What is the largest application for surfactants?

0 Answers  


Explain the Deacon reaction?

2 Answers  






How to TDS removed found in lab apparatus.

1 Answers  


CHEMICAL FLUID MECHANIC - EXAMPLE 3.1 : Water flows through a pipe with circular cross sectional area at the rate of V / t = 80 L / s where V is the volume and t is time. Let Av = 80 L / s where A is cross sectional area and v is velocity of fluid. For point 1, the radius of the pipe is 16 cm. For point 2, the radius of the pipe is 8 cm. Find (a) the velocity at point 1; (b) the velocity at point 2; (c) the pressure at point 2 by using Bernoulli's equation where P + Rgy + 0.5 RV = constant. P is the pressure, R = density of fluid, V = square of fluid's velocity, g = gravitational constant of 9.81 N / kg and y = 2 m = difference of height at 2 points. The pressure of point 1 is 180 kPa.

1 Answers  


FOOD ENGINEERING - QUESTION 23.1 : (a) According to United States Department of Agriculture (USDA) (http://ndb.nal.usda.gov/ndb/search/list, accessed 12 August 2016), 100 g of potatoes generate 77 kcal of energy. For raw tomatoes, 111 g have 18 kcal of energy. Question : How much energy will one gain if 150 g of heated potatoes are eaten with 200 g of raw tomatoes? (b) If 1 Calorie = 1 food Calorie = 1 kilocalorie and 1000 calories = 1 food Calorie, then how many Calories are there in 9600 calories? (c) According to a food package of potato chips, 210 Calories are produced per serving size of 34 g. In actual experiment of food calorimetry lab, 1.75 g of potato chips, when burnt, will produce 9.6 Calories. For each serving size of potato chip, find the difference of Calories between the actual experimental value and the value stated on the food package. (d) The specific heat of water is c = 1 cal / (g.K) where cal is calorie, g is gram and K is Kelvin. Then what is the temperature rise of water, in degree Celsius, when 150 g of water is heated by 9600 calories of burning food?

1 Answers  


What does the catalytic converter on an automobile really do?

0 Answers  


Question 52 - The half-life for first order reaction could be described in the differential equation dC / dt = -kC where k is a constant, C is concentration and t is time. (a) Find the equation of C as a function of t. (b) Find the half life for such reaction or the time required to reduce 50 % of the initial concentration, where k = 0.139 per minute. (c) When the initial concentration Co is 16 mol / cubic metre, how long does the reaction required to achieve the final concentration of 1 mol / cubic metre?

1 Answers  


CHEMICAL MATERIAL BALANCE – EXAMPLE 2.2 : Three hundred gallons of a mixture containing 75.0 wt % ethanol and 25 wt % water (mixture specific gravity = 0.877) and a quantity of a 40.0 wt % ethanol - 60 wt % water mixture (specific gravity = 0.952) are blended to produce a mixture containing 60.0 wt % ethanol. The specific gravity of a substance is the ratio of density of a substance compared to the density of water. The symbol of weight percent is wt %. (a) Estimate the specific gravity of the 60 % mixture by assuming that y = mx c where y is wt % ethanol, x is mixture specific gravity. Values for m and c are constants. (b) Determine the required volume of the 40 % mixture.

1 Answers  


Question 107 - In N + 1 Rule in Quantum Chemistry, whenever a spin 1 / 2 nucleus is adjacent to N other nuclei, it is split into N + 1 distinct peaks. In 1 peak or singlet, there is only 1 magnitude. In 2 peaks or doublet, the ratio of magnitude of each peak is 1 : 1. In 3 peaks or triplet, the ratio of magnitude of each peak is 1 : 2 : 1. In 4 peaks or quartet, the ratio of magnitude of each peak is 1 : 3 : 3 : 1. In 5 peaks or quintet, the ratio of magnitude of each peak is 1 : 4 : 6 : 4 : 1. (a) By using binomial coefficients or Triangle of Pascal find the ratio of magnitude of each peak if 6 peaks exists. (b) How many adjacent nuclei are available in a spin 1 / 2 nucleus in such situation of 6 peaks?

1 Answers  


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)