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]:

LMS Integrated for MindTap Engineering, 2 terms (12 months) Printed Access Card for Moavni's Engineering Fundamentals: An Introduction to Engineering, 5th, 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.

LMS Integrated for MindTap Engineering, 2 terms (12 months) Printed Access Card for Moavni's Engineering Fundamentals: An Introduction to Engineering, 5th, 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]:

LMS Integrated for MindTap Engineering, 2 terms (12 months) Printed Access Card for Moavni's Engineering Fundamentals: An Introduction to Engineering, 5th, 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.

LMS Integrated for MindTap Engineering, 2 terms (12 months) Printed Access Card for Moavni's Engineering Fundamentals: An Introduction to Engineering, 5th, 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]:

LMS Integrated for MindTap Engineering, 2 terms (12 months) Printed Access Card for Moavni's Engineering Fundamentals: An Introduction to Engineering, 5th, 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.

LMS Integrated for MindTap Engineering, 2 terms (12 months) Printed Access Card for Moavni's Engineering Fundamentals: An Introduction to Engineering, 5th, 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]:

LMS Integrated for MindTap Engineering, 2 terms (12 months) Printed Access Card for Moavni's Engineering Fundamentals: An Introduction to Engineering, 5th, 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.

LMS Integrated for MindTap Engineering, 2 terms (12 months) Printed Access Card for Moavni's Engineering Fundamentals: An Introduction to Engineering, 5th, 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}:

LMS Integrated for MindTap Engineering, 2 terms (12 months) Printed Access Card for Moavni's Engineering Fundamentals: An Introduction to Engineering, 5th, 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.

LMS Integrated for MindTap Engineering, 2 terms (12 months) Printed Access Card for Moavni's Engineering Fundamentals: An Introduction to Engineering, 5th, 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
The drainage system shown in fig 14.35 is designed to collect the stormwater from 3 atreas The areas runoof coefficients and overland flow times are as follows The rainfall intensity i (mm/h) as a function of rainfall duration t(min) is i =1.12/t+110 The flow time in sewer 1-2 is 2min and in sewer 2-3 is 2.5 min
Please answer the question from the picture, show each step and explain please. Thank you so much
Figure 1 shows the plan view of an Exhibition Hall with dimensions L1 x L2. The structure is to be constructed in a coastal region which will be exposed to mostly mild environmental conditions and should provide a 1.5-hour fire resistance. It is known that the underlying foundation soil contains sulphate and other organic compounds. The layout of the structure consists of portal frames which are spaced evenly along the L2 direction. The frames are to support a slab of thickness (t) that will cover the full area of the hall plan. The dead and live loads applied on the slab are G and Q (kPa), respectively.
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,