I think I got a better grasp on understanding the outputs. I have a LOM due in less than 12 hours and I am just beginning to understand the basics in regression. So thank you for explaining.
Good to see you showed the equation. I don't understand anything. Just to get the point Mr. Like what values show that hypothesis wrong or right and why.
Thanks for the video! Is there an intuitive explanation why the degrees of freedom of the regression (SSR) is just one whereas the df of SSE is n-2? In the end, we use the same number of observations (16)
Hey! Great video! I know this is from a long time ago.. But I'm hoping you can help me. If I have a multiple regression table, and on their own, each independent variable is HIGHLY significant to the dependent variable according to the p-value and R2. But when I put them all in one table, the p-value of 1-2 predictors fall outside of the 0.05 limit to an extreme 0.35. However, my R2 increases to .995. Should I eliminate those variable even though on their own, they're significant? Or how should I interpret these results?
outstanding example; thank you; it's hard to find a clear example where multivariable regression passes all statistical significance tests and explains variation better. I wonder if the best additional (3rd) variable might be fielding percentage??
Hi jason.. can you please do a video on ms excel solver.. If i have a multiple regression model.. with 6 independent variables (X1 to X6) and known value of Y.. so we fix the value of Y and find out combinations of those 6 parametera that when equation solved,give close result to our value of Y. I am doing it for calibration of my simulation data.
Sorry Jason, I am not happy with your interpretation of the regression output. I was expecting clearer interpretation. Professionally speaking, you should start by explaining the objective of regression for explaining the relation between variables. Then, you start by explaining each out put and what it means in a simple way. What happened is you explained vaguely with mentioning "this kind important" etc. I was hoping for more bro.
I mean, fair enough. Nonetheless, if you want to understand the objective of regression, I would recommend watching the many other videos I have on regression. I just recorded a new video on output today, and I am confident it fails to address your concerns, because that's what my "Regression - Overview" videos do. To each their own, I guess. Check out my dummy interpretation videos if you really want to get into the weeds.
R^2 is the proportion of variance accounted for by the regressors divided by the total variance in y. As you add regressors (MLR), the numerator increases. I hope that helps!
Excel does that "automatically" when you use the analysis toolpak, but if you need to calculate it you can use =LINEST on the original data set. You need the original data, and then select an array of cells to put the output, use =LINEST(yvars,xvars), and then press CTRL-SHIFT-ENTER (it's an array formula).
I assume you mean from a logistic regression with a binary dependent variable. To my knowledge, there is no canned way to do this, but you can build a log likelihood function and use Solver to iterate to a solution. Other programs, such as R or Stata can do this more easily.
Mr. Jason, pls speak up louder and with more firmness in the words, it's difficult to pick up by gawking at thr screen as to wht you're saying No offense 🙂
I've literally understood almost nothing from this video. If you don't want to be open to explain things in details for others to learn, please no one's forcing you to do a video. 🤦
I think I got a better grasp on understanding the outputs. I have a LOM due in less than 12 hours and I am just beginning to understand the basics in regression. So thank you for explaining.
Thank you so much!!..you saved so much of my time
This is really great Jason, thanks for doing this kind of video. As I may have said before, it is very useful for applied economics.
very well-done video, slow, simple, and east to follow
Thank you for spelling it all out! My data set had tiny p-values as well and I was so lost as to how to interpret them with the E.
Good to see you showed the equation.
I don't understand anything. Just to get the point Mr. Like what values show that hypothesis wrong or right and why.
Your content is so touching
Thanks so much for this, Jason! I've been trying to understand. You explained perfectly :)
i've gone through u r video several times vry nice
Thanks!
Thanks!!
Excellent video, thanks a lot!
Professors should pass every student
This was incredibly helpful, thanks!
Thanks for the video! Is there an intuitive explanation why the degrees of freedom of the regression (SSR) is just one whereas the df of SSE is n-2? In the end, we use the same number of observations (16)
Thanks for sharing this! Helped me a lot.
Pretty good video. Definitely understand more than before watching.
thank you ...
So thankful!
Thank you so much ! I am student of IT and Econometrics and ANOVA interpretation was hard to find in my native language! Very useful !
Reach out to me for more assignment help. allybrit3@gmail.com
That was very helpful! Thank you!!
thanks for the video! although whatever was in your mouth that was making that smacking noise was distracting.
Hey! Great video! I know this is from a long time ago.. But I'm hoping you can help me. If I have a multiple regression table, and on their own, each independent variable is HIGHLY significant to the dependent variable according to the p-value and R2. But when I put them all in one table, the p-value of 1-2 predictors fall outside of the 0.05 limit to an extreme 0.35. However, my R2 increases to .995. Should I eliminate those variable even though on their own, they're significant? Or how should I interpret these results?
Thanks again.. very useful for the smallest of doubts...
outstanding example; thank you; it's hard to find a clear example where multivariable regression passes all statistical significance tests and explains variation better. I wonder if the best additional (3rd) variable might be fielding percentage??
Hi jason.. can you please do a video on ms excel solver..
If i have a multiple regression model.. with 6 independent variables (X1 to X6) and known value of Y.. so we fix the value of Y and find out combinations of those 6 parametera that when equation solved,give close result to our value of Y. I am doing it for calibration of my simulation data.
Thanks, good job..
Thanks for sharing this.
anyone know what is the difference between using regression data analysis tab versus the RSQ function?
Better than the last guy but I need you to speak in lamen terms
Is there a possibility to do multiple regression diagnostics in Excel?
The video is good
For some reason the data and regression box thing that helps doesn’t pop up
HAAAAIYAAA very vague , needs more MSG in it
Sorry Jason, I am not happy with your interpretation of the regression output. I was expecting clearer interpretation. Professionally speaking, you should start by explaining the objective of regression for explaining the relation between variables. Then, you start by explaining each out put and what it means in a simple way. What happened is you explained vaguely with mentioning "this kind important" etc. I was hoping for more bro.
I mean, fair enough. Nonetheless, if you want to understand the objective of regression, I would recommend watching the many other videos I have on regression. I just recorded a new video on output today, and I am confident it fails to address your concerns, because that's what my "Regression - Overview" videos do.
To each their own, I guess. Check out my dummy interpretation videos if you really want to get into the weeds.
how do i find gradient on the regression output ? do i just divide intercept/x variable?
Hi I'm having a problem. I put my data on excel & I get F value very high like 28. Is that normal?
If there's a really strong relationship, then yes, not uncommon.
what if the intercept p-value is more than 0.05 ?
Isn't the f stat mse over msr. Explained over unexplained??
yes it is mse/msr
Not at all useful because you are not telling how these values are obtained and what is their significance. You just read out the whole output table.
why does R square change when u use MLR
R^2 is the proportion of variance accounted for by the regressors divided by the total variance in y. As you add regressors (MLR), the numerator increases. I hope that helps!
excuse me! do you know why my p-value column has this signal #NUM when i use multiple regression.
Hoàn Trương usually because you have too many dummy categories and are running into collinearity issues.
Please Tell how to calculate manually the standard error of the coefficients
σ_x ̅ =σ/√n
stop clicking your tongue
lol...you are mean
Thank you
how do you calculate the Coefficient for all regressions shown in cell B17
Excel does that "automatically" when you use the analysis toolpak, but if you need to calculate it you can use =LINEST on the original data set. You need the original data, and then select an array of cells to put the output, use =LINEST(yvars,xvars), and then press CTRL-SHIFT-ENTER (it's an array formula).
thanks very much!
HOW CAN I ADD THIS ON THE WORD DOCUMENT
COPY AND PASTE!
thanks
can anyone give me the link for the book?? plzz
Lovely vid! But what exactly does F show?
Deboleena Dutta p-values.... sorry 4 years later
Any way to get Odds Ratios from the excel linear regression program? Thanks!
I assume you mean from a logistic regression with a binary dependent variable. To my knowledge, there is no canned way to do this, but you can build a log likelihood function and use Solver to iterate to a solution. Other programs, such as R or Stata can do this more easily.
Yes. A lot of articles seem to express results with Odds Ratios...
Does SPSS do it?
Yes certainly.
Hi Jason, is it possible to get a negative intercept?
Absolutely. Generally, we don't care that much about the intercept, but it can be drawn from anywhere on the real line.
how do you download the data analysis toolpak?
Add ins
Mr. Jason, pls speak up louder and with more firmness in the words, it's difficult to pick up by gawking at thr screen as to wht you're saying
No offense 🙂
Why do all accounting/finance professors smack their lips at the end of every sentence.... It drives me insane
facts i couldn't stop thinking about that . good thing he was talking about baseball stats
I wanna punch my professor for making us doing this by analyzing a questionnaire which has no relation with what we study in the course at at all
good stuff!
not helpful...
Torturous video, could have explained better
I've literally understood almost nothing from this video. If you don't want to be open to explain things in details for others to learn, please no one's forcing you to do a video. 🤦
I'm very sorry to hear that! Is there anything in particular that you had questions about?
work on ur voice modulation
Stop champing.
your voice is very hard to hear
You make a lot of sounds while you talk.