ExcelBanter - Cumulative frequency

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Cumulative frequency (https://www.excelbanter.com/excel-discussion-misc-queries/177756-cumulative-frequency.html)

UniStudent Coll[_2_]

Cumulative frequency

How do i work out the cumulative freqeuncy of the following?

I have a set of numbers that need to be counted as the frequency:

67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
90
90
0
90
90
90
90
90
90
90
90
90
112.5
112.5
112.5
112.5
90
90
67.5
67.5
67.5
67.5
90
90
90
90
90
90
90

and groups for the frequency to be calculated:

0
22.5
45
67.5
90
112.5
135
157.5
180
202.5
225
247.5
270
292.5
315
337.5
360

Regards

FC

Mike H

Cumulative frequency

Hi,

In this example put your data in A1 - A50 and the groups in B1- B17

Put this formula in C1
=FREQUENCY(A1:A50,B1:B17)
Select the cells C1 - C17 and tap F2
Commit the formula with Ctrl + Shift + Enter
you should get the results

1
0
0
25
20
4
0
0
0
0
0
0
0
0
0
0
0

Mike

"UniStudent Coll" wrote:

How do i work out the cumulative freqeuncy of the following?

I have a set of numbers that need to be counted as the frequency:

67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
90
90
0
90
90
90
90
90
90
90
90
90
112.5
112.5
112.5
112.5
90
90
67.5
67.5
67.5
67.5
90
90
90
90
90
90
90

and groups for the frequency to be calculated:

0
22.5
45
67.5
90
112.5
135
157.5
180
202.5
225
247.5
270
292.5
315
337.5
360

Regards

FC

Pete_UK

Cumulative frequency

Have you tried looking up the FREQUENCY worksheet function in Excel
Help?

Pete

On Feb 25, 9:50*am, UniStudent Coll
wrote:
How do i work out the cumulative freqeuncy of the following?

I have a set of numbers that need to be counted as the frequency:

67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
90
90
0
90
90
90
90
90
90
90
90
90
112.5
112.5
112.5
112.5
90
90
67.5
67.5
67.5
67.5
90
90
90
90
90
90
90

and groups for the frequency to be calculated:

0
22.5
45
67.5
90
112.5
135
157.5
180
202.5
225
247.5
270
292.5
315
337.5
360

Regards

FC

Mike H

Cumulative frequency

Hi,

I missed the cumulative bit so put this in D1
=C1
Put this in D2
=C2+D1
Drag down to D17

Mike

"UniStudent Coll" wrote:

How do i work out the cumulative freqeuncy of the following?

I have a set of numbers that need to be counted as the frequency:

67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
67.5
90
90
0
90
90
90
90
90
90
90
90
90
112.5
112.5
112.5
112.5
90
90
67.5
67.5
67.5
67.5
90
90
90
90
90
90
90

and groups for the frequency to be calculated:

0
22.5
45
67.5
90
112.5
135
157.5
180
202.5
225
247.5
270
292.5
315
337.5
360

Regards

FC

All times are GMT +1. The time now is 07:47 AM.