• Problem with Excel's Frequency function
    0 replies, posted
Why is it cumulative? I've selected this row: [img]http://gyazo.com/37c9b07842bb9240418c15c46e11d534.png[/img] as my data array. Then, for my bin array I select these two cells : [img]http://gyazo.com/f14ca6a714aa45c8026a556286c1adf3.png[/img] Then I type my formula: =FREQUENCY(data array; bin array) I also press CTRL+SHIFT+F2 but it doesn't make a difference. I place $ signs for the data array (I obviously don't want it to change), and then drag it down. My bin array ranges from 0,13 to 0,20 with steps of 0,01. The odd thing is that it seems to return the count [U]cumulatively [/U] (i.e. the sum of the frequencies does not equal the total amount in the data array). The frequencies: [img]http://gyazo.com/f99e1caea0591328cecb124a0ce49189.png[/img] I have around 27 results in my data array, so this is impossible. Each cell has an interval of 0,01 (if I don't drag it and do every cell manually, I get the same result). How do I make it non-cumulative? [I]ATM I fixed it by subtracting every cell by the one just above it, but still, why does this act so strangely?[/I] Link to the excel file: [url]http://drop.io/r2cwobo/asset/reactiesnelheid-xlsx[/url]
Sorry, you need to Log In to post a reply to this thread.