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.

-----------------------------------------------------------------------------------------------------------------------
The previous video I mention
-----------------------------------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------------------------------
Learn exploratory data analysis (EDA) with Excel
-----------------------------------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------------------------------
Excel Analytics Training
-----------------------------------------------------------------------------------------------------------------------
👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:

💥 Learning R programming is easy for Excel users! 💥

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:

💥 Learning R programming is easy for Excel users! 💥

[maxchergik]

Just thank you about your videos, never stop making them! It feels like I am back to University learning everything and it is fun!

[TheMISBlog]

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

Excellent explanation! Thank you so much!

[fuji_roll]

Perfect Mic Also perfect video! Thank you 🙏

[kristinecyrilpanaligan]

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

[anushnayak]

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

[Maldive]

sir, you got yourself a subscriber, amazing explanation.

[mfarouk]

THANK YOU DAVID SIR IF I FILTER DATA IS IT POSSABLE TO GET CORRLATION FOR NEW FILTERED DATA WITH OUT MAKE NEW PROSSESS

[xiangninglim]

Thank you for the video it is useful ❤️

[angjianyung]

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

[Poonambam-zt]

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

[temiladeadedapo]

Pls where can we get a link to the dataset?

[anonymous]

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

[seupadonald]

Hi please can you determine correlation using pivot table functionality?

[Xzizia]

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?