Correlation in Excel using Data analysis add-in with a criteria

Mounika Bandla 0 Reputation points
2024-02-22T06:43:07.1833333+00:00

Hello, I am trying to find the correlation for several columns at a time. I have used data analysis add-in and I want to apply a condition to go with. for example, my worksheet have data about clients having paying difficulties and clients with no payment difficulties. so,by using data analysis toolpak I am getting correlation of entire data but i want to get the correlation for clients with payment difficulties only. I have tried to use =correal() with nested if function =CORREL(IF (Table13[TARGET]=Correlations!$B$4,Cleaned_data!$H$2:$H$50000), IF(Table13[TARGET]=Correlations!$B$4,Cleaned_data!$G$2:$G$50000)). It gives the correct correlation but i have manually enter this formula for each row. Is there any way to automate this process?

Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Excel | For business | Windows
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.