Forecasting in Excel using Linear Regression

[@8sevenstudiosphotography469]

THANKS!!!!!! YOU EXPLAINED THIS WAY BETTER THAN MY PROFESSOR!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Chinmayimanvi]

You have a unique way of explaining which can be easily understood!!
Waiting for further forecasting videos!!
Thank you, PK !!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@navpreetkaur4902]

one of the best video on regression so far, please keep up the good work

[@VishalSingh-zt4gu]

I have seen many tutorials ….. This one is million times better than any other. I would suggest you to make tutorials about Data lake/Data warehouse/Sql/ Python and so on. Many of us will watch. Great content and Technique is very simple and efficient 10/10 BOSS...

[@kristinem1385]

Thank you, you explained this better than my university professor!

[@minhthu0105]

Hi, can you help me to explain how we exchange date to number at 10:03?

[@umehtoch]

I love your works. Thank you for all you do. I hit this when I really needed it

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@happymm2008]

Thank you so much! You explained the concept so well and patiently!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@minhthu0105]

Hi, can you help me to explain how we exchange date to number at 10:03?

[@asyakatanani8181]

u r a real hero... a lot behind this word for me... but that much is enough to say...

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@shout-style]

Fabulously explained!! Thank you so much!!

[@PKAnExcelExpert]

Most welcome

[@WirelessGus]

Thank you for sharing your knowledge with us. Much love

[@PKAnExcelExpert]

Thanks

[@vishalgaurav5033]

Nicely explained. Easy and simple. Thank You!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@chirayusarsolkar1065]

Thankyou so much sir
It helped me really lot
I was struuggling with forecast methods for long time now

[@jmcgrory531]

Thank you! This is so helpful!

[@PKAnExcelExpert]

Most welcome🙏

[@PaulitaNgMalita]

Thank you for the tutorial! Stay safe and well! 😊

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@wordsoflifetv4730]

Great explanation.Very very helpful.

[@PKAnExcelExpert]

Thanks

[@shoryaarora1464]

Your every video has unique things which we never know before. Thank you PK

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@navedsaiyed9881]

Hats off to u PK no body can beat u

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@deAraujoAndre]

Fantastic explanation!! 🙏

[@PKAnExcelExpert]

Thanks🙏

[@cesarsaldana3429]

Amazing!!!!!!....Tank you..... Best Regards from mexico.

[@relax9286]

Thank you! Nicely done.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@govindbasnal7036]

Beautifully explained

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@AshishMishra-jc8nv]

Excellent Sir. Thanks for sharing the knowledge.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rakeshthakur9403]

Nice explained, Thank you so much.

[@PKAnExcelExpert]

You are welcome

[@jasoncysiu]

simple to understand! Thanks

[@PKAnExcelExpert]

Glad you liked it!

[@Ruben-mx8gk]

Hello PK, great content was wondering if you ever got a chance to do a video on forecasting with outliers/data not in trend. I am working on forecasting daily deposit growth and a video like this might help. Thank you

[@rajugopale4651]

Excellent explanation. I like it.👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ashishkumartripathi2788]

Very nicely explained..great ....thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@philippemizizi4053]

I like it, interesting!Thanks a lot!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ezhilmathikrishnamoorthy8401]

Thank you this will help me for my current work

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ezhilmathikrishnamoorthy8401]

@@PKAnExcelExpertpls suggest forecast method if volume has seasonality , irregular trend

[@neenadsawant1165]

Very nice explanation. Thank you so much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vfcustodio]

Nice man! Thank u so much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@satishb9975]

Thank you very helpful ☺ for stepping in the worlds of analytics for new aspirants. greatly explained thanks for sharing and helping 🙏

[@Hash849]

Great presentation. Thank you very much!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Pro-Cash]

Awesome work bro!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@tithe120]

Nicely explained!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@DiaryMyVideo]

Lovely , very well explained video

[@mb_mark]

Very helpful! Thanks!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@cosimopiovasco8196]

Thanks for porsting this, Mr. PK!
It comes very handy to foresee what 2020 will bring us (or at least to have an approach)
Best regads,

[@tamilmoviereview2466]

very well explained . thank you so much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Saatt79]

Awesome approach 👍👍 good one 👏👏👏👏

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@plamenyankov8476]

Thank you, PK !!!
Great video!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@seisopheapanya7528]

Great. and Helpful, thanks, Sir.

[@PKAnExcelExpert]

Most welcome!

[@seisopheapanya7528]

@@PKAnExcelExpert Sir, I am just new to your channel, yet thanks for this warmth welcome. But may I know is there a video about Linear Regression used in forecasting in Operating Management also especially its Assumptions. Thanks in advance, Sir.

[@rajugopale4651]

Good one...👍🏽

[@PKAnExcelExpert]

Thanks🙏

[@LoveLove-ov7xv]

Do u the videoes for seasonal forecast? This is very amazing video by the way

[@crystaltroiano887]

So helpufl. Thank you.

[@PKAnExcelExpert]

Most welcome

[@anuragdubey84]

Simply amazing sir

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@AKT-bx7np]

Many thanks, Sir🙏

[@PKAnExcelExpert]

Most welcome

[@cprasanna1984]

Very Informative

[@PKAnExcelExpert]

Glad it was helpful!

[@saraimarte]

Love the intro

