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 TO DO A FREQUENCY DISTRIBUTION WITH A CLASS WIDTH?
Hi, I am seeking some help in constructing a Frequency Distribution with a
class width, and it has been not been successful so far. I would appreciate any help I can get. Thanks |
#2
|
|||
|
|||
HOW TO DO A FREQUENCY DISTRIBUTION WITH A CLASS WIDTH?
Please tell us a little about the data
What is the range of values? But for now: Suppose A1:A1000 have numbers in the range 0 to 50 In C1:C6 I enter the values 0,10,20,30,40,50 I select D16 and type =FREQUENCY(A1:A1000,C1:C6) and commit this using SHIFT+CTRL+ENTER (not just ENTER) This is what I get 0....31 10...204 20...186 30...240 40...225 50...114 So 31 have value 0, 204 have value 1 to 10, etc best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Back to School at an Old Age" Back to School at an Old wrote in message ... Hi, I am seeking some help in constructing a Frequency Distribution with a class width, and it has been not been successful so far. I would appreciate any help I can get. Thanks |
#3
|
|||
|
|||
HOW TO DO A FREQUENCY DISTRIBUTION WITH A CLASS WIDTH?
Back to School at an Old Age -
Here are some ways: (1) FREQUENCY array-entered worksheet function (2) COUNTIF worksheet functions (3) Histogram tool of the Analysis ToolPak (4) my free Better Histogram add-in from www.treeplan.com Or, tell us specifically what you've tried and what has happened or not happened. - Mike http://www.MikeMiddleton.com "Back to School at an Old Age" Back to School at an Old wrote in message ... Hi, I am seeking some help in constructing a Frequency Distribution with a class width, and it has been not been successful so far. I would appreciate any help I can get. Thanks |
Thread Tools | |
Display Modes | |
|
|