Maths Excel
18 February 2003, 04:54 PM
#1
Scooby Regular
Thread Starter
Join Date: Feb 2002
Location: Lurkin Somewhere
Posts: 7,951
Likes: 0
Received 0 Likes
on
0 Posts
Maths in Excel , sorry
Im quite stuck tbh. I could do thats maths on paper but using
excel is
1st is the mean
ive got =sum(a1:A11)/11
Theres 11 cells data so am i correct by putting 11 should i use some formula for counting cells that contain data?
2nd Median
if i remember the middle point so 1-2-3-4-5
3 being the median?
ive a set 11 numbers to how do i say, excel get me the middle numbers in this coloum data.
If you understand me great, if not sorry
Si
[Edited by super_si - 2/18/2003 4:56:00 PM]
Im quite stuck tbh. I could do thats maths on paper but using
excel is
1st is the mean
ive got =sum(a1:A11)/11
Theres 11 cells data so am i correct by putting 11 should i use some formula for counting cells that contain data?
2nd Median
if i remember the middle point so 1-2-3-4-5
3 being the median?
ive a set 11 numbers to how do i say, excel get me the middle numbers in this coloum data.
If you understand me great, if not sorry
Si
[Edited by super_si - 2/18/2003 4:56:00 PM]
18 February 2003, 04:59 PM
#2
Scooby Regular
Join Date: Mar 2000
Location: Gloucestershire, home of the lawnmower.
Posts: 4,531
Likes: 0
Received 0 Likes
on
0 Posts
1. =AVERAGE(A1:A11) this works even if some cells are empty.
2. =MEDIAN(A1:A5)
If you are not sure how to use these, RTFM.
Cheers
Ian
2. =MEDIAN(A1:A5)
If you are not sure how to use these, RTFM.
Cheers
Ian
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
bluebullet29
General Technical
9
05 October 2015 02:17 PM