ENGINEERING FUNDAMENTALS
ENGINEERING FUNDAMENTALS
6th Edition
ISBN: 9781337705011
Author: MOAVENI
Publisher: CENGAGE L
bartleby

Concept explainers

Question
Book Icon
Chapter 14, Problem 25P

(a)

To determine

Perform the mathematical operation of [A]+[B] for the given matrices using Excel.

(a)

Expert Solution
Check Mark

Answer to Problem 25P

The mathematical operation [A]+[B] for the given matrices is performed by using excel.

Explanation of Solution

Given data:

[A]=[421707153], [B]=[121533457], [C]=[124].

Calculation:

To find [A]+[B]:

ENGINEERING FUNDAMENTALS, Chapter 14, Problem 25P , additional homework tip  1

Refer to the Figure 1:

First type the appropriate characters and values in the Excel sheet. In the cell A6, type the operation as “[A]+[B]=”. Next in the cell B5, type as “=B1:D3+F1:H3”. Here, B1:D3 is done by select using left mouse button, pick cells B1 through D3 and F1:H3 is done by select by using left mouse button, pick cells F1 through H3. Then holding down the ctrl and the Shift Key, press the Enter key. The result obtained for the cell B5 as 5.

Likewise select by using left mouse button, pick cells from B5 through D7 and click in the formula bar, then holding down the ctrl and the Shift Key, press the Enter key. Thus, the result is obtained as shown in Figure 2.

ENGINEERING FUNDAMENTALS, Chapter 14, Problem 25P , additional homework tip  2

Conclusion:

Hence, the mathematical operation [A]+[B] for the given matrices has been performed using Excel.

(b)

To determine

Perform the mathematical operation of [A][B] for the given matrices using Excel.

(b)

Expert Solution
Check Mark

Answer to Problem 25P

The mathematical operation [A][B] for the given matrices is performed by using excel.

Explanation of Solution

Given data:

[A]=[421707153], [B]=[121533457], [C]=[124].

Calculation:

To find [A][B]:

ENGINEERING FUNDAMENTALS, Chapter 14, Problem 25P , additional homework tip  3

Refer to the Figure 3:

First type the appropriate characters and values in the Excel sheet. In the cell A7, type the operation as “[A][B]=”. Next in the cell B6, type as “=B1:D3-F1:H3”. Here, B1:D3 is done by select using left mouse button, pick cells B1 through D3 and F1:H3 is done by select by using left mouse button, pick cells F1 through H3. Then holding down the ctrl and the Shift Key, press the Enter key. The result obtained for the cell B5 as 3.

Likewise select by using left mouse button, pick cells from B6 through D8 and click in the formula bar, then holding down the ctrl and the Shift Key, press the Enter key. Thus, the result is obtained as shown in Figure 4.

ENGINEERING FUNDAMENTALS, Chapter 14, Problem 25P , additional homework tip  4

Conclusion:

Hence, the mathematical operation [A][B] for the given matrices has been performed using Excel.

(c)

To determine

Perform the mathematical operation 3[A] for the given matrices using Excel.

(c)

Expert Solution
Check Mark

Answer to Problem 25P

The mathematical operation 3[A] for the given matrices is performed by using excel.

Explanation of Solution

Given data:

[A]=[421707153], [B]=[121533457], [C]=[124].

Calculation:

To find 3[A]:

ENGINEERING FUNDAMENTALS, Chapter 14, Problem 25P , additional homework tip  5

Refer to the Figure 5:

First type the appropriate characters and values in the Excel sheet. In the cell A6, type the operation as “3[A]=”. Next in the cell B5, type as “=3*(B1:D3)”. Here, B1:D3 is done by select using left mouse button, pick cells B1 through D3. Then holding down the ctrl and the Shift Key, press the Enter key. The result obtained for the cell B5 as 12.

Likewise select by using left mouse button, pick cells from B5 through D7 and click in the formula bar, then holding down the ctrl and the Shift Key, press the Enter key. Thus, the result is obtained as shown in Figure 6.

ENGINEERING FUNDAMENTALS, Chapter 14, Problem 25P , additional homework tip  6

Conclusion:

Hence, the mathematical operation 3[A] for the given matrices has been performed using Excel.

(d)

To determine

Perform the mathematical operation of [A][B] for the given matrices using Excel.

(d)

