Predictive Analytics: Correlation Coefficient in Excel

#CorrelationCoefficient #PredictiveAnalytics
Hello Friends,
In this video, you will learn how to calculate the Correlation Coefficient in Microsoft Excel. We have explained it using Excel Formula and Data Analysis Add-in.
Please download the practice file from below given link:
www.pk-anexcelexpert.com/corr...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-matic.com/refer/...

[@SD-un3ii]

I was in search of this type of content for Demand Forecasting for 2 variables using associativity or correlation method, fortunately I got this. Nice content and well explained.

[@PKAnExcelExpert]

Glad it was helpful!

[@SD-un3ii]

@@PKAnExcelExpert Please, share video on Demand Forecasting using Exponential smoothing including trend method. Also, I want to know how to calculate Trend and Forecast value for first period in this method. Hope to hear from you soon.

[@deiaabdullah2008]

Excellent Man ... please continue

[@witoldpieczonka7417]

Thank you so much! This is great!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@alexrosen8762]

Your tutorials are super useful.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Kevin_Yordy_gg111]

Wow, nice job

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shishmohammadkhan8973]

Could u plz provide us yoy percentage variance chart

[@ashwinkumar1708]

Sir,pls tell how to fill down formulad without shortcut key please

[@durgesh91tomar]

awesome..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@girlinvestors1476]

thank you

[@PKAnExcelExpert]

Most welcome

[@RakanXYZ]

what is that slider u are using on 11:31?

[@AshishMishra-jc8nv]

Excellent

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ruchitradia7063]

Hi
Thanks for this vdo.
However, a small suggestion, i had seen an old video about making SPEEDOMETER's using Linear regression/Descriptive statistics analysis.
it seems the last past which you mentioned in this video showing the comparison between various variables, by just clicking on the move forward and backward button, i had seen similar type of vdo for SPEEDOMETER's using real meter's from cars
can you kindly check and make the same kind of speedometer's vdo please? its a request.
the one which can allow us to migrate from one range to other using linear regression/Descriptive Statisctics comparison, with moving forward and backward buttons.
Awaiting your reply please. :-)

[@PKAnExcelExpert]

I will try to make such video. Thanks for your valuable suggestion.

[@Drdry8]

Nice video, but i have 1 question. Why when you have changed the height to 150 the predicted weight it was 72.5? Because the actual weight for 150 height is 56.

[@exerblank]

Reason is b/c it is a prediction. The correlation cofficient is .846, so just means strong relationship. If it was 1, then it would be exact. Right now, majority of the time, it will be close.