VLOOKUP vs. INDEX(MATCH) Tutorial
13:06
Пікірлер
@tundralatriceivy8781
@tundralatriceivy8781 3 күн бұрын
I did it!!!!! I pass the test!!!!! Thank you!!!
@tundralatriceivy8781
@tundralatriceivy8781 3 күн бұрын
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 5 күн бұрын
Where i get the next video sir?
@alcappacino
@alcappacino 9 күн бұрын
If try this method though the usual method it gives me 18 days. I'm confused.
@jupingert
@jupingert 9 күн бұрын
Thank you for sharing your knowledge. Both the videos put together are really really clear.
@korirerick5066
@korirerick5066 10 күн бұрын
i have a question; how did you choose the intercept to be -2 and why does intercept be upon you to choose?
@mcanbolat
@mcanbolat 9 күн бұрын
I just used arbitrary numbers first. The optimal values were found later.
@asaadamjad2076
@asaadamjad2076 11 күн бұрын
Thank you man really helpful
@salekbinislam2008
@salekbinislam2008 12 күн бұрын
Y= log (odds)= b0+b1x1
@PradeepRamesh-ew7uh
@PradeepRamesh-ew7uh 16 күн бұрын
Simple to understand and Great video
@karuneshgaikwad9687
@karuneshgaikwad9687 16 күн бұрын
Please take large example 😢😢
@ammarwrites4933
@ammarwrites4933 17 күн бұрын
Thanks 🙏
@LongNguyen-jj1hb
@LongNguyen-jj1hb 17 күн бұрын
this is gantt char?
@esee001
@esee001 17 күн бұрын
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 20 күн бұрын
Such a helpful vid, many thanks.
@4FACT-YOU
@4FACT-YOU 23 күн бұрын
You prounce " To " very nicely
@OmaymanAbdelmajid
@OmaymanAbdelmajid 25 күн бұрын
How can I get the full file
@OmaymanAbdelmajid
@OmaymanAbdelmajid 25 күн бұрын
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!
@elmakkaouymohamed8807
@elmakkaouymohamed8807 Ай бұрын
thank you
@emilytran84
@emilytran84 Ай бұрын
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 Ай бұрын
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 Ай бұрын
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 2 ай бұрын
Very good explanation, thank you for the great effort!!!
@yaramostafa6319
@yaramostafa6319 2 ай бұрын
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 2 ай бұрын
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 2 ай бұрын
Thank you so much! Well explained.@@mcanbolat
@SakshiSingh-px4ss
@SakshiSingh-px4ss 2 ай бұрын
Thank you so much this helped me in my exams..❤
@tarba2ha-885
@tarba2ha-885 2 ай бұрын
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.
@mommheenonghi8063
@mommheenonghi8063 3 ай бұрын
Thank you very much , I got it now!
@kavyaanand6460
@kavyaanand6460 3 ай бұрын
Thanks for Video!!! Average of()/Average() Seasonal Index in formula if some SKU i dont have last year same month data then forecast will get 0, how we can calculate
@frustrategirl
@frustrategirl 4 ай бұрын
how have you done for 2017? please explain
@frustrategirl
@frustrategirl 4 ай бұрын
in a textile industry, a machine fail at 5 per hour and cost of non productive machine is 400 per hour. A repairman charges 400 per hour and repair at 6 per hour. What will be the total queuing cost per hour? Assume M/M/1 queuing system. Please solve this question
@vivekkumar-py6kp
@vivekkumar-py6kp 4 ай бұрын
But I am having a doubt .In project duration you did not included all the task since all the task are required.
@cryssstalz
@cryssstalz 4 ай бұрын
Shouldnt there be a fictitious task from B to C and then from C to E?
@mcanbolat
@mcanbolat 4 ай бұрын
That is for the Activity on Arc (AOA) representation.