Exponential TrendLine

Inflation modelling for probabilistic analysis has to deal with the properties of inflation datasets. These datasets follow an exponential trendline, with a heteroskedastic deviation. Furthermore, the dataset has positive serial autocorrelation and some indexes, like gasoil and bitumen, are strongly positively correlated. These properties are included with a modelling technique used in the field of econometrics, named ARIMA-modelling. 

Figure 2.4 Graph created with Microsoft Excel showing the concentrations of DDT in trout from Lake Michigan (see the above table) as a function of time and showing a fitted exponential line (using the TrendLine feature). The negative exponent is the rate constant.

Strategy. Let us just plot the raw data in Excel and use the TrendLine feature to fit an exponential line. Be sure to turn on the optional show equation and correlation coefficients feature. We get the plot shown in Figure 2.5. 

Fig. 5 Coupling constants J(P-P) versus the P-P distances for o-n pnicogen bonds in H2XP PCX conformations B red square) and C (green triangle) and H2C=(X)P PXH2 conformation C (blue diamond). The symbol circle includes all complexes for which the best-fit trendline is an exponential...

---