"🔥Data Scientist Masters Program (Discount Code - YTBE15) - www.simplilearn.com/big-data-and-analytics/senior-data-scientist-masters-program-training?PEfQCv9nvSo&Comments&UA-cam 🔥IITK - Professional Certificate Course in Data Science (India Only) - www.simplilearn.com/iitk-professional-certificate-course-data-science?PEfQCv9nvSo&Comments&UA-cam 🔥Caltech Post Graduate Program in Data Science - www.simplilearn.com/post-graduate-program-data-science?PEfQCv9nvSo&Comments&UA-cam 🔥Brown University - Applied AI & Data Science - www.simplilearn.com/applied-ai-data-science-course?PEfQCv9nvSo&Comments&UA-cam
Thank you for choosing us as your learning partner. We are thrilled to hear that you enjoyed your experience with us! If you are looking to expand your knowledge further, we invite you to explore our other courses in the description box.
Hi, Suppose you have two sets of data, X and Y, as shown in the table below: X Y 1 10 2 9 3 8 4 7 5 6 6 5 7 4 8 3 9 2 10 1 To determine if there is a negative correlation between X and Y, we can use Excel's CORREL function, which calculates the correlation coefficient between two sets of data. To use the CORREL function, we can follow these steps: Select a cell where you want to display the correlation coefficient. Type the following formula into the formula bar: =CORREL(A2:A11,B2:B11) Press Enter. The formula above calculates the correlation coefficient between the two sets of data in columns A and B. The result should be -1, indicating a perfect negative correlation between X and Y. Here's what the result should look like in Excel: X Y 1 10 2 9 3 8 4 7 5 6 6 5 7 4 8 3 9 2 10 1 -1 I hope this helped Thanks
🔥 Post Graduate Program In Data Science: www.simplilearn.com/post-graduate-program-data-science?WhatIsCorrelation-PEfQCv9nvSo&Comment& 🔥 Data Science Bootcamp (US Only): www.simplilearn.com/data-science-bootcamp?WhatIsCorrelation-PEfQCv9nvSo&Comment&
"🔥Data Scientist Masters Program (Discount Code - YTBE15) - www.simplilearn.com/big-data-and-analytics/senior-data-scientist-masters-program-training?PEfQCv9nvSo&Comments&UA-cam
🔥IITK - Professional Certificate Course in Data Science (India Only) - www.simplilearn.com/iitk-professional-certificate-course-data-science?PEfQCv9nvSo&Comments&UA-cam
🔥Caltech Post Graduate Program in Data Science - www.simplilearn.com/post-graduate-program-data-science?PEfQCv9nvSo&Comments&UA-cam
🔥Brown University - Applied AI & Data Science - www.simplilearn.com/applied-ai-data-science-course?PEfQCv9nvSo&Comments&UA-cam
Correlation between share prices and coal prices ?
This guy has the vocal range of Freddie Mercury
Good. I never thought correlation could be taught such 'mechanically' without referring to the formula. Excel does the trick!
Well understood & very good formatting! Thank you so much for posting! This helped me so much! Have a wonderful day!
Thanks! It was well understood and very informative. God bless you!
It was short but i understood the main point now.. thanks for it❤
thats great ❤
Thank you for choosing us as your learning partner. We are thrilled to hear that you enjoyed your experience with us! If you are looking to expand your knowledge further, we invite you to explore our other courses in the description box.
Thank you
Can you show excel example for negative correlation
Hi,
Suppose you have two sets of data, X and Y, as shown in the table below:
X Y
1 10
2 9
3 8
4 7
5 6
6 5
7 4
8 3
9 2
10 1
To determine if there is a negative correlation between X and Y, we can use Excel's CORREL function, which calculates the correlation coefficient between two sets of data.
To use the CORREL function, we can follow these steps:
Select a cell where you want to display the correlation coefficient.
Type the following formula into the formula bar: =CORREL(A2:A11,B2:B11)
Press Enter.
The formula above calculates the correlation coefficient between the two sets of data in columns A and B. The result should be -1, indicating a perfect negative correlation between X and Y.
Here's what the result should look like in Excel:
X Y
1 10
2 9
3 8
4 7
5 6
6 5
7 4
8 3
9 2
10 1
-1
I hope this helped
Thanks
Formula
slowly please..
🔥 Post Graduate Program In Data Science: www.simplilearn.com/post-graduate-program-data-science?WhatIsCorrelation-PEfQCv9nvSo&Comment&
🔥 Data Science Bootcamp (US Only): www.simplilearn.com/data-science-bootcamp?WhatIsCorrelation-PEfQCv9nvSo&Comment&