Introduction to Correlation Analysis in Excel

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.buymeacoffee.com/DaveOnData
★★★ My online data analysis courses ▶ school.daveondata.com
-----------------------------------------------------------------------------------------------------------------------
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

[@DaveOnData]

👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
📺 ruclips.net/video/xIXymabyFIM/видео.html
💥 Learning R programming is easy for Excel users! 💥
📺 ruclips.net/video/MNpsyjSuR20/видео.html

[@kristinecyrilpanaligan6925]

thank you so much sir! this serves as a big help to our group!

Excellent explanation! Thank you so much!

[@linnwithani]

Great explanation and easy to follow.

[@fuji_roll3706]

Perfect Mic Also perfect video! Thank you 🙏

[@anushnayak5911]

Thank you so much, the explanation is good for a layman

[@johnlawlor2942]

Super helpful-thank you!

[@TheMISBlog]

One of the best explanations I've seen, Thanks David

[@DaveOnData]

Thank you for the feedback, much appreciated!

[@lewisebula7388]

You are the best. Thank you

[@Maldive177]

sir , you got yourself a subscriber, amazing explanation.

[@xiangninglim4736]

Thank you for the video it is useful ❤️

[@adderlyacevedo8232]

Very well explained!!

[@scottadrianmonghit4203]

Thank you so much!

[@victor_peral]

Execlllent explanation

[@AFFarms444]

Thanks David.

[@DaveOnData]

My pleasure!

[@angjianyung3140]

Great explanation.
One question though, how do I use the numbers generated from the matrix for a meaningful analysis? 🤔

[@zinimbita9789]

Well explained. Many thanks

[@DaveOnData]

You are welcome! Glad you enjoyed the video.

[@chaiszcash4206]

thank you David

[@DaveOnData]

You are welcome! So glad you liked the content.

[@Xzizia92]

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?

[@joshuaranford4054]

So very helpful, thank you

[@DaveOnData]

@joshuaranford4054 - Excellent! I am happy to hear you found my content useful.

[@sothiniyoungfachi4557]

Very helpful huge fan from zambia

[@DaveOnData]

Wow! Thank you for this, much appreciated. 😁

[@seupadonald5067]

Hi please can you determine correlation using pivot table functionality?

[@102anonymous3]

Thanks for your video. It's very useful. Can you give me this excel file so I can practice it myself?

[@docokd7oco443]

There is a far simpler and ckeare way of showing the correlation by right clicking the trend line and selecting %R to be displayed on the graph. Also you can have the slope and intercept formula displayed as well.

[@PoonamSingh-sx8qh]

Hello how do I calculate together age, total cholesterol, blood pressure and glucose

[@temiladeadedapo3638]

Pls where can we get a link to the dataset?

[@TheNimendrael]

Video is not working i guess🙃