I’m sure somebody out there is more knowledgeable in Excel than I am, so here’s something weird that happened on a recent calculus assignment that neither my students nor I have been able to figure out.
The students were sent to this web page and asked to enter the population data into a spreadsheet, rescaling the time variables so that the year 1790 was t = 0, 1800 was t = 10, and so on, up through the year 2000 (t=210). Then they were then asked to make an XY-plot of the data, which looks like this:
Then they were supposed to fit the XY-plot with a linear trendline, order-3 polynomial trendline, and then an exponential trendline. The linear and cubic trendlines are no problem, but when you go to add the exponential trendline, you can’t:
The options for power, log, and exponential are all unavailable. So, why is this? The best guess the students could come up with is that the data plot goes through the point (0,0), and since that never happens for a “pure” exponential function (something of the form y = Ae^(bx)), Excel won’t let you use exponentials. But that doesn’t explain why the power function option wasn’t available.