How to use an exponential curve to fit thedata under Excel 2008 for Mac?

[hajime]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello. I am using Excel 2008 for Mac. I plotted the data using a Scratter plot and it looks like an exponential curve could fit the data. Could anybody please tell me how to do that? Is there an index which indicates how accurate it is to use the exponential curve to fit the data? Thanks.

 

[Mike Middleton]

hajime -

Click a single point on the XY (Scatter) chart to select the data series.
Then choose Chart | Add Trendline | Type | Exponential and Options |
"Display equation on chart" and Options | "Display R-squared value on
chart," and click OK.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello. I am using Excel 2008 for Mac. I plotted the data using a Scratter
plot and it looks like an exponential curve could fit the data. Could anybody
please tell me how to do that? Is there an index which indicates how accurate
it is to use the exponential curve to fit the data? Thanks.

See the "Predict data trends" topic in XL Help ("Display the trend
series by using a trendline in a chart" subtopic)

Among the trendline options is one to display the R-squared value.

You can get more information using LOGEST on the data.