If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How Do I create a table in excel that shows frequency?
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. |
#2
|
|||
|
|||
How Do I create a table in excel that shows frequency?
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 D110, 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! -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "petlesbian" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | MEGTOM | New Users | 5 | October 27th, 2005 03:06 AM |
Access combo box-show name, not ID, in table? | write on | New Users | 30 | April 30th, 2005 09:11 PM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
reset button, create excel, import table, send e-mail, create back-up | matthew nance | General Discussion | 0 | July 27th, 2004 06:52 PM |