Average Question

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

Hi, I want to average the top two numbers with each other and then the
next two numbers and so on down the list. The answer would be out to
the right (or wherever) like I've shown in my example.

0.6429
0.6296 .6362
0.6721
0.6970 .6846
0.5370
0.5146 .5258
0.6491
0.6721 .6606
0.7143
0.7500 .7321
0.6296
0.6491 .6394
0.5475
0.5763 .5619

I have no idea how to do this. Probably simple.

Thanks
 
Say 0.6429 and 0.6296 are in cells A1 and A2,

where you have written .6362 enter the formula =AVERAGE(A1:A2) instead of
typing A1:A2 you can highlight the two cells you want to average.

If you then drag this formula down you can just delete it in every 2nd cell
(the ones you don't want it in).
 
Say your data is in A1:Axx

Put this in B2 (the second row of the data):
=average(a1:a2)

Now select B1:B2 (include the top empty cell and the formula cell)

Use the autofill button on the bottom right corner of the selection and drag
down as far as you need to.
 
Back
Top