- Living on Mars
- Correlation theory
- Our data file
- Visualizing
- Single correlation
- Correlation matrix
- Inspecting the correlation matrix
- Correlation traps
- Respect outliers
- EXERCISE CORRELATION
- SOLUTION CORRELATION
- Time lags
- EXERCISE TIME LAGS
- SOLUTION TIME LAGS
- BONUS LECTURE
What you'll learn
- Visualize a relationship with scatter plots
- Quantify strength of relationship with Pearson correlation coefficient
- Identify time lags in relationships
- Quantify direction of relationship with Pearson correlation coefficient
Description
Data Science: Relationships In Data With Excel
We live in a society in which information is becoming the new gold. Data is precious and obviously, just like a precious diamond is treated with care, we also wish to treat our data with care. There are many ways in which we can analyze data and obtain valuable insights. This course focuses on one specific technique that can be used, namely a technique that is referred to as the Pearson product moment correlation technique and which yields the Pearson product moment correlation coefficient. This coefficient tells us something about relationships in our data. Once we know that certain relationships exist between certain variables, we can use that to our advantage. Imagine for instance that you know which variables have a strong relationships to your sales, or to the price of your crypto or stock. You can use that information to make better decisions.
This short course is set up in such a way that it maximizes accessibility. You do not need a background in mathematics or statistics to keep up. You are also welcome to join with every single version of Excel. All are welcome to join.
We wish you good luck with this course!
Team SSAA (Six Sigma Academy Amsterdam)
Other Courses
Arduino Workshop 2018 | A step-by-step Arduino how-to guide
Learn how to use Arduino, we'll teach you how to code and prototype with electronics.
Artistic Digital Portrait Painting
Concise and unique course on digitally painting photo-realistic portraits for beginners to advanced
CCNA BGP configuration and troubleshooting: Cisco CCNA prep
Prepare for the BGP exam topic in the CCNA 200-125 or 200-105 exams. You need to learn BGP for your exam! Get prepared.
Data Science for Beginners: Your Step-by-Step Guide To Start
Mastering Excel & MySQL with Board Infinity: For Aspiring Data Scientists: Diving Deep into Spreadsheets & Databases
2025 Year Numerology Masterclass - Completion & Self Mastery
Prepare for the Future. Discover and master your personal energy in 2025 using a rare, highly accurate numerology system
Creating a Guitar in Blender and Substance Painter
Create a Guitar in Blender 3D and Substance Painter, Learn 3D modelling, 3D texturing in Blender and Substance Painter
About the instructors
- 4.59 Calificación
- 179342 Estudiantes
- 17 Cursos
Six Sigma Academy Amsterdam (SSAA)
ACCREDITED TEACHING BY ACADEMICS
Six Sigma Academy Amsterdam or SSAA started when a number of university lecturers from the Netherlands decided to make academic quality education more affordable, practical, time efficient and engaging.
All course developers and lecturers involved are qualified university lecturers as well as Six Sigma Master Black Belts and as such able to train students and future instructors. All the Lean Six Sigma programs we offer are accredited based on the Dutch higher education standards and our student experience shows that the degrees are globally accepted and respected.
Six Sigma Academy Amsterdam or SSAA has trained and certified 100,000+ students in the Netherlands, Germany, US, India and UAE, both online and offline. Furthermore, SSAA lecturers have supervised projects for companies like Audi, the Dutch military and Lufthansa.