The cell referencing shifts when you copy in Excel. So, if, for example, you copied cell C8 that contains the equation =AVERAGE(C3:C4), and pasted this into C9, the equation would shift down one row to read =AVERAGE(C4:C5). Since we copy two rows down it changes to AVERAGE(C5:C6), which matches where the replicate data is located. Extra info: If you want to lock cell referencing, you can use the $ symbol. By typing =AVERAGE($C$4:$C$5), this would keep the equation referencing cells C4 to C5 regardless of where you copied it. You can also lock just the column ($C4) or just the row (C$4), depending on your needs.
@@rebeccaong2820 Good to know! At first for time 0 I tried to do my 3 replicates and then copy all the code across, however, it didn't give me averages (I didn't have a gap, I just had all averages stacked together hence why I asked)
Excellent presentation🎉. Much appreciated...
Extremely helpful and well put. Thank you!
It helped me way more I have thought I would really appreciate
very precise and well explained. thanks much
"There's a space here so it will do our averages automatically" What do you mean by that?
The cell referencing shifts when you copy in Excel. So, if, for example, you copied cell C8 that contains the equation =AVERAGE(C3:C4), and pasted this into C9, the equation would shift down one row to read =AVERAGE(C4:C5). Since we copy two rows down it changes to AVERAGE(C5:C6), which matches where the replicate data is located.
Extra info: If you want to lock cell referencing, you can use the $ symbol. By typing =AVERAGE($C$4:$C$5), this would keep the equation referencing cells C4 to C5 regardless of where you copied it. You can also lock just the column ($C4) or just the row (C$4), depending on your needs.
@@rebeccaong2820 Good to know! At first for time 0 I tried to do my 3 replicates and then copy all the code across, however, it didn't give me averages (I didn't have a gap, I just had all averages stacked together hence why I asked)