This should get you started:

=AVERAGE(A1:A5)
=MIN(A1:A5)
=MAX(A1:A5)

Or perhaps a quick check with the Analysis Tool pak installed...

Tools | Data Analysis | "Descriptive Statistics"

HTH
--
Dana DeLouis
Win XP & Office 2003


"Coffeecoco930" wrote in message
...
I need to check my grandson's homework. it has been a while since I've
done
statistics. I need to know which @function finds the mean and range of a
number or list of numbers. Need information as soon as possible.
--
Coffeecoco