Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

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?

1 Answers  


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.

1 Answers  


What are the different ways in which solids can be blended?

0 Answers  


what is defferance between tubular & automotive plate battery

0 Answers  


what is the discharge pressure formula, for calculating discharge pressure?

2 Answers  


In case of welded vessels why is stress relieving in the form of post-weld treatment necessary?

0 Answers  


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.

1 Answers  


What is a quick way to calculate frictional pressure drops in carbon steel pipe?

0 Answers  


which reformer efficiencywise best?

0 Answers  


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?

1 Answers  


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?

1 Answers  


Categories
  • Civil Engineering Interview Questions Civil Engineering (5086)
  • Mechanical Engineering Interview Questions Mechanical Engineering (4456)
  • Electrical Engineering Interview Questions Electrical Engineering (16639)
  • 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)