Cumulative frequency

[UniStudent Coll]

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]

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

 

[Pete_UK]

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

Pete

 

[Mike H]

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]

This method isnt working its producing a list something totally different and
im not sure why. Im using excel 2007.

 

[Mike H]

Hi,

I'm not familiar with E2007 but it won't have changed the statistical rules
associated with frequency. Did you follow this bit precisely


Mike

 

[Mick Jennings]

use a pivot table ?