Forecasting in Excel using Linear Regression

#Forecasting #LinearRegression
Hello Friends,
In this video, you will learn how to do the sales forecasting in Excel. We have explained four methods - Forecast formula, Trend formula, Linear regression equation using Excel Formula, Linear regression equation using Excel Chart.
Please download the practice file from below given link:
www.pk-anexcelexpert.com/fore...
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/...

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

[@8sevenstudiosphotography469]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@PaulitaNgMalita]

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

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

[@plamenyankov8476]

Thank you, PK !!!
Great video!

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

[@satishb9975]

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

[@navpreetkaur4902]

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

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

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

[@vishalgaurav5033]

Nicely explained. Easy and simple. Thank You!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@cesarsaldana3429]

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

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

[@Hash849]

Great presentation. Thank you very much!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

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

[@monicadantis6088]

Thank you very much!! you explained well

[@shoryaarora1464]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@WirelessGus]

Thank you for sharing your knowledge with us. Much love

[@PKAnExcelExpert]

Thanks

[@mb_mark]

Very helpful! Thanks!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@alexrosen8762]

Super useful! Thanks a lot

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jmcgrory531]

Thank you! This is so helpful!

[@PKAnExcelExpert]

Most welcome🙏

[@jasoncysiu]

simple to understand! Thanks

[@PKAnExcelExpert]

Glad you liked it!

[@DiaryMyVideo]

Lovely , very well explained video

[@relax9286]

Thank you! Nicely done.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

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

[@philippemizizi4053]

I like it, interesting!Thanks a lot!

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

[@AshishMishra-jc8nv]

Excellent Sir. Thanks for sharing the knowledge.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ataimur6116]

You are brilliant. Thank You.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Kevin_Yordy_gg111]

Awesome job, thanks 👍👍👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@tamilmoviereview2466]

very well explained . thank you so much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@navedsaiyed9881]

Hats off to u PK no body can beat u

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

[@deAraujoAndre]

Fantastic explanation!! 🙏

[@PKAnExcelExpert]

Thanks🙏

[@Saatt79]

Awesome approach 👍👍 good one 👏👏👏👏

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@wordsoflifetv4730]

Great explanation.Very very helpful.

[@PKAnExcelExpert]

Thanks

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

[@rakeshthakur9403]

Nice explained, Thank you so much.

[@PKAnExcelExpert]

You are welcome

[@vickytrannvt]

Thank you !!!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rajugopale4651]

Excellent explanation. I like it.👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ashishkumartripathi2788]

Very nicely explained..great ....thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@crystaltroiano887]

So helpufl. Thank you.

[@PKAnExcelExpert]

Most welcome

[@govindbasnal7036]

Beautifully explained

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@prajwal_747]

Thank you so much.

[@PKAnExcelExpert]

You're welcome!

[@anuragdubey84]

Simply amazing sir

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@Pro-Cash]

Awesome work bro!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nailealarge7527]

great video thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@flodareltih9407]

nailed it, thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rashminphadte1117]

Thankyou so much !

[@PKAnExcelExpert]

Welcome

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

[@shaileshgaurav]

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

[@ramyarkamaran6497]

Thanks it is very useful 😊

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

[@rajugopale4651]

Good one...👍🏽

[@PKAnExcelExpert]

Thanks🙏

[@saraimarte]

Love the intro

[@PKAnExcelExpert]

Thanks

[@cprasanna1984]

Very Informative

[@PKAnExcelExpert]

Glad it was helpful!

[@marwanbasheerismail1512]

Thank you so much

[@PKAnExcelExpert]

Most welcome

[@ahsenshahid]

great sir, PK

[@PKAnExcelExpert]

Thanks

[@jonahgo7743]

Thank you very much sir

[@PKAnExcelExpert]

Most welcome

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

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

[@msantosh1220]

Forecasting study check
PK expert Check
Thank for this video

[@arnoldkilaini]

Marvelous

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@musicforlife5797]

good one!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@SaiRam00]

Good Thank You Sir...

[@PKAnExcelExpert]

Welcome

[@muthukrishnanbalasubramani2672]

Thanks 🎉

[@PKAnExcelExpert]

You're welcome 😊

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

[@khaleel26dubai]

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

[@mohammedembabi571]

Thank you dear

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Sheetalmanohar]

Awesome 😊😁

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@quanle6428]

thank men

[@PKAnExcelExpert]

Most welcome🙏

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

[@RIZKYIRELAND]

Thanks Sir

[@PKAnExcelExpert]

Welcome

[@sushilv2234]

Great

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@techsantoshkumar1756]

Nice job

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jimharding915]

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

[@rininsunnym]

Please help me to do 3 dimensional interpolations ( say X,Y and Z)

[@pramodbadgujar372]

Can I use for rejection predicted analysis

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

[@unicorn9472]

Very nice

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@lawrencejeffcarait4918]

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

[@tamalsaha8837]

I'm looking for an exact equation for "Linear Regression Extrapolation on Time-series spatial data". can anyone help me?

[@wojciechwisniewski2510]

very useful movie

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

[@ashishmohan4707]

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

[@sityebisimamkele434]

Can I use this approach to predict future rainfall?

[@anuragdubey84]

Create some content on hr attrition forecasting

[@PKAnExcelExpert]

Sure

[@iusmanasif]

how do i forecast with seasonality in the data?

[@chandrakr83]

very very good

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@chandrakr83]

l try this at home and more understand than before hahhaaha

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

[@muthuraja3128]

Nice

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@AHMADKELIX]

permission to learn sir

[@kkrishna9791]

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

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

[@pratikr3970]

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

[@heyrobined]

ctrl + 1 > accounting

[@prabhakergautam9204]

how you change the date format to value??

[@nipunfernando8373]

How did he change the date to the numbers? 10.01 Video

[@Amit-ki-Pathshala]

What if there will be an outliers?