Business Statistics

540 Business Statistics

15.13.2 Using MS Excel for Square Root Transformation

MS Excel can be used to obtain the square root transformation of the independent variable as shown

in Figure 15.50. After keying in a new heading as ‘Square root of the batch size’, in column D2,

type in formula = SQRT(C2) and Enter. This will give the square root of the first batch size as shown

in Figure 15.50. Drag this cell to the last cell, square root quantities for all values of the independent

variable will be computed in column D as shown in Figure 15.50.

15.13.3 Using Minitab for Square Root Transformation

For creating a new column as the square root of ...