CORRELATION

Task: Segment the dataset based on different scenarios (e.g., clients with payment difficulties and all other cases) and identify the top correlations for each segmented data using Excel functions. 1-what is meant by segmented here? 2- I GET DIV/0 ERROR WHILE FINDING CORRELATION BETWEEN TARGET VARIABLE? PLEASE EXPLAIN HOW TO DO THIS TASK.