Introduction to Correlation Analysis in Excel
ฝัง
- เผยแพร่เมื่อ 5 ต.ค. 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:
📺 th-cam.com/video/xIXymabyFIM/w-d-xo.html
💥 Learning R programming is easy for Excel users! 💥
📺 th-cam.com/video/MNpsyjSuR20/w-d-xo.html
Just thank you about your videos, never stop making them! It feels like I am back to University learning everything and it is fun!
Wow! Thank you so much for the kind words. They are appreciated.
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.
sir , you got yourself a subscriber, amazing explanation.
Well explained. Many thanks
You are welcome! Glad you enjoyed the video.
Very helpful huge fan from zambia
Wow! Thank you for this, much appreciated. 😁
Thank you for the video it is useful ❤️
So very helpful, thank you
@joshuaranford4054 - Excellent! I am happy to hear you found my content useful.
Super helpful-thank you!
thank you David
You are welcome! So glad you liked the content.
Thanks David.
My pleasure!
Very well explained!!
You are the best. Thank you
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?
Execlllent explanation
THANK YOU DAVID SIR IF I FILTER DATA IS IT POSSABLE TO GET CORRLATION FOR NEW FILTERED DATA WITH OUT MAKE NEW PROSSESS
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?
Hi please can you determine correlation using pivot table functionality?
Hello how do I calculate together age, total cholesterol, blood pressure and glucose
Pls where can we get a link to the dataset?
Video is not working i guess🙃