Section 8.4. Trigonometry and Advanced Math

8.4. Trigonometry and Advanced Math

Trigonometry is sometimes described as the science of circles and angles. It's trigonometry that helps you calculate the hypotenuse of a triangle or the diameter of a circle. However, when you use trigonometry in Excel, you probably won't be worrying about shapes ; instead, you'll be using some type of formula from a scientific field that requires common trigonometric calculations like the cosine or tangent.

Students of the sciences know that trigonometry turns up anywhere you need to think about space, including geography, astronomy, kinematics, and optics. Less direct applications of trigonometry turn up in just about every other scientific fieldfrom chemistry to social science.

Excel's trigonometric functions are quite easy to use. You simply choose the formula you need and the appropriate argument, much as you would use a pocket calculator. (Knowing when to use these trigonometry functions is another issue, and it may require a refresher course in mathematics.) Table 8-1 lists the functions you can use. And Figure 8-8 shows how you can use trigonometry to solve a common high school math problem: you have the distance to a tree (which you can easily measure), and the angle between your current position and the top of the tree (which you can estimate). The problem is you have no way to judge the height of the tree.

Table 8-1. Trigonometry Functions

Function

Syntax

Description

ACOS( )

ACOS(number)

Calculates the inverse cosine (also known as the arccosine ) of a number.

ACOSH( )

ACOSH(number)

Calculates the inverse hyperbolic cosine of a number.

ASIN( )

ASIN(number)

Calculates the inverse sine (also known as the arcsine) of a number.

ATAN( )

ATAN(number)

Calculates the inverse tangent (also known as the arctangent) of a number.

ATAN2( )

ATAN2(x, y)

Calculates the inverse cosine (also known as the arccosine), given the x and y coordinates.

ATANH( )

ATANH(number)

Calculates the inverse hyperbolic tangent of a number.

COS( )

COS(angle)

Calculates the cosine of an angle.

COSH( )

COSH(angle)

Calculates the hyperbolic cosine of an angle.

DEGREES( )

DEGREES(angle)

Converts an angle in radians into degrees. 360 degrees equals 2 p radians.

EXP( )

EXP(power)

Calculates e (the natural logarithm constant), raised to the power you specify.

LN( )

LN(number)

Calculates the natural logarithm of a number (which is the logarithm with the base of e ).

LOG( )

LOG(number, base)

Calculates the logarithm of a number with the base you specify.

LOG10( )

LOG10(number)

Calculates the base 10 logarithm of a number.

PI( )

PI( )

Returns the mathematical constant pi ( p ), which is approximately 3.14.

RADIANS( )

RADIANS(degrees)

Converts an angle in degrees into an angle in radians. 360 degrees equals 2 p radians.

SIN( )

SIN(angle)

Calculates the sine of an angle.

SINH( )

SINH(angle)

Calculates the hyperbolic sine of an angle.

TAN( )

TAN(angle)

Calculates the tangent of an angle.

TAHNH( )

TAHNH(angle)

Calculates the hyperbolic tangent of an angle.


Figure 8-8. The solution to this problem is to use the trigonometric identity tan = h/x. You can rearrange this formula to find h (the height of the tree) so that h = x*tan. Be aware that Excel calculates the tangent using radians (radians are a measure of an angle, like degrees). Fortunately, Excel provides a RADIANS( ) function for converting degrees into radians, as well as a DEGREES( ) function for converting radians into degrees. In this example, the RADIANS( ) function was first used to convert degrees into radians; that result was then used as the argument in the TAN( ) function. The image was inserted using the Insert Picture command, which youll learn about in Chapter 18.


In addition to its trigonometric functions, Excel also includes a number of specialized mathematical functions, such as those used with matrices. These functions are summarized in Table 8-2.

Table 8-2. Miscellaneous Math Functions

Function

Syntax

Description

FACTDOUBLE( )

FACTDOUBLE(number)

Calculates the double factorial of a number. The double factorial is similar to a factorial, but it skips every second number. Thus, 5!! is 5*3*1 (whereas 5! is 5*4*3*2*1).

MDETERM( )

MDETERM(range)

Calculates the determinant of a matrix.

MINVERSE( )

MINVERSE(range)

Returns the inverse of a matrix. This is an array function that returns multiple results.

MMULT( )

MMULT(range1, range2)

Returns the product of multiplying two matrixes . This is an array function that returns multiple results.

MULTINOMIAL( )

MULTINOMIAL(range)

Returns the multinomial of a set of numbers . The multinomial is the ratio of the factorial of a sum of values to the product of factorials.

ROMAN( )

ROMAN(number, [form])

A bizarre function that converts an ordinary number (from 1 to 3999) into Roman numerals. For example, ROMAN(4) returns the text IV . Large Roman numerals can be very confusing, so you can use the optional form argument to tell Excel to simplify the Roman numeral by applying a kind of rounding off effect. Form can range from 0 (which generates the unrounded Roman numeral) to 4 (which generates a much shorter but slightly less precise version). Search Excel's Help for ROMAN for a complete explanation.

SERIESSUM( )

SERIESSUM(x, n, m, co)

Calculates the sum of a power series, where x is the base of the power series, n is the initial power to raise x to, m is the increment to the power for each term in the series, and co are the coefficients by which each successive power of x is multiplied. For more gory mathematical details, check out a detailed example of the series formula in Excel's function reference (choose Insert Function, find the function, and click the "Help on this function" link).

SQRTPI( )

SQRTPI(number)

Multiplies a number by pi ( p ), and then calculates the square root of the result.




Excel. The Missing Manual
Excel 2010: The Missing Manual
ISBN: 1449382355
EAN: 2147483647
Year: 2003
Pages: 185

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net