Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

absolute frequency

ho un problema con la frequenza, mi viene mostrata la cumulativa invece che l'assoluta. ad esempio 32 è 1 ed è corretto, mentre 33,34,35 deve essere 0 non 1 che è del 32, cosi come 36 deve essere 2 e non 3 (2+1). la formula che vedete è corretta?



hello, i have a problem with frequency in my ipad. as you can see in the image, i have cumulative frequency, but i need absolute frequency. how can i do this?

example:

32 is 1: correct!

33 is 1, but it must show 0!

36 is 3 (2+1 before), but it must show 2!

the formula is correct?


User uploaded file

iPad Air, iOS 9.3.1

Posted on May 2, 2016 10:17 AM

Reply
Question marked as Best reply

Posted on May 2, 2016 12:16 PM

I suggest using the formula


E4=COUNTIF(A, D4)


this is shorthand for... select cell E4, then type (or copy and paste from here) the formula:

=COUNTIF(A, D4)

select cell E4, copy

select cells E4 thru E35, paste

2 replies

absolute frequency

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.