Exploratory Data Analysis With Excel - Part 6 - Scatter Plots

[@DaveOnData]

💥 Learning R programming is easy for Excel users! 💥
📺 th-cam.com/video/MNpsyjSuR20/w-d-xo.html
👩‍🔬👨‍🔬 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

[@thejokerstyle100]

trash vids, you need to slow down and explain how you populate equations, your making my school life hell

[@barttitulaerexcelbart9400]

Thanks David. What I like to do in these cases is make a Excel Table and use a slicer to make subsets. Then make your XY diagram. Add a trendline and you can also add the R squared to quantify the strenght of relation. This works super easy to find the subsets with the strongest relation.

[@DaveOnData]

A most excellent tip! Thank you for sharing.

[@manuelalbisu]

You have no idea how useful this content is!
Great video!

[@DaveOnData]

Awesome! So glad you found the content useful.

[@sschuyler1]

Excellent course. Thanks for putting this together

[@DaveOnData]

You are welcome! The final video in the series will be published tomorrow morning US time.

[@andresalvarez2183]

Thank you very much for these excellent videos. I hope you keep uploading more!

[@balakumar.n4891]

Thank you please make a video too on Excel for making control charts. Keep creating more content!

[@DaveOnData]

If you're interested in analyzing data using process behavior (i.e., XmR) charts, check out my new upcoming online course:
bit.ly/IntroToBizAnalysis

[@Data_Mom]

Thank you David, extremely practical and informative concept.

[@DaveOnData]

You are welcome, Pooja! So glad you found the videos useful.

[@Data_Mom]

@@DaveOnData I learnt a new concept of jitter, thanks for creating such useful content.

[@Knowledge_Nuggies]

@16:05 even 5 dimensions ;) forgot the family size

[@SarcasmWEB]

100th like