• We are pleased to announce that the winner of our Feedback Prize Draw for the Winter 2024-25 session and winning £150 of gift vouchers is Zhao Liang Tay. Congratulations to Zhao Liang. If you fancy winning £150 worth of gift vouchers (from a major UK store) for the Summer 2025 exam sitting for just a few minutes of your time throughout the session, please see our website at https://www.acted.co.uk/further-info.html?pat=feedback#feedback-prize for more information on how you can make sure your name is included in the draw at the end of the session.
  • Please be advised that the SP1, SP5 and SP7 X1 deadline is the 14th July and not the 17th June as first stated. Please accept out apologies for any confusion caused.

Frequency for histograms

S

Snowy

Member
Hi
How can we use arrays to get the frequency of observations for histograms, like in project 1?
 
Frequency function

I don't think they expect you to know about array formulae for CA2.

You can use the frequency function like any other function by clicking on the fx button next to the formula bar and asking for the function you want. Just tell the wizzard what ranges you want to use and let Excel worry about how to set up the arrays. Click on the Help part of the wizzard for details on how the function works.
 
You wouldn't be expected to be able to use array functions to prepare histograms for CA2. The Worked Example in the ActEd Notes shows one way you can do this using basic Excel functions. If you set up a column with the boundaries you want to use for the bands, you can then use the COUNTIF function to find the number of entries that are less than each boundary. Then you can subtract these cumulative totals to find the number falling in each band.
 
You must log in or register to reply here.
Back
Top