Average function not returning expected result
 

Hi all:

I have a column of 25 numbers that include zeros that total 74. I have
applied the average function and rounded the result to two decimal places.

ROUND(AVERAGE (number 1,number 2...),2).

The result that I am receiving from excel is 2.64. When I use a calculator
the result is 2.96. What am I doing wrong?


--
Thanks,
Greg

Average function not returning expected result
 

Are you trying to average all of the values or all of the non-zero values???
Average will include the zeros...
--
HTH...

Jim Thomlinson


"gja63" wrote:

Hi all:

I have a column of 25 numbers that include zeros that total 74. I have
applied the average function and rounded the result to two decimal places.

ROUND(AVERAGE (number 1,number 2...),2).

The result that I am receiving from excel is 2.64. When I use a calculator
the result is 2.96. What am I doing wrong?


--
Thanks,
Greg

Average function not returning expected result
 

I am averaging all the numbers including the zeros. My concern is that 74/25
is 2.96, but Excel return 2.64 as the result
--
Thanks,
Greg


"Jim Thomlinson" wrote:

Are you trying to average all of the values or all of the non-zero values???
Average will include the zeros...
--
HTH...

Jim Thomlinson


"gja63" wrote:

Hi all:

I have a column of 25 numbers that include zeros that total 74. I have
applied the average function and rounded the result to two decimal places.

ROUND(AVERAGE (number 1,number 2...),2).

The result that I am receiving from excel is 2.64. When I use a calculator
the result is 2.96. What am I doing wrong?


--
Thanks,
Greg

Average function not returning expected result
 

You're going to need to show us the exact formula, and the numbers involved.
Are you sure that you haven't got some of the cells as text rather than
numbers? What do you see if you temporarily change the formula from
=ROUND(AVERAGE (number 1,number 2...),2) to
=SUM(number 1,number 2...)?
--
David Biddulph

"gja63" wrote in message
...
I am averaging all the numbers including the zeros. My concern is that
74/25
is 2.96, but Excel return 2.64 as the result
--
Thanks,
Greg


"Jim Thomlinson" wrote:

Are you trying to average all of the values or all of the non-zero
values???
Average will include the zeros...
--
HTH...

Jim Thomlinson


"gja63" wrote:

Hi all:

I have a column of 25 numbers that include zeros that total 74. I have
applied the average function and rounded the result to two decimal
places.

ROUND(AVERAGE (number 1,number 2...),2).

The result that I am receiving from excel is 2.64. When I use a
calculator
the result is 2.96. What am I doing wrong?


--
Thanks,
Greg

Average function not returning expected result
 

Thanks to all that replied. I figured out my problem, I was including a
figure in the calculation that was not supposed to be included throwing
everything off.
--
Thanks,
Greg


"David Biddulph" wrote:

You're going to need to show us the exact formula, and the numbers involved.
Are you sure that you haven't got some of the cells as text rather than
numbers? What do you see if you temporarily change the formula from
=ROUND(AVERAGE (number 1,number 2...),2) to
=SUM(number 1,number 2...)?
--
David Biddulph

"gja63" wrote in message
...
I am averaging all the numbers including the zeros. My concern is that
74/25
is 2.96, but Excel return 2.64 as the result
--
Thanks,
Greg


"Jim Thomlinson" wrote:

Are you trying to average all of the values or all of the non-zero
values???
Average will include the zeros...
--
HTH...

Jim Thomlinson


"gja63" wrote:

Hi all:

I have a column of 25 numbers that include zeros that total 74. I have
applied the average function and rounded the result to two decimal
places.

ROUND(AVERAGE (number 1,number 2...),2).

The result that I am receiving from excel is 2.64. When I use a
calculator
the result is 2.96. What am I doing wrong?


--
Thanks,
Greg