mean of a row

[Guest]

I need to find the sample mean of a row in a1:d1 and I have 1000
values/columns and it is impossible to find the information for all of them
one by one. I need to find the values and place them in the column E. my
teacher showed the class how to copy and paste the formula from the first row
=average(A11) and he said that we need to highlight the row and press
enter. he said that the computer will know what to do. please help me, i need
this by wed.

 

[Myrna Larson]

Assumng your data is in A11000, and you want the average for each row,

select E1:E1000 (that's 1000 cells), assuming E1 is the active cell, type
=AVERAGE(A11) and press CTRL+ENTER.

Or, assuming there are no blanks in column D, type the formula in E1 and press
Enter. Select E1 again if necessary, then double-click the fill handle, the
little black square in the lower right corner of cell E1.

If there ARE blanks in column D, the 2nd technic will stop copying the formula
just above the first blank.

 

[Guest]

I'm not quite sure if I follow what you're trying to do. However, it sounds
like you have 1000 rows, and each row has 4 fixed values residing in columns
A, B, C, & D. In column E, you need to calculate the average for each of
those 1000 rows. Cell E1 already contains the formula, =AVERAGE(A11).
You need to copy that formula from cell E1, & paste it to cells E2:E1000.
Finally, you need to paste that formula using the Enter key method.

If that's what you are trying to do, then follow these instructions:

- Select Cell E1
- Copy Cell E1 (click the Copy button, or simultaneously press the Ctrl &
"C" keys)
- Select Cell E2
- Press the Shift key and hold it down
- Press the Page Down key until you are at or near row 1000, cell E1000
(keep pressing the shift key)
- Once you are close to row 1000, you can use the up or down arrow keys to
exactly select row 1000 (keep pressing the shift key)
- Once you have E2:E1000 selected, release the Shift key
- Press the Enter key
- The formula in cell E1 is copied to all the cells that were selected

There also an easier way to do this:

- Select Cell E1 that contains the existing formula.
- There will be a thick black border around cell E1 when you select it.
- In the lower right corner of that border, there will be a very small
black square.
- Move your mouse so the pointer is right on top of that small black
square. You will know you are on top of it because the mouse pointer
changes from a fat white cross to a skinny black cross.
- With that skinny black cross, double click that small black square.
- The formula in cell E1 is automatically copied down the column to the
last row that contains a value in column D.

Good luck.