Predictive Analytics: Correlation Coefficient in Excel

Рет қаралды 32,004

4 жыл бұрын

#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/...

Пікірлер: 23

@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 2 жыл бұрын

Thank you so much! This is great!

@PKAnExcelExpert 2 жыл бұрын

Thanks for your valuable feedback🙏

@alexrosen8762 4 жыл бұрын

Your tutorials are super useful.

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@Kevin_Yordy_gg111 4 жыл бұрын

Wow, nice job

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@durgesh91tomar 4 жыл бұрын

awesome..

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@girlinvestors1476 3 жыл бұрын

thank you

@PKAnExcelExpert 3 жыл бұрын

Most welcome

@AshishMishra-jc8nv 3 жыл бұрын

Excellent

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@shishmohammadkhan8973 4 жыл бұрын

Could u plz provide us yoy percentage variance chart

@ashwinkumar1708 3 жыл бұрын

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

@RakanXYZ 8 ай бұрын

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

@ruchitradia7063 4 жыл бұрын

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 4 жыл бұрын

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

@Drdry8 4 жыл бұрын

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 2 жыл бұрын

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.