• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Behavior of the average function!?

herclau

Member
I need your comments and help.
I don't understand the behavior of the average function in this example. values of cells H6: I6. H6: mean of the random array values B4: B38; I6: the same arrangement but sort from least to greatest.

64618
 

Attachments

  • Average Mean.xlsx
    12.5 KB · Views: 3
herclau
What won't You understand?
eg cell B38 ... where is that value in C-column?
if sums of B- & C-columns are different ... aren't averages also different?
 
Hi ,

The formulas in the range C4:C38 are not all identical ; the range used in the first 33 formulas is $B$4:$B$37 , while that in the last 2 formulas is $B$4:$B$38.

If you correct the first 33 formulas so that they also refer to the range $B$4:$B$38 , then the two averages will be identical.

Narayan
 
Hi ,

The formulas in the range C4:C38 are not all identical ; the range used in the first 33 formulas is $B$4:$B$37 , while that in the last 2 formulas is $B$4:$B$38.

If you correct the first 33 formulas so that they also refer to the range $B$4:$B$38 , then the two averages will be identical.

Narayan
39/5000



Thank you both for your comments.
 
Back
Top