mahmed1
Well-known Member
- Joined
- Mar 28, 2009
- Messages
- 2,302
- Office Version
- 365
- 2016
- Platform
- Windows
Hi All
I hope you are all well
Im hoping someone can help me with some Correlation formula
I have created a scatter plot with a trend line to so i can see some correlation between the 2 variables...
Problem im having is that in my ranges - there could be blanks and some values as 0 which i want to ignore..
So a couple of questions is
Thank You So much
I hope you are all well
Im hoping someone can help me with some Correlation formula
I have created a scatter plot with a trend line to so i can see some correlation between the 2 variables...
Problem im having is that in my ranges - there could be blanks and some values as 0 which i want to ignore..
So a couple of questions is
- How can i ignore 0s and blanks from chart
- How can i use the equation thats displayed in the trendline formula in the cells so i can reference it directly without having to update chart so i can easily ignore 0s and blanks from the Correl Function
- What is classed as a very good correlation, moderate and very weak?
Thank You So much