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++ 💥
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 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
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.
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?
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!
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
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 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!
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?
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.
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?
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.
Hi I want to Test the effect of income (x1) and Purchasing habit score of city (x2) & Gender ( Dummy v.) on Frequent payments( y). Then, in regression I have Durbin- watson value of 1.4725. So, is the model reliable ?? can I report the result ?. Thanks
i want site for downloading data set,please...tow data sets for the same studies to compare between tow multiple regression models...i need it for my thesis ..
thank you this is very helpful! I was thrown out in the ocean and asked to create regression analysis and I don't have any idea about it so I went to ytube and check there are alot of vids but I can't understand them until this one so thank you!
![ละลาย (LALALYE) - DAOU PITTAYA ต้าห์อู๋ พิทยา [OFFICIAL MV]](http://i.ytimg.com/vi/wo6r9TgausI/mqdefault.jpg)
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
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
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!!!
My professors all failed to teach me this over my entire masters, hats off to you sir you convey tons of information so succinctly!
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
doing gods work, even 8 years later. ty so much.
The most helpful explanation of a regression in Excel I've come across yet!
Trying to figure this out for 2 weeks, explained in 11 mins, Legend !
Thank you for this video. After days of stress I finally got a straight forward answer to my question. I totally understand now.
your videos are saving me in Stats class! Please keep them coming!
you saved my mental health, thank you very much!
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++ 💥
Thank you, I think you just saved my final year business research.
Excellent video. Short, clear and to the point.
You demystify regression! Amazing explanation.
He sounds like Ross from friends😂 great vid
Haha, yep.
You have saved me a whole day of hunting for answers. Thank you!!! and you also helped me to interpret the answers. Awesome !!!!
Really helped in finding important information regarding regression in excel.
GREAT............. GREAT ............ for an aged student like me.. Thank you..
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)
Yes, thank you! About to graduate and this was super helpful to finalize a group project.
Really helped in finding important information regarding regression in excel.your videos are saving me in Stats class!
DUDE! Incredible video. Saved my butt. You explained it so well. You should get the tuition from the class I am taking.
Absolutely brilliant, just what I needed, Thanks Jalayer
Thank you sir for explaining it so beautifully.
THANK YOU! This just helped me in my grad school Research Methods & Statistics course!
I thanks God for this video. Be blessed Sir
Great Video keep it up dude- you are a natural teacher!
great video! Now I wont fail my assignment ty.
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
Fantastic! Thanks a lot. You are a good teacher.
Very Informative video sir. I want to know the how to add " ADD IN" tab in excel?
Very useful. I didn't know Excel came with multivariate regression.
Promptly Practical Hands On Learning
God bless you for this
This is exactly what I wanted at the night before exam.
Thank you! You broke this down so well.
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 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
Really helpful. Thanks a lot & keep going
Incredibly helpful, thank you!
Excellent! This video was soooooo helpful
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.
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!
Thank you sir, please do a video on multiple regression using Dummy Variable
Easy to follow and practice. Thank you very much!
I found your videos really helpful. Doing my courseworks were much easier following your videos . Many thanks .
Thank you Sir.. very informative...❤️
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?
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?
TQ so much for the crystal clear explaination
Very clear. Well worth watching!
How can I select the Input X range for a large sheet :( ?
Where did he get his alpha from is it just assumed???
Very good explanation.
Thanks so much for this video! You're a life saver!
I like your excllent grip on xl
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?
Thanks for nice Session, could you please explain about gamma values in this output
Very helpful, simple and well explained
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
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
Great videos! Is there a way to find/search for sequential numbers in one column?
So there’s only one column that is considered to be Y as the independent variable? Because I have like 7 different columns
keren bro
Thank you very much, really helpful for me...now looking for more details
tnx a lot, you explained in an easy and clear way
Insanely simple!!
Hi may i ask if I got like 400 entires of 3 independent variables how long does it usually take to show result?
Does a p-value above .05 for the intercept mean anything?
Thanks you helped me completing my assgn:)
Best best the best.. thanks a lot sir...
Very helpful video. Thank you!
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!
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?
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.
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?
Very Useful! Thank you.
Slowly starting to get this
Thank you soo much . Amazing Video
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
Thank u so much, super informative
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
Nice. What is the actual statistic we compute to test whether at least one of the Betas is nonzero?
I know I am late, can this be a good approach in predicting crop yield
Hi
I want to Test the effect of income (x1) and Purchasing habit score of city (x2) & Gender ( Dummy v.) on Frequent payments( y). Then, in regression I have Durbin- watson value of 1.4725. So, is the model reliable ?? can I report the result ?.
Thanks
It is clear. Thx for sharing
i want site for downloading data set,please...tow data sets for the same studies to compare between tow multiple regression models...i need it for my thesis ..
Amazing video, thank you!
i want kown which version is thAT FROMEXCEL I DONT HAVE DATA ANALYSIS
Thankyou ✨✨✨ I finally understand
thank you this is very helpful! I was thrown out in the ocean and asked to create regression analysis and I don't have any idea about it so I went to ytube and check there are alot of vids but I can't understand them until this one so thank you!
Thank you.
Please I need a solution to the below question I'll send in now.
What version of Excell do you use? I can't find the regression tab.
from where he got .05 for alpha >?!
same question
Thx. Excellent explanation, Thx
very helpful!
Thank you very much, sir.
Super helpful! Thank you so much!