Ask Question and Get Free Answers - JUST Ask And Answer > QA > Computers & Internet > Software
How to get the mean on excel from 20 random numbers in a row.?

Answers:1   |   LastAnswerAt:2011.03  

Question
visitor
johnson 
Asked at 2011.03.27 23:30:28
You will need the AVERAGE function in your formula, which returns the average (arithmetic mean) of the arguments.

Syntax:
------------
AVERAGE( number1, number2, ... )

Where "number1", "number2", "..." are 1 to 30 numeric arguments for which you want the average.

Remarks:
---------------
• The arguments must either be numbers or be names, arrays, or references that contain numbers.
• If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.

As to having the formula decide which of the 20 random numbers are to be used, that is a lot more involved.

And by the way, there is also a MEDIAN function, which returns the median of the given numbers. The median is the number in the middle of a set of numbers; that is, half the numbers have values that are greater than the median, and half have values that are less.

.
answer Jim Lee  Answered at 2011.03.27 23:30:28
You will need the AVERAGE function in your formula, which returns the average (arithmetic mean) of the arguments.

Syntax:
------------
AVERAGE( number1, number2, ... )

Where "number1", "number2", "..." are 1 to 30 numeric arguments for which you want the average.

Remarks:
---------------
• The arguments must either be numbers or be names, arrays, or references that contain numbers.
• If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.

As to having the formula decide which of the 20 random numbers are to be used, that is a lot more involved.

And by the way, there is also a MEDIAN function, which returns the median of the given numbers. The median is the number in the middle of a set of numbers; that is, half the numbers have values that are greater than the median, and half have values that are less.

.
1
  • Answer This Question:How to get the mean on excel from 20 random numbers in a row.? 

  • insert image

    image url:

    such as: http://www.justaaa.com/**/**.jpg

    insert video

    vedio url: