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.
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!
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 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.
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.
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
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
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?
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?
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 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.
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
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 ..
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?
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!
Trying to figure this out for 2 weeks, explained in 11 mins, Legend !
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
ThankYou!!
You should not have recorded the video while you were sleepy
He sounds like Ross from friends😂 great vid
Haha, yep.
your videos are saving me in Stats class! Please keep them coming!
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++ 💥
Very appreciated!! but how to make a report of the output of paarameter estimates using Mean plus or minus Standard error ..thank you
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!!!
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)
The most helpful explanation of a regression in Excel I've come across yet!
Thank you sir for explaining it so beautifully.
Where did he get his alpha from is it just assumed???
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.
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?
Really helped in finding important information regarding regression in excel.
God bless you for this
Thank you for this video. After days of stress I finally got a straight forward answer to my question. I totally understand now.
DUDE! Incredible video. Saved my butt. You explained it so well. You should get the tuition from the class I am taking.
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
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
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?
Excellent! This video was soooooo helpful
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.
Promptly Practical Hands On Learning
keren bro
Very Informative video sir. I want to know the how to add " ADD IN" tab in excel?
Incredibly helpful, thank you!
You demystify regression! Amazing explanation.
I wish I'd seen this while taking econometrics .. I'd have less white hair now
Thank you.
Please I need a solution to the below question I'll send in now.
Slowly starting to get this
See this video also;
ruclips.net/video/0TsYyJS2NhM/видео.html
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
great video! Now I wont fail my assignment ty.
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.
Thank you, I think you just saved my final year business research.
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
Thank u so much, super informative
very helpful!
Thank you soo much . Amazing Video
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
THANK YOU! This just helped me in my grad school Research Methods & Statistics course!
from where he got .05 for alpha >?!
same question
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?
Thank you very much, sir.
Excellent video. Short, clear and to the point.
how can i do multiple non linear regression
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?
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 cant find the data section in excel 😭😭😭
Fantastic! Thanks a lot. You are a good teacher.
Hi may i ask if I got like 400 entires of 3 independent variables how long does it usually take to show result?
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.
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
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 ..
I like your excllent grip on xl
Very useful. I didn't know Excel came with multivariate regression.
So there’s only one column that is considered to be Y as the independent variable? Because I have like 7 different columns
i want kown which version is thAT FROMEXCEL I DONT HAVE DATA ANALYSIS
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?
Great videos! Is there a way to find/search for sequential numbers in one column?
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
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!
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!
Absolutely brilliant, just what I needed, Thanks Jalayer
Thank you sir, please do a video on multiple regression using Dummy Variable
That's good one!
GREAT............. GREAT ............ for an aged student like me.. Thank you..
Thanks for nice Session, could you please explain about gamma values in this output
Thanks , great explanation.
I think I need to listen more than one time.
Regards
Insanely simple!!
All Intervals at 95% contain 0. Ouch!
helped me a lot. Thank you Sir ❤
Does a p-value above .05 for the intercept mean anything?
How can I select the Input X range for a large sheet :( ?
Thanks so much for this video! You're a life saver!
Really helped in finding important information regarding regression in excel.your videos are saving me in Stats class!
I know I am late, can this be a good approach in predicting crop yield
Thanks you helped me completing my assgn:)
TQ so much for the crystal clear explaination
This is exactly what I wanted at the night before exam.
Thank you Sir.. very informative...❤️
you saved my mental health, thank you very much!
Data. Analysis option not there in exell 2007
I thanks God for this video. Be blessed Sir
Very helpful video. Thank you!
Amazing video, thank you!
Great Video keep it up dude- you are a natural teacher!
Really helpful. Thanks a lot & keep going
Yes, thank you! About to graduate and this was super helpful to finalize a group project.
Thank you! You broke this down so well.
Thankyou ✨✨✨ I finally understand
Excellent
in 8:15, please can you look at? I need help
What version of Excell do you use? I can't find the regression tab.
Thank you very much, really helpful for me...now looking for more details
Easy to follow and practice. Thank you very much!
Very Useful! Thank you.
Why can't I make it in my excel file? 😢