# 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)?

© BrainMass Inc. brainmass.com June 3, 2020, 4:44 pm ad1c9bdddfhttps://brainmass.com/statistics/dispersion-and-spread-of-data/simple-statistical-excel-functions-formulas-2515

#### Solution Summary

The solution addresses the function of a formula.

$2.19