Expert Solution
Check Mark

Answer to Problem 25P

The mathematical operation [A][B] for the given matrices is performed by using excel.

Explanation of Solution

Given data:

[A]=[421707153], [B]=[121533457], [C]=[124].

Calculation:

To find [A][B]:

ENGINEERING FUNDAMENTALS, Chapter 14, Problem 25P , additional homework tip  7

Refer to the Figure 7:

First type the appropriate characters and values in the Excel sheet. In the cell A6, type the operation as “[A][B]=”. Next in the cell B5, type as “=MMULT(B1:D3,F1:H3)”. Here, B1:D3 is done by select using left mouse button, pick cells B1 through D3 and F1:H3 is done by select by using left mouse button, pick cells F1 through H3. Then holding down the ctrl and the Shift Key, press the Enter key. The result obtained for the cell B5 as 18.

Likewise select by using left mouse button, pick cells from B5 through D7 and click in the formula bar, then holding down the ctrl and the Shift Key, press the Enter key. Thus, the result is obtained as shown in Figure 8.

ENGINEERING FUNDAMENTALS, Chapter 14, Problem 25P , additional homework tip  8

Conclusion:

Hence, the mathematical operation [A][B] for the given matrices has been performed using Excel.

(e)

To determine

Perform the mathematical operation of [A]{C} for the given matrices using Excel.

(e)

Expert Solution
Check Mark

Answer to Problem 25P

The mathematical operation [A]{C} for the given matrices is performed by using excel.

Explanation of Solution

Given data:

[A]=[421707153], [B]=[121533457], [C]=[124].

Calculation:

To find [A]{C}:

ENGINEERING FUNDAMENTALS, Chapter 14, Problem 25P , additional homework tip  9

Refer to the Figure 9:

First type the appropriate characters and values in the Excel sheet. In the cell A6, type the operation as “[A]{C}=”. Next in the cell B5, type as “=MMULT(B1:D3,J1:J3)”. Here, B1:D3 is done by select using left mouse button, pick cells B1 through D3 and J1:J3 is done by select by using left mouse button, pick cells J1 through J3. Then holding down the ctrl and the Shift Key, press the Enter key. The result obtained for the cell B5 as 4.

Likewise select by using left mouse button, pick cells from B5 through B7 and click in the formula bar, then holding down the ctrl and the Shift Key, press the Enter key. Thus, the result is obtained as shown in Figure 10.

ENGINEERING FUNDAMENTALS, Chapter 14, Problem 25P , additional homework tip  10

Conclusion:

Hence, the mathematical operation [A]{C} for the given matrices has been performed using Excel.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
pounds of steel need to be purchased for the roof plan   a table with various steel types and the quantity needed  The colums are 18 feet high and weigh 76 ponds per foot  include a structural steel material list for the roof framing plan
Homework: Determine the proportions of the separate aggregates that will give a gradation within the SCRB wearing coarse specified limits for the aggregates and mix composition for highway pavement asphaltic concrete. The table below shows the results of sieve analysis of samples from the materials available. برو Percent by Weight Passing Sieve Designation Retained on Sieve Designation Coarse Aggregate Fine Aggregate Mineral Filler 3/4 in. (19 mm) 1/2 in. 5 ½ in. (12.5 mm) 3/8 in. 35 ¾ in. (9.5 mm) No. 4 38 No. 4 (4.75 mm) No. 10 17 No. 10 (2 mm) No. 40 5 No. 40 (0.425 mm) No. 80 No. 80 (0.180 mm) No. 200 No. 200 (0.075 mm) Total 18 1118 30 35 5 26 35 60 100 100 100
For the driven pile shown in figure, estimate the allowable capacity by: (a) Tomlinson a-method, (b)Vijayvergia and Focht A-method. Which one of the two methods are more conservative? Qall =? W.T 18.21 kN/m² 930 L=18m Square pile 27.5cm x 27.5cm
Knowledge Booster
Background pattern image
Civil Engineering
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, civil-engineering and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Engineering Fundamentals: An Introduction to Engi...
Civil Engineering
ISBN:9781305084766
Author:Saeed Moaveni
Publisher:Cengage Learning
Text book image
Fundamentals Of Construction Estimating
Civil Engineering
ISBN:9781337399395
Author:Pratt, David J.
Publisher:Cengage,