The first step in an exponential fit analysis is to find one point that must lie on the best fitting curve to the data. To do this we need to do a linear transformation to the population data. Here's how.
An initial guess for this point might be the mean data point since this point would fall on the best fitting line in a linear analysis.
(Note: If you unsure of what the mean of a list of numbers is, click here,
The Mean, to learn more).
In the spreadsheet, double click on the graph.
What happened was that the population data was plotted on a lograthimic scale where its values have been changed to its natural log. Since this looks like a straight line, we can use the mean data point of this graph as the bestfitting point.
In the spreadsheet, find the natural log of the population data (column D).
Find the sum (cell D23) and the mean (cell D24) of this list.
This point fits well to our data since the population data has been transformed by taking the natural log. How can we "untransform" this point?
Well, since the data was transformed by the natural log, the inverse of the natural log is the exponential. So, if we find the exponential of the mean, we can "untransform" this point to our actual data.
Do this in the spreadsheet in cell D25.
Look at this plot.
This is a plot of the years and regular population data and the point is the values from cells B24 and D26.
Do you think this point fits the best fitting curve reasonably well?
We can also show that this point must be on the best fitting curve analytically. Click here to see how.
1.) Decide if the following plots of data should be represented by an exponential fit or a linear fit and explain why!
a.) This is the plot of the Dow Jones Industrial Average for every third year from 1930 to 1990. The year 1930 is designated year 0.
This data was found on the Internet at http://www.geom.umn.edu/docs/snell/chance/teaching_aids/data_sets.html It contains the Dow Jones Average on the first trading day of the year from 19301992.
b.) This is a plot of the diameters and circumference of various objects.
Data taken from Using Statistics by Travers, Stout, Swift and Sextro, published by AddisonWesley, p. 179.
c.) A radioactive element is one that is unstable and decays into other more stable elements. This is a plot of the amounts of Polonium, a radioactive element, at times recorded every 50 days.
2.) Take a look at the Dow Jones data from the previous question.


Download this Dow Jones Excel Spreadsheet.
Find the point that must fall on the best fitting curve of this data.
3.) Here is the data for the radioactive element.
TIME (days)  AMOUNT (mg) 

0  100 
50  76 
100  62 
150  47 
200  37 
250  29 
300  21 
350  17 
Download this Polonium Excel Spreadsheet.
Find a point that must fall on the best fitting curve of this data.