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

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 extremely

poor fits. The comparison between the actual and predictedyvalues (using equationy

x

2

 3 x2) is shown in Table 14.11.

TABLE 14.10 A Set

of Data Points

XY

0.00 2.00

0.50 0.75

1.00 0.00

1.50 0.25

2.00 0.00

2.50 0.75

3.00 2.00

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

■Figure 14.18

The XY (Scatter) plot of data points for Example 14.11.

■Figure 14.19 The Add Trendline dialog box—Type.

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

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