Excel for Marketing Managers

(Dana P.) #1
Calculation Basics

Calculation
Basics


To raise B6 to the third power, use =B6^3.

The converse problem is trickier. In the following problem, the student would
have to take the cube root of 3375. Excel does not offer a Cube Root function
like the SQRT function for square roots.

Thus, your student is going to have to use the alternative form of =B5^(1/3) in
order to take a cube root. This may be confusing for the student, but it is easier
than figuring out cube roots by hand!

Figure 26
Raising to the third power using a carat

Figure 27
Taking a cube root using a carat and a
fraction
Free download pdf