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

(Steven Felgate) #1

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 14.16. We have edited the variables of the equation to reflect the experimental variables
as shown in Figure 14.17.
To edit the equation, left-click on the equation (y 0.5542x) and change it to read
F 0.5542 x, where F load (N), and x deflection ( mm), as shown in Figure 14.17.

■Figure 14.15 The Format Trendline dialog box—Type.


■Figure 14.14 Add Trendline....


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).

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

Free download pdf