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