second time to post it please help

Q5. Calculate RFM and analyze customer segments: (Overall 4 Marks) Does each of these stores gain customer's satisfaction and loyalty based on this small sample? In other words, does it have more than 20% of customers in (High Value and Potential) segments? (3 Marks) Based on the sample, would you consider RFM be misleading given this sample? Why yeso? Give two reasons to support your argument. (1 Mark) Please, write down your RFM ranks per store and your segmentation. Note: It is a collective mark when you give the final % per segment. RFM without segment% and analysis is not marked. Segment From To High Value 555 525 New Potential 455|355 Needs Attention 354144 524 511 Lost 143 111 N 2 Store 1 Customer ID Total Paid$|Transaction Date 1 1000 11-Mar-22 1 200 10-Mar-22 2 450 9-Mar-22 10 9-Mar-21 2 101 8-Mar-22 2 10 7-Mar-22| 3 1500 9-Mar-21 3 1400 8-Mar-221 3 5000 10-Mar-22 4 10000 10-Feb-22 4 6001 1-Mar-221 4 750 11-Feb-22 4 50 12-Feb-22 4 150 13-Feb-22 5 100 8-Mar-221 5 100 7-Mar-22 5 100 6-Mar-22 5 1001 5-Mar-22) 5 100 4-Mar-221 5 1001 3-Mar-22 Note that some dates are in 2021. Store 2 Customer Unit ID Price 1 1 #Items Transaction Date 1 5 3 4 5 3 N 7 2 2 2 2 2 9 1 2 1 3 41 2 3 6 3 3 41 8 8 4 5 5 11-Mar-22 10-Mar-22 9-Mar-22 9-Mar-21 8-Mar-22 7-Mar-22) 9-Mar-21 8-Mar-22 10-Mar-22 10-Feb-22 11-Feb-22 11-Feb-22) 11-Feb-22 11-Feb-22) 8-Mar-22 7-Mar-22 6-Mar-22 5-Mar-22 4-Mar-22 3-Mar-22 4 10 4 4 1 20 4 4 4 15 15 301 100 200 101 10 101 10 5 1 1 1 ulu ulu ulu 5 5 5 5 5 1 10 5 1 10 Q5. Calculate RFM and analyze customer segments: (Overall 4 Marks) Does each of these stores gain customer's satisfaction and loyalty based on this small sample? In other words, does it have more than 20% of customers in (High Value and Potential) segments? (3 Marks) Based on the sample, would you consider RFM be misleading given this sample? Why yeso? Give two reasons to support your argument. (1 Mark) Please, write down your RFM ranks per store and your segmentation. Note: It is a collective mark when you give the final % per segment. RFM without segment% and analysis is not marked. Segment From To High Value 555 525 New Potential 455|355 Needs Attention 354144 524 511 Lost 143 111 N 2 Store 1 Customer ID Total Paid$|Transaction Date 1 1000 11-Mar-22 1 200 10-Mar-22 2 450 9-Mar-22 10 9-Mar-21 2 101 8-Mar-22 2 10 7-Mar-22| 3 1500 9-Mar-21 3 1400 8-Mar-221 3 5000 10-Mar-22 4 10000 10-Feb-22 4 6001 1-Mar-221 4 750 11-Feb-22 4 50 12-Feb-22 4 150 13-Feb-22 5 100 8-Mar-221 5 100 7-Mar-22 5 100 6-Mar-22 5 1001 5-Mar-22) 5 100 4-Mar-221 5 1001 3-Mar-22 Note that some dates are in 2021. Store 2 Customer Unit ID Price 1 1 #Items Transaction Date 1 5 3 4 5 3 N 7 2 2 2 2 2 9 1 2 1 3 41 2 3 6 3 3 41 8 8 4 5 5 11-Mar-22 10-Mar-22 9-Mar-22 9-Mar-21 8-Mar-22 7-Mar-22) 9-Mar-21 8-Mar-22 10-Mar-22 10-Feb-22 11-Feb-22 11-Feb-22) 11-Feb-22 11-Feb-22) 8-Mar-22 7-Mar-22 6-Mar-22 5-Mar-22 4-Mar-22 3-Mar-22 4 10 4 4 1 20 4 4 4 15 15 301 100 200 101 10 101 10 5 1 1 1 ulu ulu ulu 5 5 5 5 5 1 10 5 1 10