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

Hi
=AVERAGE(A1:A100)

--
Regards
Frank Kabel
Frankfurt, Germany

"Coffeecoco930" schrieb im
Newsbeitrag ...
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

One way:

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

In article ,
"Coffeecoco930" wrote:

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.

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

"JE McGimpsey" wrote:

One way:

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

In article ,
"Coffeecoco930" wrote:

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.

Hello Frank Kabel

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

Joan

"Frank Kabel" wrote:

Hi
=AVERAGE(A1:A100)

--
Regards
Frank Kabel
Frankfurt, Germany

"Coffeecoco930" schrieb im
Newsbeitrag ...
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

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