Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
PEARSON(array1,array2) [Category: Statistical]]
Returns the Pearson product moment correlation coefﬁ cient, r, a dimensionless
index that ranges from -1.0 to 1.0 inclusive and reﬂ ects the extent of a linear
relationship between two data sets. Guru Tip: When the Microsoft MVP’s get
together in Seattle for the annual MVP Summit, only Chip Pearson can claim
that he has an Excel function named after him. If you haven’t done so already,
check out the great articles at cpearson.com.
PERCENTILE(array,k) [Category: Statistical]]
Returns the k-th percentile of values in a range. You can use this function to
establish a threshold of acceptance. For example, you can decide to examine
candidates who score above the 90th percentile. Guru Tip: the second argument
needs to be a percentage or a decimal. Use 0.1 for the 10th percentile. Also be
aware that the percentiles are extrapolated and often will be a number which
does not appear in the data set.
PERCENTRANK(array,x,signiﬁ cance) [Category: Statistical]]
Returns the rank of a value in a data set as a percentage of the data set. This
function can be used to evaluate the relative standing of a value within a data
set. For example, you can use PERCENTRANK to evaluate the standing of an
aptitude test score among all scores for the test. Guru Tip: Unlike RANK, this
function always assumes that the largest score is at the 100th percentile. You

Search JabSto ::

Custom Search