Business Statistics

544 Business Statistics

FIGURE 15.56

Minitab output for

Example 15.5 (after log

transformation)

FIGURE 15.55

Minitab output for

Example 15.5 (before log

transformation)

15.13.6 Using MS Excel for Log Transformation

To create transformed variables, we need to create columns of variables with natural logarithm. This

can be done by inserting a simple formula in the form =LN (cell) as shown in Figure 15.57. Using

this formula, the first log sales value will be created in cell C2 as shown in Figure 15.57. Then by

dragging log sales value for each corresponding sales cell, all the log sales values will be created

(Figure 15.57). The remaining procedure ...