![]() The next decision to make is: what kind of distribution do you expect? Again, barring preconceptions, I would start with a uniform distribution that covers the full range of data. In each of the years 1960 through 2000?"). ![]() (For example, "What is the distribution of babies born But 15 or 31 is a good starting point, if the exercise itself does not suggest something different. Of course, the first decision to make is: how many bins do you want? There is no "right" answer. Without any presumptions or foreknowledge of the distribution of the data, I would "bootstrap" the required bin limits. It is very possible that the data is clustered so much that you cannot "see" the distribution clearly due to the bin limits that you choose. That is not an accurate description of the bin table that you can use with the FREQUENCY function. For example, you say the "bins (intervals)" are "0 - 0.99, 0 - 1, 1 - 2, 1, 4 and so on". ![]() See below.)Ībstract descriptions are usually too ambiguous. (Even better: upload an example Excel file. Obviously, do not post 2000 data values. But at least show us the actual frequency table, complete with cell names,įormulas and values. We cannot say why whatever you are doing "has not been working" unless you provide a concrete example - and what you mean by "not working". If you use the FREQUENCY function directly, you have complete control over the number and limits of the bins. That depends on the assignment and what you are currently studying. We cannot tell you what you are "supposed to do".
0 Comments
Leave a Reply. |