Forecasting in Excel using Linear Regression
ฝัง
- เผยแพร่เมื่อ 8 ธ.ค. 2019
- #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/...
You have a unique way of explaining which can be easily understood!!
Waiting for further forecasting videos!!
Thank you, PK !!
Thanks for your valuable feedback
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,
THANKS!!!!!! YOU EXPLAINED THIS WAY BETTER THAN MY PROFESSOR!!!
Thanks for your valuable feedback
one of the best video on regression so far, please keep up the good work
Thank you very helpful ☺ for stepping in the worlds of analytics for new aspirants. greatly explained thanks for sharing and helping 🙏
Thank you for the tutorial! Stay safe and well! 😊
Thanks for your valuable feedback
I love your works. Thank you for all you do. I hit this when I really needed it
Thanks for your valuable feedback
Amazing!!!!!!....Tank you..... Best Regards from mexico.
Thank you so much! You explained the concept so well and patiently!
Thanks for your valuable feedback
Hi, can you help me to explain how we exchange date to number at 10:03?
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.
Thank you very much!! you explained well
Thank you, PK !!!
Great video!
Thanks for your valuable feedback
Nicely explained. Easy and simple. Thank You!
Thanks for your valuable feedback
Your every video has unique things which we never know before. Thank you PK
Thanks for your valuable feedback
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...
Thank you, you explained this better than my university professor!
Hi, can you help me to explain how we exchange date to number at 10:03?
Great presentation. Thank you very much!!
Thanks for your valuable feedback
Thank you for sharing your knowledge with us. Much love
Thanks
Very helpful! Thanks!
Thanks for your valuable feedback
Thank you! This is so helpful!
Most welcome🙏
Super useful! Thanks a lot
Thanks for your valuable feedback
simple to understand! Thanks
Glad you liked it!
Lovely , very well explained video
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
thank for 4 we can use the LINEST function which is a matrix function
on two adjacent cells to detreminate a and b
You are brilliant. Thank You.
Thanks for your valuable feedback
Thank you! Nicely done.
Thanks for your valuable feedback🙏
Excellent Sir. Thanks for sharing the knowledge.
Thanks for your valuable feedback
very well explained . thank you so much
Thanks for your valuable feedback
Hats off to u PK no body can beat u
Thanks for your valuable feedback
I like it, interesting!Thanks a lot!
Thanks for your valuable feedback
Awesome job, thanks 👍👍👍
Thanks for your valuable feedback
Very nice explanation. Thank you so much
Thanks for your valuable feedback
u r a real hero... a lot behind this word for me... but that much is enough to say...
Thanks for your valuable feedback🙏
Great explanation.Very very helpful.
Thanks
Hi Good one.. you have explained it very clearly .. eagerly waiting for your next forecast video.. as I am working data which is consistence.
Thanks for your valuable feedback
Thank you !!!!!
Thanks for your valuable feedback
Beautifully explained
Thanks for your valuable feedback🙏
Nice explained, Thank you so much.
You are welcome
Fantastic explanation!! 🙏
Thanks🙏
Thank you so much.
You're welcome!
Thankyou so much !
Welcome
Nice man! Thank u so much
Thanks for your valuable feedback
Thanks it is very useful 😊
Thanks for your valuable feedback
Love the intro
Thanks
How did you fill in the results in the forecast columns?
Very nicely explained..great ....thanks
Thanks for your valuable feedback
Excellent explanation. I like it.👍
Thanks for your valuable feedback
nailed it, thanks
Thanks for your valuable feedback
So helpufl. Thank you.
Most welcome
great video thank you
Thanks for your valuable feedback
Awesome approach 👍👍 good one 👏👏👏👏
Thanks for your valuable feedback
hi, well explained. do you have any forecasting video where the data points have outliers and seasonality?
Simply amazing sir
Thanks for your valuable feedback🙏
Thank you so much
Most welcome
Thank you this will help me for my current work
Thanks for your valuable feedback
@@PKAnExcelExpertpls suggest forecast method if volume has seasonality , irregular trend
Thank you very much sir
Most welcome
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. :)
Forecasting study check
PK expert Check
Thank for this video
I'm looking for an exact equation for "Linear Regression Extrapolation on Time-series spatial data". can anyone help me?
Marvelous
Thanks for your valuable feedback
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
Beautifully explained PK sir. Can I request you to create a video on Markov Analysis for workforce planning?
Very Informative
Glad it was helpful!
Great. and Helpful, thanks, Sir.
Most welcome!
@@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.
Thanks 🎉
You're welcome 😊
Thank you dear
Thanks for your valuable feedback
Good Thank You Sir...
Welcome
Awesome work bro!
Thanks for your valuable feedback
Can I use for rejection predicted analysis
good one!
Thanks for your valuable feedback
how do i forecast with seasonality in the data?
thank men
Most welcome🙏
great sir, PK
Thanks
Good one...👍🏽
Thanks🙏
Please help me to do 3 dimensional interpolations ( say X,Y and Z)
Freaking great video!!!
Thanks for your valuable feedback
@@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?
Is there a tutorial for having a outliner sir? Thank you
Hello sir have u complete series regression and correlation kindly let me know
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
Thanks Sir
Welcome
Awesome 😊😁
Thanks for your valuable feedback
Nice job
Thanks for your valuable feedback
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?
Can I use this approach to predict future rainfall?
Great
Thanks for your valuable feedback
What did you do to change the format for Forecast 3 when date shows up?
ctrl + 1 > accounting
Hello sir, Can we apply it y=mx+c for stock market forecast. Please help
Very nice
Thanks for your valuable feedback
very useful movie
Thanks for your valuable feedback
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 ??
I would like to see it too
Im also trying to find that
What if there will be an outliers?
How you dothe formatting part when the date value appears as a result of an equation?please help
ctrl + 1 > accounting
t
Can you also share how did you got the forecasted numbers on the chart
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.
very very good
Thanks for your valuable feedback
l try this at home and more understand than before hahhaaha
what if there is an outlier, how to handle it? thank you in advance.
Will create a separate video on this topic
@@PKAnExcelExpert has the video been created?
You have a unique way of explaining which can be easily understood. how did you change the formats, 28-Aug-00 to 421.37079?
get an answer?
I think format has been changed from date to number !
How did he change the date to the numbers? 10.01 Video
how you change the date format to value??
Nice
Thanks for your valuable feedback