Home | Community | Message Board


Everything Mushrooms
Please support our sponsors.

Community >> The Pub

Welcome to the Shroomery Message Board! You are experiencing a small sample of what the site has to offer. Please login or register to post messages and view our exclusive members-only content. You'll gain access to additional forums, file attachments, board customizations, encrypted private messages, and much more!

Jump to first unread post. Pages: 1
Offlinewillmafingerdo
the noob
Male User Gallery

Registered: 02/08/05
Posts: 1,103
Last seen: 3 years, 24 days
i need some help with a excel function, could anyone help me out?
    #6498757 - 01/26/07 12:37 PM (14 years, 3 months ago)

i have a group of 100 #'ers and i need to know the frequency distribution of the nubers for 20-24, 25-29, 30-34,....55-59 i used =FREQUENCY(A1:J10,B27:B34) and it gave me
frequency
24 7
29 35
34 48
39 50
44 52
49 43
54 38
59 30
the problem is that it is checking all the numbers instead of the numbers in the ranges i need like 20-24, i tried putting it into excell 20-24 but it comes up with some weird umbers. if this make no sense let me know ill try to explain it better. if your wondering why im doing this its for my business stats class.. any help is apriciated.

ty
will


--------------------
:scaryshroom: :shitstorm: :mattz: :bongload: :gethigh: :scaryshroom:

I am not lost.. i am going there looking for it.. and when i get there and find it, i will know what it is..

"The way to stop violence is not to go out and let your head be beaten in but to say, you want to take my life risk yours!"

"are you sure u want to eat all them shrooms??"  "yes i want to hear what my mind has to say..."

remember opions are like assholes, everyone has one and they all stink.


Post Extras: Filter  Print Post  Remind Me! Notify Moderator
Jump to top. Pages: 1

Community >> The Pub

Similar ThreadsPosterViewsRepliesLast post
* Strange Birds. Excellent Birds. PapaverS 1,007 10 06/23/04 10:23 PM
by Papaver
* Excellent Article on Mushrooms on front page of CNN.com!
( 1 2 all )
OneMoreRobot3021 4,507 34 11/07/06 09:58 PM
by HB
* excel help please
( 1 2 all )
LethalX5 1,765 31 09/11/05 01:08 PM
by InsatiableThirst
* Sorry, the Search Function is temporarily disabled. djfrog 831 4 12/18/03 02:48 PM
by Papaver
* Microsoft Excel help endokrin 409 1 04/28/05 06:35 PM
by afoaf
* Is it possible to make a functioning lightsaber?
RandalFlagg
1,071 7 06/10/05 10:25 AM
by Rono
* The Search function Jeebies 570 6 09/11/07 01:08 AM
by Gratos
* muslims make excelent hash! Simisu 741 6 08/02/06 01:17 PM
by detergent

Extra information
You cannot start new topics / You cannot reply to topics
HTML is disabled / BBCode is enabled
Moderator: Entire Staff
256 topic views. 3 members, 8 guests and 68 web crawlers are browsing this forum.
[ Print Topic ]
Search this thread:
North Spore
Please support our sponsors.

Copyright 1997-2021 Mind Media. Some rights reserved.

Generated in 0.021 seconds spending 0.009 seconds on 15 queries.