 |
 |
Idle Banter For non SV and non bike related chat (and the odd bit of humour - but if any post isn't suitable it'll get deleted real quick). There's also a "U" rating so please respect this. Newbies can also say "hello" here too. |
 |
|
|
Thread Tools |
31-03-09, 07:44 PM
|
#1 |
|
Guest
Posts: n/a
|
Excel
How do you find the average (mean etc) on excel? i'm having a blonde moment and i have over 400 data points so dont want to do it manually
merci beaucoup |
|
|
31-03-09, 07:55 PM
|
#2 |
|
Guest
Posts: n/a
|
Re: Excel
=average(A1:A20) or whatever your range is
|
|
|
|
31-03-09, 08:03 PM
|
#3 |
|
Member
Mega Poster
Join Date: Jul 2003
Location: Warwickshire
Posts: 2,802
|
Re: Excel
"Insert", "function", "average"
or similar..............
__________________
"Artificial Intelligence is no match for natural stupidity" |
|
|
|
31-03-09, 08:11 PM
|
#4 |
|
Guest
Posts: n/a
|
Re: Excel
What orose said..
=average(first data point cell reference:last data point cell reference) 
|
|
|
|
31-03-09, 09:30 PM
|
#5 |
|
Guest
Posts: n/a
|
Re: Excel
Or, at the bottom right corner you'll see NUM. right hand click on this and select AVERAGE, then when you highlight the numbers you want, the average will be displayed here.
|
|
|
|
31-03-09, 09:31 PM
|
#6 |
|
Guest
Posts: n/a
|
Re: Excel
The possiblities are endless
|
|
|
|
31-03-09, 09:41 PM
|
#7 |
|
Guest
Posts: n/a
|
Re: Excel
Perhaps we could start an excel question a day, and then all learn a bit more!!
No, ok that's a bit sad! |
|
|
|
31-03-09, 09:45 PM
|
#8 |
|
Guest
Posts: n/a
|
Re: Excel
thanks all, i got pms as well so i now know about 15 ways to do it merci!!
|
|
|
|
31-03-09, 09:52 PM
|
#9 |
|
Member
Mega Poster
Join Date: Jul 2006
Location: Dundee
Posts: 4,413
|
Re: Excel
Hi Graciepants
|
|
|
|
|
31-03-09, 10:02 PM
|
#10 | |
|
Member
Mega Poster
Join Date: Feb 2009
Location: Ruislip
Posts: 1,131
|
Re: Excel
Quote:
|
|
|
|
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel geeks, please... | Filipe M. | Idle Banter | 12 | 28-08-08 10:04 PM |
| Some basic HELP with EXCEL pls | 600+ | Idle Banter | 4 | 02-10-07 01:59 PM |
| Another one for the Excel gurus | Jelster | Idle Banter | 6 | 12-06-07 08:48 AM |
| Excel Question | Tris | Idle Banter | 4 | 04-04-07 11:42 AM |
| Cheapest MS Excel? | Nekkid | Idle Banter | 7 | 22-01-07 03:19 PM |
