Reply to topic  [ 2 posts ] 
Easy excel question... 
Author Message
Occasionally has a life
User avatar

Joined: Fri Apr 24, 2009 6:33 pm
Posts: 491
Location: UK, England.
Reply with quote
Having not used excel for ages I seem to have an amazing ability to forget the simplest of things.

I have a data set (C3:C43) I have got mean, media and mode from these. How do I get the range of values?

Thanks,

Hobgob.

_________________
Twitter: AdamW89
Flickr: The Hobgob

Nietzsche wrote:
Insanity in individuals is something rare - but in groups, parties, nations and epochs, it is the rule.


Thu Apr 08, 2010 1:11 pm
Profile
Occasionally has a life
User avatar

Joined: Fri Apr 24, 2009 6:33 pm
Posts: 491
Location: UK, England.
Reply with quote
Never mind, my dumbness has worn off.

=MAX(C3:C43) - MIN(C3:C43)

_________________
Twitter: AdamW89
Flickr: The Hobgob

Nietzsche wrote:
Insanity in individuals is something rare - but in groups, parties, nations and epochs, it is the rule.


Thu Apr 08, 2010 1:25 pm
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 2 posts ] 

Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group
Designed by ST Software.