Which @function finds the mean of a number?

[Coffeecoco930]

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.

 

[Frank Kabel]

Hi
=AVERAGE(A1:A100)

 

[JE McGimpsey]

One way:

Mean: =AVERAGE(A1:A10)
Range: =MAX(A1:A10)-MIN(A1:A10)

 

[Coffeecoco930]

Hello JE McGimpsey,

Thank you very much. You have been most helpful. I received one other
reply also. I have made a note in my notebook as a reference to refer back
to.

J E Barrigher

 

[Coffeecoco930]

Hello Frank Kabel

Thank you very much. I have place a note in my notebook as a reference I
can refer back to.

Joan

 

[Dana DeLouis]

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