Modelfitting using logarithms: It is possible, and sometimes useful, to fit models to the logarithms of the output values in a dataset, rather than to the output values themselves. For example, a linear model might be fit to the logarithm of data that has an exponential pattern. When this is done using minimization tools such as Solver, however, note that what is minimized is the standard deviation of the logarithms, not of the original values. In the case of logarithms, this has the same effect as minimizing relative standard deviation.
Loglog graphs: In situations where all x and y values are positive but there is a large dynamic range for both variables, it can help to use the logarithms of x values as well as for y values. A graph where this is done is called a “loglog” graph. On loglog graphs, straight lines indicate powerfunction relationships (in contrast to the exponential relationship indicated by straight lines on semilog graphs). The slope of the line (0.5 on the graph of logarithms, below center) matches the power parameter in the model, and the intercept of the line (1.44 below) is the logarithm of the scale parameter 27.3.
Example 8: Use loglog graphs of each of these two datasets to determine whether their data follows a powerfunction pattern. Show Answer



Using other functions of the output values: There are some situations in which it is convenient to apply other functions to the y data so that the result is close to a straight line. For example, the power function y = x^{2} can be made linear by taking the square root of the y values. This tactic was used more often before computers were widely available to fit nonlinear formulas, but such “linerarizations” are still used in some areas because people are very good at judging the straightness of lines and at using linear graphs for interpolation and extrapolation. You can tell when an axis has been transformed in this way because the gridlines of the graph will be nonuniform in spacing, like those of semilog graphs.