[@PKAnExcelExpert]

Thanks

[@ravirao8270]

Beautifully explained.. thank you for such tutorial 🙏🏻
I would like to request you to please make some videos on Statistics with real life case studies.

[@ataimur6116]

You are brilliant. Thank You.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@marwanbasheerismail1512]

Thank you so much

[@PKAnExcelExpert]

Most welcome

[@jonahgo7743]

Thank you very much sir

[@PKAnExcelExpert]

Most welcome

[@ahsenshahid]

great sir, PK

[@PKAnExcelExpert]

Thanks

[@musicforlife5797]

good one!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@muthukrishnanbalasubramani2672]

Thanks 🎉

[@PKAnExcelExpert]

You're welcome 😊

[@Kevin_Yordy_CP]

Awesome job, thanks 👍👍👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@flodareltih9407]

nailed it, thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@soumikchoudhury4852]

Will you please share the link of the video on the forecasting of data with trend and seasonality as mentioned in the last part of the video ??

[@danielslwu]

I would like to see it too

[@Andre-dn7dk]

Im also trying to find that

[@prabhur6820]

Hi Good one.. you have explained it very clearly .. eagerly waiting for your next forecast video.. as I am working data which is consistence.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@alexrosen8762]

Super useful! Thanks a lot

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jimharding915]

How did you fill in the results in the forecast columns?

[@khaleel26dubai]

hi, well explained. do you have any forecasting video where the data points have outliers and seasonality?

[@SaiRam00]

Good Thank You Sir...

[@PKAnExcelExpert]

Welcome

[@monicadantis6088]

Thank you very much!! you explained well

[@venurasilva584]

Can anyone explain to me how he changed the date to value? No matter what method I use to forecast I always get the forecast date not the value.

[@rashminphadte1117]

Thankyou so much !

[@PKAnExcelExpert]

Welcome

[@ramyarkamaran6497]

Thanks it is very useful 😊

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pramodbadgujar372]

Can I use for rejection predicted analysis

[@prajwal_747]

Thank you so much.

[@PKAnExcelExpert]

You're welcome!

[@nailealarge7527]

great video thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sityebisimamkele434]

Can I use this approach to predict future rainfall?

[@RinchenDolkar-h4u]

What do you do if there is a outlier?

[@excel_free]

thank for 4 we can use the LINEST function which is a matrix function
on two adjacent cells to detreminate a and b

[@msantosh1220]

Forecasting study check
PK expert Check
Thank for this video

[@habtamuworke5808]

You have a unique way of explaining which can be easily understood. how did you change the formats, 28-Aug-00 to 421.37079?

[@arthurcussen4553]

get an answer?

[@r_a_j_d_e_e_p_c]

I think format has been changed from date to number !

[@quanle6428]

thank men

[@PKAnExcelExpert]

Most welcome🙏

[@RIZKYIRELAND]

Thanks Sir

[@PKAnExcelExpert]

Welcome

[@Sheetalmanohar]

Awesome 😊😁

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@r_a_j_d_e_e_p_c]

Please send me the link for next video of forecasting?

[@chandrakr83]

very very good

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@chandrakr83]

l try this at home and more understand than before hahhaaha

[@kkrishna9791]

Hello sir, Can we apply it y=mx+c for stock market forecast. Please help

[@anuragdubey84]

Create some content on hr attrition forecasting

[@PKAnExcelExpert]

Sure

[@unicorn9472]

Very nice

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Amit-ki-Pathshala]

What if there will be an outliers?

[@techsantoshkumar1756]

Nice job

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pratikr3970]

What did you do to change the format for Forecast 3 when date shows up?

[@heyrobined]

ctrl + 1 > accounting

[@lawrencejeffcarait4918]

Is there a tutorial for having a outliner sir? Thank you

[@bluewater3028]

How the cell format you are changing while it converts from date to values after applying the y=max+c formula. Please guide me.

[@PKAnExcelExpert]

Press Shift+Ctrl+3(#)

[@bluewater3028]

@@PKAnExcelExpert Thank You for fast response. Your videos are very unique and interesting. 👍

[@1558griffin]

thanks for the great video! My R2 is fairly low. I'm concerned that this will mean that my forecasting may not be very accurate

[@sunilbs2455]

Can you also share how did you got the forecasted numbers on the chart

[@PKAnExcelExpert]

Just create a line chart or scatter chart after selecting date sales and forecast1. For more information please download this excel file from the link given vedio's description box.

[@arnoldkilaini]

Marvelous

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shaileshk4486]

Hello PK, Your guidance and videos helped me a lot to develop dashboard and become creative with Excel. Thanks for all the help.
Is there any tutorial in reference to this video ? Thanks Again. :)

[@iusmanasif]

how do i forecast with seasonality in the data?

[@shaileshgaurav]

Beautifully explained PK sir. Can I request you to create a video on Markov Analysis for workforce planning?

[@FrancisSingar]

When will the Next Video be out for forecasting ?

[@PKAnExcelExpert]

Very soon

[@prabhakergautam9204]

how you change the date format to value??

[@vickytrannvt]

Thank you !!!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@raghavkaushik9985]

How did you change from date to numbers?

[@shallotedsouza6827]

what do I do if i don't have a continuous data.. like I have data for 8th 9th and directly 11th march... does this still work?