what correlation coefficent to use.
I have right clicked on the trendline and format trendline and show the R-squared equation.
I have also used the 2 columns (costs and profit) and used a RSQ formulae
I have also used the Pearson's r formulae.
The question I have is what does each of them show for my data???? and which is more relevant to show as the cost increases the profit also increases or doesnt????? I wanted to use all three but not sure???
Please please help as your previous advice was perfect.
Bookmarks