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++ 💥
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
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.
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!
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
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
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?
sir please help me my problem is - Another persons explain his model - RSEI = 0.098*NDVI + 1.019*WET - 0.025*NDSI - 0.001*LST + 0.007 (R2 =0.998) 1. The WET must increase by 0.098 if the RSEI increase by 0.1. Nevertheless, the increased WET and the decreased LST occurred at the same time . 2. Therefore, RSEI increase will be more than 0.1. If the LST decrease by 0.098 and the WET increased by 0.098 the RSEI will increase by 0.10001. How its explain? My model is - RSEI = 0.9396*NDVI - 0.0074*WET - 0.22496*NDSI + 0.04665*LST + 0.0664 (R2 =1) So,1. If the RSEI increase by 0.1 then NDVI must increase ................? 2. RSEI will increase by 0.10001, Then LST decrease by .................? and NDVI increased by ..................................? How this model explain above mention two point? Please answer me. and help me.
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
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!!!
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
The most helpful explanation of a regression in Excel I've come across yet!
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.
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
Trying to figure this out for 2 weeks, explained in 11 mins, Legend !
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++ 💥
your videos are saving me in Stats class! Please keep them coming!
Thank you for this video. After days of stress I finally got a straight forward answer to my question. I totally understand now.
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)
He sounds like Ross from friends😂 great vid
Haha, yep.
Excellent video. Short, clear and to the point.
DUDE! Incredible video. Saved my butt. You explained it so well. You should get the tuition from the class I am taking.
Thank you, I think you just saved my final year business research.
Really helped in finding important information regarding regression in excel.
you saved my mental health, thank you very much!
You demystify regression! Amazing explanation.
THANK YOU! This just helped me in my grad school Research Methods & Statistics course!
Really helped in finding important information regarding regression in excel.your videos are saving me in Stats class!
GREAT............. GREAT ............ for an aged student like me.. Thank you..
You have saved me a whole day of hunting for answers. Thank you!!! and you also helped me to interpret the answers. Awesome !!!!
Absolutely brilliant, just what I needed, Thanks Jalayer
Yes, thank you! About to graduate and this was super helpful to finalize a group project.
I thanks God for this video. Be blessed Sir
Thank you sir for explaining it so beautifully.
Thanks , great explanation.
I think I need to listen more than one time.
Regards
Incredibly helpful, thank you!
Great Video keep it up dude- you are a natural teacher!
Very appreciated!! but how to make a report of the output of paarameter estimates using Mean plus or minus Standard error ..thank you
Very useful. I didn't know Excel came with multivariate regression.
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.
God bless you for this
Promptly Practical Hands On Learning
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!
great video! Now I wont fail my assignment ty.
Thank you! You broke this down so well.
Excellent! This video was soooooo helpful
Fantastic! Thanks a lot. You are a good teacher.
I found your videos really helpful. Doing my courseworks were much easier following your videos . Many thanks .
TQ so much for the crystal clear explaination
Easy to follow and practice. Thank you very much!
Thanks so much for this video! You're a life saver!
This is exactly what I wanted at the night before exam.
Thank you Sir.. very informative...❤️
Very clear. Well worth watching!
Thank you soo much . Amazing Video
Really helpful. Thanks a lot & keep going
Thank u so much, super informative
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
Very Useful! Thank you.
Very Informative video sir. I want to know the how to add " ADD IN" tab in excel?
Very helpful video. Thank you!
tnx a lot, you explained in an easy and clear way
Thanks you helped me completing my assgn:)
Very good explanation.
Amazing video, thank you!
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.
Very helpful, simple and well explained
Thank you very much, really helpful for me...now looking for more details
It is clear. Thx for sharing
Thank you sir, please do a video on multiple regression using Dummy Variable
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!
Thx. Excellent explanation, Thx
Super helpful! Thank you so much!
this is so helpful thanks!!!!
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?
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?
Thankyou ✨✨✨ I finally understand
keren bro
Best best the best.. thanks a lot sir...
Great video, thank you!
Insanely simple!!
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?
Super helpful! Thank you!
Thank you very much, sir.
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
Where did he get his alpha from is it just assumed???
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
very helpful, thanks.
Slowly starting to get this
very helpful!
So there’s only one column that is considered to be Y as the independent variable? Because I have like 7 different columns
Does a p-value above .05 for the intercept mean anything?
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!
Hi may i ask if I got like 400 entires of 3 independent variables how long does it usually take to show result?
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?
Thanks for nice Session, could you please explain about gamma values in this output
I like your excllent grip on xl
Thank you!
great matey
Great videos! Is there a way to find/search for sequential numbers in one column?
sir please help me
my problem is -
Another persons explain his model -
RSEI = 0.098*NDVI + 1.019*WET - 0.025*NDSI - 0.001*LST + 0.007 (R2 =0.998)
1. The WET must increase by 0.098 if the RSEI increase by 0.1. Nevertheless, the increased WET and the decreased LST occurred at the same time .
2. Therefore, RSEI increase will be more than 0.1. If the LST decrease by 0.098 and the WET increased by 0.098 the RSEI will increase by 0.10001.
How its explain?
My model is -
RSEI = 0.9396*NDVI - 0.0074*WET - 0.22496*NDSI + 0.04665*LST + 0.0664 (R2 =1)
So,1. If the RSEI increase by 0.1 then NDVI must increase ................?
2. RSEI will increase by 0.10001, Then LST decrease by .................? and NDVI increased by ..................................?
How this model explain above mention two point?
Please answer me. and help me.
That's good one!
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?
Excellent
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
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