This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email email@example.com for assistance.
I have attached an excel sheet that's calculating the scores of the RFM but I'm facing some problems.
What I'm trying to reach is that, for example the scores of R (Recency) it will be calculated by taking all the values in the recency and put them in the ascending order and then divide them into 5 group by taking the lower 20% and give it score 5 and then the next 40% give it 4 and then 60% and give it 3, 80% give it 2 and 100% and give it 1. I did this by using this formula =PERCENTILE.INC(B3:B16,0.2) the bold is the percentages. But still I'm having some cells which are N/A and some cell are not matching. I thing the problem is something related to the order of the values from lower to higher so in some points it's not reading the values.
Thanks for helping ! But I think there is something wrong, like in the monetary it should be the top 20% with scores 5 but in your workflow the opposite the lower 20% is with score 5. Also in the frequency and recency the same problem but in the recency the lower 20% will given 5 and frequency the top 20% will be given the 5 and so on.