VLOOKUP vs. INDEX(MATCH) Tutorial
13:06
Пікірлер
@fayezqadir7155
@fayezqadir7155 7 сағат бұрын
Can u make a video on sales forecsating?
@mohamedyahia3069
@mohamedyahia3069 4 күн бұрын
great
@RajuDc-ml5st
@RajuDc-ml5st 4 күн бұрын
I Love you brooooo thanks for your help to understand problems ❤❤❤
@Siteplusberries165
@Siteplusberries165 6 күн бұрын
what is the critical path
@AriaSeymour97
@AriaSeymour97 8 күн бұрын
A tip my hat for this man, he basically summarized 20 pages in a video that is less than 10 minutes 👏
@arupmukherjee2010
@arupmukherjee2010 9 күн бұрын
Wonderful
@tundralatriceivy8781
@tundralatriceivy8781 13 күн бұрын
I did it!!!!! I pass the test!!!!! Thank you!!!
@tundralatriceivy8781
@tundralatriceivy8781 13 күн бұрын
Out of ALL the examples I have seen, this is the BEST example for calculating the critical path(s). I agree with the comments below, the textbook nor the instructor's guidance did not help me. This is so understandable and clear. I am glad I stumbled on this video. Thank you!
@wahyuaja3214
@wahyuaja3214 15 күн бұрын
Where i get the next video sir?
@alcappacino
@alcappacino 18 күн бұрын
If try this method though the usual method it gives me 18 days. I'm confused.
@jupingert
@jupingert 19 күн бұрын
Thank you for sharing your knowledge. Both the videos put together are really really clear.
@korirerick5066
@korirerick5066 19 күн бұрын
i have a question; how did you choose the intercept to be -2 and why does intercept be upon you to choose?
@mcanbolat
@mcanbolat 19 күн бұрын
I just used arbitrary numbers first. The optimal values were found later.
@asaadamjad2076
@asaadamjad2076 21 күн бұрын
Thank you man really helpful
@salekbinislam2008
@salekbinislam2008 21 күн бұрын
Y= log (odds)= b0+b1x1
@PradeepRamesh-ew7uh
@PradeepRamesh-ew7uh 25 күн бұрын
Simple to understand and Great video
@karuneshgaikwad9687
@karuneshgaikwad9687 26 күн бұрын
Please take large example 😢😢
@ammarwrites4933
@ammarwrites4933 27 күн бұрын
Thanks 🙏
@LongNguyen-jj1hb
@LongNguyen-jj1hb 27 күн бұрын
this is gantt char?
@princesstashinga2014
@princesstashinga2014 7 күн бұрын
Noo this is a network diagram
@esee001
@esee001 27 күн бұрын
This is great! Thank you for your video! What do you do with forecasted negative values? Obviously, I cannot have -4 units produced.
@thirushenpakiry6103
@thirushenpakiry6103 Ай бұрын
Such a helpful vid, many thanks.
@4FACT-YOU
@4FACT-YOU Ай бұрын
You prounce " To " very nicely
@OmaymanAbdelmajid
@OmaymanAbdelmajid Ай бұрын
How can I get the full file
@OmaymanAbdelmajid
@OmaymanAbdelmajid Ай бұрын
Thanks for this usefull video, how can I download the complete file, the one in the link is not
@emilytran84
@emilytran84 Ай бұрын
Thank you for your great video! Will negative Slope affect to the forecast sir. I tried to share my data and appreciate if you have time to have a look and advise. Thanks docs.google.com/spreadsheets/d/140Xm2oPHPcfksISBcQjKJsWPF13Z2qII/edit?usp=drive_link&ouid=105276587916707361186&rtpof=true&sd=true
@dogaloglu
@dogaloglu Ай бұрын
You had a great Job!
@astnowkachannel636
@astnowkachannel636 Ай бұрын
As I understand it, this method isn't work if my production quantity is limited to, for example, 100 o have deficit in some monthes? Or I'm wrong?
@adhilrambridge2233
@adhilrambridge2233 Ай бұрын
I was not aware of the last step of needing to drag the data down. I thought F2 will be your final forecast.
@drinkbeerandchillwithmzohm4507
@drinkbeerandchillwithmzohm4507 Ай бұрын
You should get an award for this video sir 🙌🏿🙌🏿🙌🏿
@rishiiiii.28
@rishiiiii.28 Ай бұрын
got it ❤ thanks
@Hella-fp2po
@Hella-fp2po Ай бұрын
Crystal clear understanding sir ❤❤
@eraditortv
@eraditortv Ай бұрын
We were looking for the regression method
@mcanbolat
@mcanbolat Ай бұрын
There is a video on that, too.
@eraditortv
@eraditortv Ай бұрын
@@mcanbolat thanks
@NIKHILSHARMA-ni5uo
@NIKHILSHARMA-ni5uo Ай бұрын
Tq sir🙏🌷✨
@anjuy8413
@anjuy8413 Ай бұрын
Thank you!
@ElMakk_Med
@ElMakk_Med Ай бұрын
thank you
@emilytran84
@emilytran84 2 ай бұрын
Thank you so much for your great video, Sir ! How to fix formular if some months in period have no quantity (=0) or null? Is available to get different format (color, style) for forecast line in chart which is similar to use forecast sheet? Appreciate your advice !
@mcanbolat
@mcanbolat 2 ай бұрын
Hi, you can replace them with 1. The forecast may not be accurate when you have a large number of missing values. You can manually adjust the color, or you will need to write a VBA code.
@emilytran84
@emilytran84 Ай бұрын
@@mcanbolat Appreciate your answer. By your exert knowledge, how do you think this compare to regression forecast thru excel toolpak since I found very different result. Thank you !
@mohsinali4783
@mohsinali4783 2 ай бұрын
And what is the TOTAL SLACK?
@tingey9291
@tingey9291 2 ай бұрын
Thank you very much for sharing this in depth tutorial, it has proven to be invaluable to me. I wanted to ask, if possible, after determining the efficacy of the model, would you be willing to publish a tutorial detailing how this can be utilised in predictive practice? Your time and consideration would be appreciated.
@kiaanmaharaj
@kiaanmaharaj 2 ай бұрын
Why did you use log() instead of ln()
@NDMi
@NDMi 2 ай бұрын
Thank you 💕
@Frenchkisssss
@Frenchkisssss 2 ай бұрын
How do calculate the ideal number of k clusters ? Is their a method for that ?
@mcanbolat
@mcanbolat 2 ай бұрын
Yes, please search for the Elbow Method. You will need to use a different software such as R or Python to efficiently use that. This video just explains the idea of clustering.
@Frenchkisssss
@Frenchkisssss 2 ай бұрын
@@mcanbolat Thank you, also i'm trying to cluster customers based on their electric and natural gas consumption = 2 variables. How can i do that ? You mentioned a part 2 where you would explain how to cluster multiple variables. I was not able to find it.
@karthick2254
@karthick2254 3 ай бұрын
Very good explanation, thank you for the great effort!!!
@yaramostafa6319
@yaramostafa6319 3 ай бұрын
Hello, does it matter which month we choose as baseline? Does it affect the results? Also, I dont get why you chose the average of the month and not the total demand per month. Also, for November the p-value is greater than 0.05, does it mean that November doesn't have a significant effect on December baseline? Do we need to remove it from the variables then? Because in other forms of variables, the insignificant variable on the "y" is usually removed. Thanks!
@mcanbolat
@mcanbolat 3 ай бұрын
Hi, 1. No, any month could be a baseline. 2. Average is used because some months have more occurences than others. 3. All of those month dummy variables are part of a single variable. You don’t remove them. It means that November sales are not significantly different from December sales.
@yaramostafa6319
@yaramostafa6319 3 ай бұрын
Thank you so much! Well explained.@@mcanbolat
@SakshiSingh-px4ss
@SakshiSingh-px4ss 3 ай бұрын
Thank you so much this helped me in my exams..❤
@tarba2ha-885
@tarba2ha-885 3 ай бұрын
I dislike KZbin because it enables anyone, regardless of their expertise, to upload content. This makes it challenging for us to find brilliant individuals who can explain a 2-hour lecture concisely in just 9 minutes. Thank you.
@jonasbaine3538
@jonasbaine3538 2 ай бұрын
Underrated comment. I was seriously confused until this video explained it perfectly.
@ashutoshdubey9713
@ashutoshdubey9713 3 ай бұрын
Thanks
@ZAMeliodasGaming
@ZAMeliodasGaming 3 ай бұрын
how to get demand in 2017?
@sonamdhendup2382
@sonamdhendup2382 3 ай бұрын
THANK YOU WAS VERY HELPFUL.
@joydeepdutta5216
@joydeepdutta5216 3 ай бұрын
Thanks a lot sir
@Victor-ed4ls
@Victor-ed4ls 3 ай бұрын
He sounds like the educated version of XQC
@rezatadayon1082
@rezatadayon1082 3 ай бұрын
Thank you for the video, It was helpful for me. I have three questions, 1) Are those three columns (Length, Width, actual color )are dataset? and in real project we need to have calculated data somewhere into the database? 2) You added two columns H1 and H2 as hidden layer, But there is no any calculation that use H1 and H2 as parameter , What is the point to have those new columns. Thanks
@mcanbolat
@mcanbolat 3 ай бұрын
Hi yes, 1. This is a supervised model, meaning that you will have a dataset with predictor variables (inputs) and a response variable (output). By using a neural network model, you can capture the non-linear relationships between these variables. 2. If you look at the model carefully, the hidden layers are used in the model (H1 to C and H2 to C weights). They help model the nonlinear relationships between the inputs and the output.