Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / February 2006

Tip: Looking for answers? Try searching our database.

How Do I create a table in excel that shows frequency?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
petlesbian - 08 Feb 2006 23:15 GMT
Working on an assignment for school and I can't find the right function/table
to show me how to create a table showing frequency and relative frequency.
Bernard Liengme - 09 Feb 2006 17:14 GMT
Suppose your data is in A1:A100 and has values in range 0 to 100
1) In C1:C10 enter 10,20, 30...100  This is called the BIN
2) Select D1:D10, type =FREQUENCY(A1:A100, C1:C10, and press
SHIFT+CTRL+ENTER
If all your numbers are the same or you just get value in D1 you did not
follow instructions!
Now you have the frequency data: D1 is count of data in A1:A100 that is 10
or less; D2 is count for 11 to 20
3) In E1 enter =D1/COUNT($A$1:$A$1000); format as %; copy down the column to
E10
Now you have relative frequency

I want 1/2 of the grade we get for the assignment!
Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> Working on an assignment for school and I can't find the right
> function/table
> to show me how to create a table showing frequency and relative frequency.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.