Simple Statistical Excel Functions and Formulas

Let's say I have two columns of numbers (5 in each column).
1/ Pls. advise of the following functions' FORMULA in excell:
percentile
range
rank
weighted average
confidence
correlation
forecast

2/ and elaborate as to WHAT that function is telling me (how is it useful)?

© SolutionLibrary Inc. solutionlibary.com 9836dcf9d7 https://solutionlibrary.com/statistics/descriptive-statistics/simple-statistical-excel-functions-and-formulas-2ej