Hi guys
My question may sound a bit dumb so please excuse me
In regression in data analysis isn't multiple r the coefficient of correlation?
And if so shouldn't the function CORREL yield the same answer if used on the same data sets
Because I tried comparing the number of the data analysis and correl and I got once a positive number in data analysis (0.75) and its equivalent negative number while using correl (-0.75).
Why is that?
Thanks alot
My question may sound a bit dumb so please excuse me
In regression in data analysis isn't multiple r the coefficient of correlation?
And if so shouldn't the function CORREL yield the same answer if used on the same data sets
Because I tried comparing the number of the data analysis and correl and I got once a positive number in data analysis (0.75) and its equivalent negative number while using correl (-0.75).
Why is that?
Thanks alot