Thanks in a million! Very well explained. This is the nth time that I am watching this again. Great content. Awesome. I couldn't find this explanation--simply put anywhere else. “Great teachers are hard to find”. Grade: A++ 💥
thanks a lot, it was very helpful! but just a short question. what if i receive negative t-statistic but signficant p-value? is excel using a one-tail t-test within the regression? thanks in advance!
This is a great video ! Really well explained and easy to follow. However when I run my multiple regression all my p values show as #NUM!, but when I do all variables one by one the p values are normal - does anyone know how to fix this? Thanks!
Very well explained, the only question is how did you calculate alpha? And regression model is getting inaccurate if i use one year data, why is it so?
In a question I have 3 independent variables and in the f-test I conducted I found that only two of them are useful. Does this mean i have to create another summary output with just the two of them, or just leave the regression equation as it is but without the insignificant variable?
It is a great question! It's a statistical conventional approach to further drop the nonsignificant variables and rerun the regression analysis so as improve on it's statistical power. Thanks
Hi, Thanks for the practical video. I have a question. What if we get a significant F (like 0.009) but not a significant P-value in variables (0.3 and 0.07)?
If it is a simple linear regression model, once the F-test is significant then the one predictor variable will be significant as well. However, if there exists many predictor variables such a very rare case is possible to happen where no predictor variable is significant. Therefore, you can just conclude that your model is better to relatively a no model at all (model without independent variables) but you can add that unfortunately none of the predictors could significantly explain a variation in the outcome variable.
Awesome explanation! Amazing video! Am confident that am gonna ace my finals.,and an interesting coincidence, today is APRIL 14th, its my birthday today :) same day you uploaded this video a couple of years ago.
I really like your videos but, could you provide a link to the data sets so that we can follow along without having to spend time freezing the video so that we can type the data into our computers? Thanks for your work and effort
Help me... My lecturer asked me the error of the regression.. may i know which one i need to take? because i only have standard error for each intercept and x^1 and x^2 ? And how this error related to x and y variable?
I have a data set with 15 animals with weights over time, measured at the same 12 time points. how can i use excel to analyze single regression. it seems to want me to repeat time values (x) for each separate weight (y) so it is in two columns. this is impractical obviously. can i select a matrix of y values and pair it with the x values? thanks.
Hi Jalayer, I have one question. Im using this model on a customer satisfaction survey by putting overal satisfaction 1-5 (or 0-10 points) as Y and different touchpoints as the Xs. I just want to understand the relative weight of the coeficients and I have seen some studies where this relative weight among the coeficientes (the variables) is expressed as a percentage (of course over 100%). Do you know how to do this? could you please help me? Thanks
You need to build a simple regression analysis for your data and look for the R square to determine the % impact of one variable on your target variable. For eg- The conclusion that the carat of a diamond has an 85% impact on its price is calculated by getting a correlation analysis between carat range and price range. If R square is 0.8508, you can conclude that carat impacts 85% of the price of a diamond. Hope this helps.
Needed help of how to run regression while weighting the dependent variable.....example if My dependent variables are not representing the universe. If the observation are 100 and 50 samples are males and 50 samples are female in the universe but the data collected is of 60 males and 40 males, how do I get the right a regression which matches the universe at in 50:50 ratio and not 60:40. SPSS has n option of weighting but how to do the same in excel?
OK so now I'm even more confused! I'm new to linear regression and from what I've been taught about the multiple regression model (Y= Bo +(B1*Y1)+(B2*Y2) ----- +e). The example you gave didn't clarify what dependent variable represented B1 or B2, even more naming your linear predictors X1, X2, and X3 really confused me. Is there a way you can please clarify what values represents each individual variable? IE: Bo =Intercept, B1=?, X1+? B2=? X2=? and so on. Any help would be greatly appreciated. V/R David
This. Saved my academic life. I learned more in this video than I did in 2 semesters of College level Stats. Amazing
Right?!! Very Thankful for Jalayer Academy videos!
Do you have a job now ?
This saved my semester final🤓
👌
For sure
This saved my life. I have to submit my assignments tonight and I can’t imagine what I would do if I couldn’t find your video. Thank you soooo much!!!
your videos are saving me in Stats class! Please keep them coming!
The most helpful explanation of a regression in Excel I've come across yet!
You have saved me a whole day of hunting for answers. Thank you!!! and you also helped me to interpret the answers. Awesome !!!!
Thank you for this video. After days of stress I finally got a straight forward answer to my question. I totally understand now.
Thanks in a million! Very well explained. This is the nth time that I am watching this again. Great content. Awesome. I couldn't find this explanation--simply put anywhere else. “Great teachers are hard to find”. Grade: A++ 💥
Trying to figure this out for 2 weeks, explained in 11 mins, Legend !
My professors all failed to teach me this over my entire masters, hats off to you sir you convey tons of information so succinctly!
doing gods work, even 8 years later. ty so much.
Thank you, I think you just saved my final year business research.
Really helped in finding important information regarding regression in excel.
Yes, thank you! About to graduate and this was super helpful to finalize a group project.
You demystify regression! Amazing explanation.
I literally used this to predict the stock price moving forward 1 year in my finance job. THANKS A LOT!!!!
would you kindly elaborate? HAHA
Excellent video. Short, clear and to the point.
He sounds like Ross from friends😂 great vid
Haha, yep.
Fantastic! Thanks a lot. You are a good teacher.
Absolutely brilliant, just what I needed, Thanks Jalayer
Really helped in finding important information regarding regression in excel.your videos are saving me in Stats class!
I found your videos really helpful. Doing my courseworks were much easier following your videos . Many thanks .
Thank you sir for explaining it so beautifully.
i have a master degree in data analyst and this video is awesome you took the best way to explain regression model simply .thanks keep up
Easy to follow and practice. Thank you very much!
DUDE! Incredible video. Saved my butt. You explained it so well. You should get the tuition from the class I am taking.
THANK YOU! This just helped me in my grad school Research Methods & Statistics course!
Great videos! Is there a way to find/search for sequential numbers in one column?
Thank you! You broke this down so well.
Thank you, my reexamination is tomorrow, and you just explained what a year in class couldn't
Hope, you passed your reexamination (ignore the bad pun lmao)
Thank you so much! this helps me a lot in one of my statistical paper that i need to submit tomorrow lol! you explained it pretty well too!
God bless you for this
great video! Now I wont fail my assignment ty.
Thank you very much, really helpful for me...now looking for more details
Incredibly helpful, thank you!
Very clear. Well worth watching!
Excellent! This video was soooooo helpful
Thanks so much for this video! You're a life saver!
If you throw out certain x's, do you have to rerun the model? Is it necessary, or can you predict y with only the x's that are significant enough?
Great Video keep it up dude- you are a natural teacher!
you saved my mental health, thank you very much!
Very helpful, simple and well explained
Nice. What is the actual statistic we compute to test whether at least one of the Betas is nonzero?
Super helpful! Thank you so much!
I like your excllent grip on xl
What version of Excell do you use? I can't find the regression tab.
Insanely simple!!
thanks a lot, it was very helpful! but just a short question. what if i receive negative t-statistic but signficant p-value? is excel using a one-tail t-test within the regression? thanks in advance!
Thanks , great explanation.
I think I need to listen more than one time.
Regards
Very appreciated!! but how to make a report of the output of paarameter estimates using Mean plus or minus Standard error ..thank you
tnx a lot, you explained in an easy and clear way
This is a great video ! Really well explained and easy to follow. However when I run my multiple regression all my p values show as #NUM!, but when I do all variables one by one the p values are normal - does anyone know how to fix this? Thanks!
Same here, have some problem on #NUM!, anyone can help regarding this?
This is exactly what I wanted at the night before exam.
Very useful. I didn't know Excel came with multivariate regression.
Super helpful! Thank you!
Thank you very much, sir.
Very well explained, the only question is how did you calculate alpha? And regression model is getting inaccurate if i use one year data, why is it so?
Very helpful video. Thank you!
In a question I have 3 independent variables and in the f-test I conducted I found that only two of them are useful. Does this mean i have to create another summary output with just the two of them, or just leave the regression equation as it is but without the insignificant variable?
It is a great question! It's a statistical conventional approach to further drop the nonsignificant variables and rerun the regression analysis so as improve on it's statistical power.
Thanks
Thanks for nice Session, could you please explain about gamma values in this output
I know I am late, can this be a good approach in predicting crop yield
Really helpful. Thanks a lot & keep going
Hi, Thanks for the practical video. I have a question. What if we get a significant F (like 0.009) but not a significant P-value in variables (0.3 and 0.07)?
If it is a simple linear regression model, once the F-test is significant then the one predictor variable will be significant as well. However, if there exists many predictor variables such a very rare case is possible to happen where no predictor variable is significant. Therefore, you can just conclude that your model is better to relatively a no model at all (model without independent variables) but you can add that unfortunately none of the predictors could significantly explain a variation in the outcome variable.
I thanks God for this video. Be blessed Sir
Awesome explanation! Amazing video! Am confident that am gonna ace my finals.,and an interesting coincidence, today is APRIL 14th, its my birthday today :) same day you uploaded this video a couple of years ago.
GREAT............. GREAT ............ for an aged student like me.. Thank you..
I really like your videos but, could you provide a link to the data sets so that we can follow along without having to spend time freezing the video so that we can type the data into our computers? Thanks for your work and effort
Best best the best.. thanks a lot sir...
very helpful!
Very Useful! Thank you.
Help me... My lecturer asked me the error of the regression.. may i know which one i need to take? because i only have standard error for each intercept and x^1 and x^2 ? And how this error related to x and y variable?
That's good one!
Great video, thank you!
Thanks you helped me completing my assgn:)
TQ so much for the crystal clear explaination
Thank you sir, please do a video on multiple regression using Dummy Variable
Does a p-value above .05 for the intercept mean anything?
I have a data set with 15 animals with weights over time, measured at the same 12 time points.
how can i use excel to analyze single regression. it seems to want me to repeat time values (x) for each separate weight (y) so it is in two columns. this is impractical obviously.
can i select a matrix of y values and pair it with the x values?
thanks.
How do you get the Y formula ?
Slowly starting to get this
You just saved me bro!
Hi Jalayer, I have one question.
Im using this model on a customer satisfaction survey by putting overal satisfaction 1-5 (or 0-10 points) as Y and different touchpoints as the Xs.
I just want to understand the relative weight of the coeficients and I have seen some studies where this relative weight among the coeficientes (the variables) is expressed as a percentage (of course over 100%).
Do you know how to do this? could you please help me?
Thanks
You need to build a simple regression analysis for your data and look for the R square to determine the % impact of one variable on your target variable. For eg- The conclusion that the carat of a diamond has an 85% impact on its price is calculated by getting a correlation analysis between carat range and price range. If R square is 0.8508, you can conclude that carat impacts 85% of the price of a diamond. Hope this helps.
@@Dietitionist.official thank you very much
Where did he get his alpha from is it just assumed???
Needed help of how to run regression while weighting the dependent variable.....example if My dependent variables are not representing the universe. If the observation are 100 and 50 samples are males and 50 samples are female in the universe but the data collected is of 60 males and 40 males, how do I get the right a regression which matches the universe at in 50:50 ratio and not 60:40. SPSS has n option of weighting but how to do the same in excel?
Thank you Sir.. very informative...❤️
Thank You!!!
i want kown which version is thAT FROMEXCEL I DONT HAVE DATA ANALYSIS
Promptly Practical Hands On Learning
Hi may i ask if I got like 400 entires of 3 independent variables how long does it usually take to show result?
Is there a rule for alfa for the p-value test of the single independent variables? How do you pick the alfa?
researchers choose alpha at the start of their study to control for TYPE 1 Error
OK so now I'm even more confused! I'm new to linear regression and from what I've been taught about the multiple regression model (Y= Bo +(B1*Y1)+(B2*Y2) ----- +e). The example you gave didn't clarify what dependent variable represented B1 or B2, even more naming your linear predictors X1, X2, and X3 really confused me. Is there a way you can please clarify what values represents each individual variable? IE: Bo =Intercept, B1=?, X1+? B2=? X2=? and so on. Any help would be greatly appreciated.
V/R
David
How can I select the Input X range for a large sheet :( ?
What to do if I have a moderator variable?
So helpful!
Thankyou ✨✨✨ I finally understand
this is so helpful thanks!!!!
Excellent
So there’s only one column that is considered to be Y as the independent variable? Because I have like 7 different columns
Very good explanation.
Thank u so much, super informative
Thank you soo much . Amazing Video