|
4.13.5Exponential Trend line
An exponential trend line, which looks like a smoothly curving line, is most useful when graphed data values change at an ever increasing or decreasing rate. An exponential trend line cannot be created if data contains zero or negative values.
Example: Number of automobiles used in world for the last 5 years
(4).png)
EXAMPLE OF AN EXPONENTIAL TREND LINE FOR ALCOHOLIC DRINKS
How does exponential trend line compute?
An exponential trend line by using the following equation to calculate the least squares fit through points:
y = cebx
where c and b are constants, and e is the base of the natural logarithm.
Guidelines:
Very practical for increase or decrease at accelerating or decelerating rates of graph data
Cannot be used when any of your data points are zero or negative
|