Frequesncy - number of occurances

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

It is difficult to debug from a picture.

What you describe does not seem consistent with my own use of the FREQUENCY() function. A couple of tests suggests that maybe this is because you have not entered the function correctly. The FREQUENCY() function is intended to be entered as an array function (confirmed with ctrl-shift-enter similar to LINEST(), TRANSPOSE(), MMULT(), etc) over a range of cells (W3:W27, if I read your picture correctly). I see similar behavior to your picture if I enter the FREQUENCY() function in a single cell and then copy it down. From a picture I cannot say for sure that this is what is going on in your spreadsheet, but it is one possible explanation. If this is the case, then I recommend you review the help file (https://support.office.com/en-us/art...7-fd9ea898fdb9 ) and enter the function as an appropriate array function over the necessary range.

This is the forum's stance on helping with homework assignments:

Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.

Looking at the spreadsheet, it looks like you made the mistake I alluded to earlier:

I see similar behavior to your picture if I enter the FREQUENCY() function in a single cell and then copy it down.

I would have expected you to 1) Select M3:M18, 2) Enter =FREQUENCY(D3:J18,L3:L17) and 3) confirm with ctrl-shift-enter. Review help file for the FREQUENCY() function.

Here's a little fragment of your sheet:

	I	J	K	L	M
2	Thu 30th	Fri 31st		range	#
3	54	53		46	1
4	52	53		47	1
5	54	52		48	1
6	53	52		49	6
7	53			50	2
8	50			51	0
9	51			52	7
10	49			53	14
11	53			54	30
12	51			55	14
13	49			56	12
14	49			57	1
15	49			58	4
16	68			59	1
17	46	4047000000000000		60	0
18	46	4047000000000001

The frequency formula is entered like this:

Select M3:M18

Paste =FREQUENCY(D3:J18,L3:L17) in the formula bar

Press and hold the Ctrl and Shift keys, then press Enter

Why does it show a count of 1 for 46? There are obviously two, right?

Actually, there are not. In I17, I manually entered 46. Its hex representation as an IEEE-754 double-precision float is shown in yellow in the cell to the right.

I18 contains the 46 as it appears in your sheet. It is one LSB larger, which means it gets counted in the 47 bin.

Those numbers in columns D:J need to be fixed.

If what you used was Precision as displayed, I strongly recommend against it. I'd recommend you fix the problem at its source.

That will work, but it's a band-aid. My question would be, how did the non-integer numbers get there in the first place?