Engineering Fundamentals: An Introduction to Engineering, 4th ed.c

442 Chapter 14 Electronic Spreadsheets Here, matrix [N] is a three by three (or 3 3) matrix whose elements are numbers, and {L}i ...

14.7 Matrix Computation with Excel 443 In the cells shown, type the appropriate characters and values. Use the Format Cellsand ...

444 Chapter 14 Electronic Spreadsheets To carry out the matrix multiplication, first type [A][B]in cell A18, as shown. Then pi ...

14.7 Matrix Computation with Excel 445 The formulation of many engineering problems leads to a system of algebraic equations. As ...

In cell A10, type [A]  1 , and using the left mouse button, pick cells B9 through D11 as shown. 446 Chapter 14 Electronic Sp ...

14.7 Matrix Computation with Excel 447 Type the information shown in cells A14, B13 through B15, C14, D14, and E14, as shown in ...

14.8 Curve Fitting with Excel Curve fitting deals with finding an equation that best fits a set of data. There are a number of t ...

14.8 Curve Fitting with Excel 449 After you press close, you should see the equation y 0.5542x on the chart, as shown in Figure ...

450 Chapter 14 Electronic Spreadsheets Load (N) 25 20 15 10 5 0 0 10203040 Deflection (mm) y  0.5542 x ■Figure 14.16 The linear ...

14.8 Curve Fitting with Excel 451 good the fit is.R 2 1 indicates perfect fit, andR 2 values that are near zero indicate extrem ...

452 Chapter 14 Electronic Spreadsheets Y 2.50 2.00 1.50 1.00 0.50 0.00 0.50 0.000.50 1.001.50 2.00 2.503.00 3.50 X y  x^2  3x ...

Problems 453 Problems 14.1. Using the Excel Helpmenu, discuss how the following functions are used. Create a simple example and ...

454 Chapter 14 Electronic Spreadsheets 14.9. Using Excel, create a table that shows the relationship between the units of pressu ...

Problems 455 of 15 m/s V35 m/s, and change the air density range of 1.11 kg /m 3 r1.29 kg /m 3 . The given air density range ...

456 Chapter 14 Electronic Spreadsheets where Ddiameter of equivalent circular duct ( mm) adimension of one side of the rectang ...

Problems 457 Problem 14.18 where WCIwindchill index (kcal /m 2 h) Vwind speed ( m/s) Taambient air temperature (C) and the v ...

458 Chapter 14 Electronic Spreadsheets 14.21. Use Excel to plot the following data. Use two different yaxes. Use a scale of zero ...

Problems 459 x 0123 4 5678910 y 10 12 15 19 23 25 27 32 34 36 41 x 012345678 y 5 8 15 32 65 120 203 320 477 x 0 5 10 15 20 25 30 ...

M ATLAB ® is a mathe- matical software that can be used to solve a wide range of engineering problems. Before the intro- duction ...

462 Chapter 15 MATLAB In this chapter, we will discuss the use of MATL AB in solving engineering problems. MATL AB is a mathemat ...