Microsoft Office Tutorials and References
In Depth Information
CORREL
in various cities. After you calculate CONFIDENCE you subtract the result from the mean to get
the low inter val and add the result to the mean to get the high inter val.
Is the significance level used to determine the confidence level. The
confidence level equals 1-alpha (shown as a percentage). If alpha
(the significance level) is .1, then the confidence level is 90%. Typical
confidence levels are 90%, 95%, and 99%.
ALPHA
Is the standard deviation for the data set.
STANDARD_DEV
Is the the sample size.
SIZE
Figure 11.6
Though not part of the
CONFIDENCE function,
you need to calculate
the mean, using the
AVERAGE function.
CORREL
CORREL returns the correlation coefficient between two data sets.
=CORREL(array1,array2)
The CORREL function is used to determine the relationship between two variables. For
example, in Figure 11.7, the correlation between the monthly average temperature and the monthly
average water usage (in gallons) is 0.954163749.
The value of the correlation coefficient always lies between –1 and +1. A correlation
coefficient close to +1 indicates a positive correlation, as one variable increases, the other variable
increases. A correlation coefficient close to –1 indicates a negative correlation, as one variable
increases, the other variable decreases. A correlation coefficient close to zero (0) indicates
there is little or no correlation between the variables.
Is the first set of values; can be a cell range, range name, or array.
ARRAY1
Is the second set of values; can be a cell range, range name, or array.
ARRAY2
Search JabSto ::

Custom Search