Microsoft Office Tutorials and References
In Depth Information
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%.
Is the standard deviation for the data set.
Is the the sample size.
Though not part of the
you need to calculate
the mean, using the
CORREL returns the correlation coefficient between two data sets.
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.
Is the second set of values; can be a cell range, range name, or array.