Oh my goodness. You literally just saved my whole course!!! I have been struggling with this assignment and no-one else explained it like you. Thank you!!!!!!
Thank you so much! I was struggling on my homework and watched so many videos that didn't answer any of my questions about how to graph the regression line. My peace of mind and I thank you!!
I wish i would have found your videos sooner, Im 2 days from my finals and i dont know how to use the technology to find the calculations, ive been using just a calculator
My version of excel does not have the analysis and data analysis icon to complete the linear regression analysis. I can do the linear regression plot ok, but I can't do the rest of the regression output? Thanks for any help. What version is the example on, I think my excel is 2016.
Supposed if x variable repeated same numbers like 1,2 and 3 every time but y is always different value then how its graph looks like, then its r-square value is also very small then how should increase?
Hi I am using more than one x variable so I looking at the relationship between immigration and house prices. So do I have to do separate scatter graphs and regressions for each x variable with my House price index (y) variable as I have five x variables. So unsure of how to do this regression sir.
Can i forecast net income of any bank on the basis of it's previous years gross and net income...pls tell me how can I predict income for New year of any bank using linear regression....pls reply...it's urgent
Sir can you plz help me solve this using excel? . Linear regression - . Model the data using linear regression y = w0 + w1xunder the assumption of Gaussian noise of zero mean and variance value σ2 = 2500. (a) Use the model to predict the mean and variance of the value of the x = 40 claims. (b) For the noise variance value σ 2 = 2500, calculate the posterior; assume no prior for the bias parameter w0, a Gaussian prior for the slope parameter w1 of mean µ0 = 3 and a fixed variance σ2 = 4. (c) Calculate the posterior mean and variance for x = 40 claims x y 108 392.5 19 46.2 13 15.7 124 422.2 40 119.4 57 170.9 23 56.9 14 77.5
I am watching this as someone who knows basic stat's but is disgusted by how Excel hides the obvious functions we need!!! What are they thinking? They make it so un-obvious that it's disgusting. For example, after you make a scatterplot, it's common sense to want to add a regression line, but not to them. They never thought of that, it seems. Then figure the formula for it y = a + bx and then the t critical value for confidence at the p =.05 level and the p value and so on. Why can't they anticipate that and make it plain as an option? Default option one! They need to redo the software and make it user-friendly by being logical. Gosh. We should not have to watch a video like this. I can explore the Excel menu on my own, if they organize dit better. Damn them. Why does Gates allow this to continue? [Now that I've had my rant, I'll start watching]
You are a genius angel of Excel who came out of nowhere to make me understand the magic of numbers ... thanks man !
GOD BLESS YOU MAN THIS IS BY FAR THE BEST EXCEL INSTRUCTIONS EVER!
Oh my goodness. You literally just saved my whole course!!! I have been struggling with this assignment and no-one else explained it like you. Thank you!!!!!!
Helped me finish my homework! You are 10/10 better than my stats teacher. thank you!
Thank you so much! I was struggling on my homework and watched so many videos that didn't answer any of my questions about how to graph the regression line. My peace of mind and I thank you!!
same was the case here. just got relaxed after watching this video. quite helpful
Excellent
You make a very simple and easy steps for me to calculate and analyze the data even better now.
Dude! Great video. Thank you SO much for walking us mere earthlings through this process. Really. helped with understanding my stats homework.
speed 1.25
1.5
nice one!
2x always
Thanks for keeping it simple - you saved my MBA assessment paper! KUDOS!
I wish i would have found your videos sooner, Im 2 days from my finals and i dont know how to use the technology to find the calculations, ive been using just a calculator
Holy san pedro this is the simplest way to do it . Thank you.
Thank u. This video helped me in my online class assignment ❤️. Stay safe and well! Salamat kaayo
Same lolol
Thank you for sharing!! Always have to re-look this stuff up!
This was so helpful. Thank you so much for sharing!
Really you saved me from a terrible mistake. GOD bless you abundantly!
What does it mean when I'm getting a different r-square value computed from regression analysis and from fitting a trendline in excel?
Great video, thanks!
So should I put my variable x and y at the top?
Thank you so much, this video has helped me a lot. God bless you
Any idea how does one calculate the standard error in the coefficients? The 6.758 and the 0.415 ?
Great work. God bless you man.
My version of excel does not have the analysis and data analysis icon to complete the linear regression analysis. I can do the linear regression plot ok, but I can't do the rest of the regression output? Thanks for any help. What version is the example on, I think my excel is 2016.
I had the same problem. Fairly simple fix: libanswers.walsh.edu/faq/147605
Thank you, thank you so much. I didnt know how to do the calculations or make sense of the results, let alone present my data. Thank you so much
Dude u give me goddamn relief. thank u so much.
Thank you for lecture, God Bless you
Excellent 👍👍👍
excellent and simple example
You made this very easy to understand! Thank you!!
Is it positive or negative??
Thank u 🙏🏼
Dude! You just saved my sanity!
Thank you so much! You're perfect about statistic 🤗
Thanks bro, really helpfull!
Thank you for the video and thanks to RUclips for the option of accelerating videos, you talk very slowly
Supposed if x variable repeated same numbers like 1,2 and 3 every time but y is always different value then how its graph looks like, then its r-square value is also very small then how should increase?
Thank you very much, so helpful
i love your voice at 1.5x speed. you sound way cooler
Hi I am using more than one x variable so I looking at the relationship between immigration and house prices. So do I have to do separate scatter graphs and regressions for each x variable with my House price index (y) variable as I have five x variables. So unsure of how to do this regression sir.
Thank you for the session. Great help for me.
isn't the negative 17 the y intercept. Not slope..i think you have the slope and y intercept reversed. @ 6:25 of video
nyc2cuse thanks for catching that, I included a speech bubble stating that I misspoke on this point
No problem. .Thanks for making the video.
Thank you for saving my homework
Used in my undergrad diss. Thankyou
Very well explained . Excellent approach .
tq very much.!! u help me alot my bro!
all in all, great tutorial. THANK YOU
Nicely explained.
Thank you !
Thanks a lot!
cool tut!!!
So drunk yet so perfect.
What does it mean when my regression is not the same as the trendline?
may i know what apps do you use to record this? thank u
you helped me climax way better than my girlfriend ever could
low key same
Legend, thanks
Can i forecast net income of any bank on the basis of it's previous years gross and net income...pls tell me how can I predict income for New year of any bank using linear regression....pls reply...it's urgent
They keep changing Excel also. Mine doesn't look like yours.
Great video and well explained.
Great
Great tutorial, thanks! Going to watch part B
Thank you for the video; it is very helpful. Can you please the training data file?
Excelent
Thank you so much🙏🏽🙏🏽
How do i know if i can reject null hypothesis from this - please help!
thanks for the video... U rocked.. really helpful
Awesome - Thank you!
Thank you bro. I didn´t remember haw to do this nice thing.
What would it mean if your regression output and scatter plot equation don't match in terms of slope and intercept?
Might mean that there was a mistake in the input
Highly appreciate it, helped me a lot!! Going to watch the next episode, maybe mine ll need a polynomial 1 too:)
hey can you please provide the link for downloading these sheets?
Any ideas on regression analysis
Sir can you plz help me solve this using excel?
. Linear regression - . Model the data using linear regression y = w0 + w1xunder the assumption of Gaussian noise of zero mean and variance value σ2 = 2500.
(a) Use the model to predict the mean and variance of the value of the x = 40 claims.
(b) For the noise variance value σ
2 = 2500, calculate the posterior; assume no prior for the bias parameter w0, a Gaussian prior for the slope parameter w1 of mean µ0 = 3 and a fixed variance σ2 = 4.
(c) Calculate the posterior mean and variance for x = 40 claims
x y
108 392.5
19 46.2
13 15.7
124 422.2
40 119.4
57 170.9
23 56.9
14 77.5
Why is significant F so small? It looks it's different from the F table figure
😭❤️❤️❤️ thank you🙏
thanks for this
Bocahe Bu Any 🤙
Very helpful. Thank you.
great
please tell me version of excel that you are using ?
wasim Jutt looks like 2007
I think 2013. The 2007 version still had the "orb" at the top left.
Oh wait, it must be 2010. The 2013 version was the "super white UI" version.
Could you pls share the link to part B
Nice
How to do when we have X?
Good work
Thank you.
how to do in r programming ,data(cars)
-17 is not the slope.
You forgot to add "sort by speed, low to high" before doing anything else.
skip to 2:40
Thank you
Sad. My excel don't have regression
Can you pls. Share the data source
I am new to biostatistics. Can somebody please help me in clearing basic concepts
I am watching this as someone who knows basic stat's but is disgusted by how Excel hides the obvious functions we need!!! What are they thinking? They make it so un-obvious that it's disgusting. For example, after you make a scatterplot, it's common sense to want to add a regression line, but not to them. They never thought of that, it seems. Then figure the formula for it y = a + bx and then the t critical value for confidence at the p =.05 level and the p value and so on. Why can't they anticipate that and make it plain as an option? Default option one! They need to redo the software and make it user-friendly by being logical. Gosh. We should not have to watch a video like this. I can explore the Excel menu on my own, if they organize dit better. Damn them. Why does Gates allow this to continue? [Now that I've had my rant, I'll start watching]
Where is part B?
I will just go ahead and use Eviews and save my time.
You sound like Ryan Gosling...... Thought you should know
Anyone here from BTM200? lol
TRUST Christ
I cannot stand his voice!
Thank you!
Thank you.