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

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  2

R^2  1

TABLE 14.11 The Comparison between Actual

and PredictedyValues

Actual Predicted value ofy

X Y usingyx

2

 3 x 2

0.00 2.00 2.00

0.50 0.75 0.75

1.00 0.00 0.00

1.50 0.25 0.25

2.00 0.00 0.00

2.50 0.75 0.75

3.00 2.00 2.00

■Figure 14.20 The results for Example 14.11.

Summary

Now that you have reached this point in the text

• You should know that a spreadsheet is a tool that can be used to solve an engineering prob-
  lem. Spreadsheets are commonly used to record, organize, and analyze data using formulas.
  Moreover, you can use a spreadsheet such as Excel to present the results of an analysis in
  chart form. You can input your own formulas or use the built-in functions provided by the
  spreadsheet.


• You should know how to move around in a workbook and input data into different cells. You
  should also know how to edit the content of a cell.


• You should know how to select multiple cells and create a range. You should also realize that
  you can name a range and use the name in your formulas or in plotting data.


• You should understand how to refer to a cell by its address. You should also know the dif-
  ferences among a cell’s relative address, absolute address, and mixed address, and remember
  to use the proper address when creating formulas.


• You should be familiar with Excel’s built-in functions.


• You should know how to insert cells, columns, and rows in an existing worksheet.


• You should know how to create a proper engineering chart using Excel.


• You should know how to perform matrix operations with Excel.


• You should know how to perform curve fitting with Excel.

Copyright 2010 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).

圀圀圀⸀夀䄀娀䐀䄀一倀刀䔀匀匀⸀䌀伀䴀圀圀圀⸀夀䄀娀䐀䄀一倀刀䔀匀匀⸀䌀伀䴀