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

[@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?

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

[@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🙏

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

[@shout-style]

Fabulously explained!! Thank you so much!!

[@PKAnExcelExpert]

Most welcome

[@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?

[@WirelessGus]

Thank you for sharing your knowledge with us. Much love

[@PKAnExcelExpert]

Thanks

[@cesarsaldana3429]

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

[@jmcgrory531]

Thank you! This is so helpful!

[@PKAnExcelExpert]

Most welcome🙏

[@wordsoflifetv4730]

Great explanation.Very very helpful.

[@PKAnExcelExpert]

Thanks

[@deAraujoAndre]

Fantastic explanation!! 🙏

[@PKAnExcelExpert]

Thanks🙏

[@chirayusarsolkar1065]

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

[@vishalgaurav5033]

Nicely explained. Easy and simple. Thank You!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@navedsaiyed9881]

Hats off to u PK no body can beat u

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@PaulitaNgMalita]

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

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

[@relax9286]

Thank you! Nicely done.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@ashishkumartripathi2788]

Very nicely explained..great ....thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rajugopale4651]

Excellent explanation. I like it.👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@govindbasnal7036]

Beautifully explained

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

[@shoryaarora1464]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jasoncysiu]

simple to understand! Thanks

[@PKAnExcelExpert]

Glad you liked it!

[@Pro-Cash]

Awesome work bro!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@tithe120]

Nicely explained!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Hash849]

Great presentation. Thank you very much!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@philippemizizi4053]

I like it, interesting!Thanks a lot!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@plamenyankov8476]

Thank you, PK !!!
Great video!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vfcustodio]

Nice man! Thank u so much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@DiaryMyVideo]

Lovely , very well explained video

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

[@Saatt79]

Awesome approach 👍👍 good one 👏👏👏👏

[@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 🙏

[@ataimur6116]

You are brilliant. Thank You.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@tamilmoviereview2466]

very well explained . thank you so much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@anuragdubey84]

Simply amazing sir

[@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🙏

[@mb_mark]

Very helpful! Thanks!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@cprasanna1984]

Very Informative

[@PKAnExcelExpert]

Glad it was helpful!

[@monicadantis6088]

Thank you very much!! you explained well

[@ahsenshahid]

great sir, PK

[@PKAnExcelExpert]

Thanks

[@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,

[@crystaltroiano887]

So helpufl. Thank you.

[@PKAnExcelExpert]

Most welcome

[@Kevin_Yordy_CP]

Awesome job, thanks 👍👍👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

[@alexrosen8762]

Super useful! Thanks a lot

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@musicforlife5797]

good one!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jimharding915]

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

[@AKT-bx7np]

Many thanks, Sir🙏

[@PKAnExcelExpert]

Most welcome

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

[@saraimarte]

Love the intro

[@PKAnExcelExpert]

Thanks

[@SaiRam00]

Good Thank You Sir...

[@PKAnExcelExpert]

Welcome

[@flodareltih9407]

nailed it, thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ramyarkamaran6497]

Thanks it is very useful 😊

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@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 !

[@jonahgo7743]

Thank you very much sir

[@PKAnExcelExpert]

Most welcome

[@rashminphadte1117]

Thankyou so much !

[@PKAnExcelExpert]

Welcome

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

[@marwanbasheerismail1512]

Thank you so much

[@PKAnExcelExpert]

Most welcome

[@LoveLove-ov7xv]

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

[@nailealarge7527]

great video thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@chandrakr83]

very very good

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@chandrakr83]

l try this at home and more understand than before hahhaaha

[@khaleel26dubai]

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

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

[@prajwal_747]

Thank you so much.

[@PKAnExcelExpert]

You're welcome!

[@muthukrishnanbalasubramani2672]

Thanks 🎉

[@PKAnExcelExpert]

You're welcome 😊

[@msantosh1220]

Forecasting study check
PK expert Check
Thank for this video

[@Sheetalmanohar]

Awesome 😊😁

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

[@unicorn9472]

Very nice

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@techsantoshkumar1756]

Nice job

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@arnoldkilaini]

Marvelous

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@FrancisSingar]

When will the Next Video be out for forecasting ?

[@PKAnExcelExpert]

Very soon

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

[@anuragdubey84]

Create some content on hr attrition forecasting

[@PKAnExcelExpert]

Sure

[@RIZKYIRELAND]

Thanks Sir

[@PKAnExcelExpert]

Welcome

[@vickytrannvt]

Thank you !!!!!

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

[@pramodbadgujar372]

Can I use for rejection predicted analysis

[@uclalse]

Freaking great video!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@uclalse]

@@PKAnExcelExpert I can't understand the regression equation though with the numbers for the dates. If I set x=0 I get a y-intercept of -45744, right. But the graph shows a y-intercept of about 130. I know I am probably confused about the date-values. What am I not understanding?

[@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. :)

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

[@shaileshgaurav]

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

[@r_a_j_d_e_e_p_c]

Please send me the link for next video of forecasting?

[@sityebisimamkele434]

Can I use this approach to predict future rainfall?

[@lawrencejeffcarait4918]

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

[@quanle6428]

thank men

[@PKAnExcelExpert]

Most welcome🙏

[@sushilv2234]

Great

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@brajeshkumartiwari4138]

Dear Mr pk
Thanks for your vedio. It's really informative and useful. I am facing a problem. The data date and a variable are fitted with 5th order polynomial. When I am using to recalculate te historical data the variable numbers are way far. Like to have your viewpoint or help. Regards

[@ashishmohan4707]

Hello sir have u complete series regression and correlation kindly let me know

[@fathinaatsila5350]

what if there is an outlier, how to handle it? thank you in advance.

[@PKAnExcelExpert]

Will create a separate video on this topic

[@danielslwu]

@@PKAnExcelExpert has the video been created?

[@mohammedembabi571]

Thank you dear

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

[@kkrishna9791]

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