Question

exel questions:
Create a table with 100 random numbers.
Min and Max value of random numbers have to
in the 2 to 4 area. (it mean B to E on my picture?)
Determine the Min-,Max- and the average value.

Answer 1

I generate the 100 and now what I must to with 2 and 4 area?

Answer 2

please area 4 is D

Answer 3

Ok that mean I must for example =Max(2-4) ?

Answer 4

I think that we can use some functions of Microsoft Excel, I'm searching for them

Answer 5

ok

Answer 6

I checked, and I say that we can use the function "mean" of Microsoft Excel

Answer 7

The function "mean" gives us the arithmetic average

Answer 8

ok but only I chose B-D or all numbers?

Answer 9

I think if you want to compute the average of all your numbers, you have to select all of your numbers.
Whereas if you want the average of the numbers in column B only, of course you have to select the numbers of column B

Answer 10

Ok only this waht I must do here ?
Min and Max value of random numbers have to
in the 2 to 4 area

Answer 11

please, if you want to compute the average of all of your numbers, you have to re-write them into a unique column

Answer 12

Also for Max and Min there are two function available on Microsoft Excel

Answer 13

I think that your problem is that you have to rearrange your numbers in one column, not among ten column

Answer 14

oops..among ten columns...

Answer 15

Ok I must generate 100 numer in one columms?

Answer 16

Ok I do it...thx