Introduction to Correlation Analysis in Excel
Вставка
- Опубліковано 4 вер 2024
- Do you analyze data with Excel? Are you familiar with correlation? Performing a correlation analysis in Excel is a quick and powerful way to gain insights into your data.
If not, correlation is a powerful data analysis tool that should be in your analytics tool belt if you aspire to data science.
In this short tutorial I introduce correlation analysis using Microsoft Excel.
☕ If you found this content useful and would like to support the channel, you can buy me a coffee: www.buymeacoff...
★★★ My online data analysis courses ▶ school.daveond...
-----------------------------------------------------------------------------------------------------------------------
The previous video I mention
-----------------------------------------------------------------------------------------------------------------------
📺 Summary Statistics and Correlation Analysis in Excel Analysis ToolPak: • Summary Statistics and...
-----------------------------------------------------------------------------------------------------------------------
Learn exploratory data analysis (EDA) with Excel
-----------------------------------------------------------------------------------------------------------------------
📺 Part 1 of the Series - Basic Numerics: • Exploratory Data Analy...
📺 Part 2 of the Series - Basic Categoricals: • Exploratory Data Analy...
📺 Part 3 of the Series - Histograms: • Exploratory Data Analy...
📺 Part 4 of the Series - Box Plots: • Exploratory Data Analy...
📺 Part 5 of the Series - Bar Charts: • Exploratory Data Analy...
📺 Part 6 of the Series - Scatter Plots: • Exploratory Data Analy...
📺 Part 7 of the Series - TreemapCharts: • Exploratory Data Analy...
-----------------------------------------------------------------------------------------------------------------------
Excel Analytics Training
-----------------------------------------------------------------------------------------------------------------------
👩🔬👨🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
📺 • Introduction to Busine...
💥 Learning R programming is easy for Excel users! 💥
📺 • Learning R Programming...
Stay healthy and happy data sleuthing!
#CorrelationAnalysisWithExcel #CorrelationWithExcel #CorrelationAnalysis
👩🔬👨🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
📺 ua-cam.com/video/xIXymabyFIM/v-deo.html
💥 Learning R programming is easy for Excel users! 💥
📺 ua-cam.com/video/MNpsyjSuR20/v-deo.html
One of the best explanations I've seen, Thanks David
Thank you for the feedback, much appreciated!
thank you so much sir! this serves as a big help to our group!
Perfect Mic Also perfect video! Thank you 🙏
Excellent explanation! Thank you so much!
Thank you so much, the explanation is good for a layman
Great explanation and easy to follow.
Well explained. Many thanks
You are welcome! Glad you enjoyed the video.
thank you David
You are welcome! So glad you liked the content.
sir , you got yourself a subscriber, amazing explanation.
Super helpful-thank you!
Thanks David.
My pleasure!
So very helpful, thank you
@joshuaranford4054 - Excellent! I am happy to hear you found my content useful.
Very well explained!!
Thank you for the video it is useful ❤️
Very helpful huge fan from zambia
Wow! Thank you for this, much appreciated. 😁
Thank you so much!
Great explanation.
One question though, how do I use the numbers generated from the matrix for a meaningful analysis? 🤔
Thanks for your video. It's very useful. Can you give me this excel file so I can practice it myself?
You are the best. Thank you
Execlllent explanation
Hi David, what value of correlation would you consider significant for 2 time series of data? Are there any ranges of correlation values that can be considered highly correlated, medium correlation etc?
Hello how do I calculate together age, total cholesterol, blood pressure and glucose
Hi please can you determine correlation using pivot table functionality?
Pls where can we get a link to the dataset?
Video is not working i guess🙃