Predictive Analytics: Correlation Coefficient in Excel

Подписаться 275 тыс.

Просмотров 33 тыс.

50% 1

#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-anexcel...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
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-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
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-m...

Опубликовано:

7 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 23

@SD-un3ii 2 года назад

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 2 года назад

Glad it was helpful!

@SD-un3ii 2 года назад

@@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.

@alexrosen8762 4 года назад

Your tutorials are super useful.

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@witoldpieczonka7417 2 года назад

Thank you so much! This is great!

@PKAnExcelExpert 2 года назад

Thanks for your valuable feedback🙏

@deiaabdullah2008 Год назад

Excellent Man ... please continue

@AshishMishra-jc8nv 3 года назад

Excellent

@PKAnExcelExpert 3 года назад

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

@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 10 месяцев назад

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.