ñòð. 44 |

Conversely,

exp (4.45) = e^ (4.45) =

2.718^ (4.45) = 85.

Exponential This function calculates the One positive real

MATH /EXP

exponential to a number. number.

LOG10 (X)

This function calculates the

base 10 logarithm of a

number.

LOG10 (85) = 1.934 MATH ï€ /LOG10

Log to the One positive real

because the base of 10

number.

base 10 needs to be raised 1.934

times to get 85:

101.934 = 85

LOG10 (10) = 1 because

101 = 10

LOG10 (1000) = 3 because

103 = 1000

153

Statistical Analysis with Excel

Location within

Function Description INSERT Data Requirements

/FUNCTION

This function calculates the

logarithm of a number to

the base you specify. The

default base is 10. For

natural log use base e =

2.718.

A positive real

number X and the

Log to a user LOG (X, base)

MATHï€ /LOG. (optional) base of

defined base the logarithm.

LOG (100) = 2 base 10. If base is omitted,

(Since 102 = 100).

it is assumed = 10.

LOG (27, 3) = 3 base 3.

(Since 33 = 27).

LOG (86, 2.7182818) = 4.45

same as natural log.

Becauseâ€” (exp (4.45) = 85).

Standardizing a series that follows a Normal Density Function

Converts a value in a series X to its equivalent standard normal

transformation.

STANDARDIZE (x, AVERAGE (X), STDEV (X)) where X is all the numbers

in the X data series.

Menu path to function:

INSERT/FUNCTION/STATISTICAL/STANDARDIZE.

Data requirement: The function requires three input numbers: x, mean of

the X series, and the standard deviation of the X series. The mean and

standard deviation can be written as a â€œfunction within a function.â€

154

Chapter 8: Other Mathematics & Statistics Functions

DEVIATIONS FROM THE MEAN

8.4

The formulas in this and the next section provide estimates of functions

used in formulas for parameters obtained in advanced analysis like

ANOVA, Correlation, Regression, etc.

DEVSQ

This function calculates the sum of squares of deviations of data points

from their sample mean

Î£ ((x â€” mean (x))2

Menu path to function: MATH/DEVSQ

Data Requirements: A range(s) of real numbers, inclusive of zero.

Figure 137: Summation of the squares of the â€œdifferences of individual points from the mean of

the seriesâ€

AVEDEV

This function calculates the average of the absolute deviations of data

points from their mean. AVEDEV is a measure of the variability in a data

set.

155

Statistical Analysis with Excel

Menu path to function: STATISTICAL/AVEDEV

Menu path to function: A range(s) of real numbers, inclusive of zero.

CROSS SERIES RELATIONS

8.5

ñòð. 44 |