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 |
Why methanol like petroleum compounds are stored in underground storage tanks?
2 Answers MPCL, NFIL, Reliance, UPL,
ACCOUNTING AND FINANCIAL ENGINEERING - EXAMPLE 34.28 : In the development of a small engineering facility for biochemical processing, completed contract method is applied in its construction accounting. In a short contract period, let the (contract price) = A. Let the (costs to date) = B; (estimated cost to complete) = C. (a) Find the values of : (i) estimated total costs; (ii) total estimated profit; (iii) percent completion to date. (b) If the project contract is 100 % completed : (i) find the total gross profit recognized; (ii) what is the exact numerical value of C?
A cantilever beam of length L = 3 m carries a uniformly distributed load (UDL) of W = 20 N / m throughout the length. Calculate the bending moment, BM of the beam near the fixed end. What is the shear force, SF at this point? Let SF = -WL, BM = -LWL/2.
What are the different ways in which solids can be blended?
what is defferance between tubular & automotive plate battery
what is the discharge pressure formula, for calculating discharge pressure?
In case of welded vessels why is stress relieving in the form of post-weld treatment necessary?
Question 60 – During the landing process of an airplane, the velocity is constant at v. (a) If the displacement of the plane is x at time t, find the differential equation that relates t, x and v. (b) The plane has 2 parts of wheels – the front and the back, separated by a distance L. The front part of the wheel touches the land first, that allows the straight body of the plane to form an angle T with the horizontal land. If the vertical distance between the back part of the wheel and the horizontal land is y, find the equation of y as a function of L and T. (c) Find the differential equation that relates dy as a function of dt, v and sin T. (d) Find the differential equation that consist of dy as a function of y, L, v and dt. (e) Find the equation of y as a function of v, L, t and C where C is a constant. (f) When t = 0, prove that y = exp C as the initial value of y.
What is a quick way to calculate frictional pressure drops in carbon steel pipe?
which reformer efficiencywise best?
Question 72 - (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 calory, 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?
DIFFERENTIAL EQUATIONS - EXAMPLE 20.1 : By using Excel program either on laptop or desktop PC, solve the differential equation dy / dx = -2y + x + 4 with h = 0.005, initial values : x = 0, y = 1. The 4th order Runge-Kutta method provides : y(N + 1) = y(N) + (1/6) (k1 + 2k2 +2k3 + k4), k1 = h [ -2y(N) + x(N) + 4 ], k2 = h { -2 [ y(N) + k1 / 2 ] + x(N) + h / 2 + 4 }, k3 = h { -2 [ y(N) + k2 / 2 ] + x(N) + h / 2 + 4 }, k4 = h { -2 [ y(N) + k3 ] + x(N) + h + 4 }. What is the value of y at x = 0.5?
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)