Excel Walkthrough 4 - Reading Regression Output 

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 for this lifesaver i am currently studying in year 11 with no prior knowledge of regression, and my crazy employer thought it would be a good idea to make me learn all this on my own

Thank you so much!!..you saved so much of my time

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)

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.

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?

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.

Thanks so much for this, Jason! I've been trying to understand. You explained perfectly :)

very well-done video, slow, simple, and east to follow

Is there a possibility to do multiple regression diagnostics in Excel?

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??

anyone know what is the difference between using regression data analysis tab versus the RSQ function?

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.

Hi I'm having a problem. I put my data on excel & I get F value very high like 28. Is that normal?

how do i find gradient on the regression output ? do i just divide intercept/x variable?

excuse me! do you know why my p-value column has this signal #NUM when i use multiple regression.

i've gone through u r video several times vry nice

Your content is so touching

Any way to get Odds Ratios from the excel linear regression program? Thanks!

Hi Jason, is it possible to get a negative intercept?

This was incredibly helpful, thanks!

what if the intercept p-value is more than 0.05 ?

Pretty good video. Definitely understand more than before watching.

why does R square change when u use MLR

how do you calculate the Coefficient for all regressions shown in cell B17

Please Tell how to calculate manually the standard error of the coefficients

For some reason the data and regression box thing that helps doesn’t pop up

Lovely vid! But what exactly does F show?

Thank you so much ! I am student of IT and Econometrics and ANOVA interpretation was hard to find in my native language! Very useful !

Excellent video, thanks a lot!

how do you download the data analysis toolpak?

can anyone give me the link for the book?? plzz

That was very helpful! Thank you!!

Thanks again.. very useful for the smallest of doubts...

Isn't the f stat mse over msr. Explained over unexplained??

Thanks for sharing this! Helped me a lot.

HOW CAN I ADD THIS ON THE WORD DOCUMENT

thanks for the video! although whatever was in your mouth that was making that smacking noise was distracting.

Thanks, good job.. Thanks for sharing this.

Professors should pass every student

So thankful!

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 🙂

Better than the last guy but I need you to speak in lamen terms

Thanks!!

The video is good

thank you ...

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.

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.

HAAAAIYAAA very vague , needs more MSG in it

thanks very much!

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

stop clicking your tongue

thanks

Why do all accounting/finance professors smack their lips at the end of every sentence.... It drives me insane

good stuff!

Torturous video, could have explained better

not helpful...

work on ur voice modulation

Stop champing.

your voice is very hard to hear

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. 🤦

You make a lot of sounds while you talk.