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
Dude! Great video. Thank you SO much for walking us mere earthlings through this process. Really. helped with understanding my stats homework.
Thanks for keeping it simple - you saved my MBA assessment paper! KUDOS!
You make a very simple and easy steps for me to calculate and analyze the data even better now.
Holy san pedro this is the simplest way to do it . 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
Thank u. This video helped me in my online class assignment ❤️. Stay safe and well! Salamat kaayo
Same lolol
speed 1.25
1.5
nice one!
2x always
This was so helpful. Thank you so much for sharing!
Really you saved me from a terrible mistake. GOD bless you abundantly!
Thank you for sharing!! Always have to re-look this stuff up!
Excellent
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
Great video, thanks!
Thank you so much, this video has helped me a lot. God bless you
You made this very easy to understand! Thank you!!
Is it positive or negative??
Dude! You just saved my sanity!
Dude u give me goddamn relief. thank u so much.
Great work. God bless you man.
Thank you so much! You're perfect about statistic 🤗
Thank you for the video and thanks to TH-cam for the option of accelerating videos, you talk very slowly
What does it mean when I'm getting a different r-square value computed from regression analysis and from fitting a trendline in excel?
all in all, great tutorial. THANK YOU
i love your voice at 1.5x speed. you sound way cooler
Thank you for lecture, God Bless you
Thank you !
Thank you for the session. Great help for me.
tq very much.!! u help me alot my bro!
So drunk yet so perfect.
Thank you for saving my homework
Thanks a lot!
Very well explained . Excellent approach .
Highly appreciate it, helped me a lot!! Going to watch the next episode, maybe mine ll need a polynomial 1 too:)
Great tutorial, thanks! Going to watch part B
Thanks bro, really helpfull!
Thank you very much, so helpful
So should I put my variable x and y at the top?
thanks for the video... U rocked.. really helpful
Used in my undergrad diss. Thankyou
Any idea how does one calculate the standard error in the coefficients? The 6.758 and the 0.415 ?
excellent and simple example
Excellent 👍👍👍
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
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 u 🙏🏼
Thank you bro. I didn´t remember haw to do this nice thing.
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.
Nicely explained.
Great video and well explained.
They keep changing Excel also. Mine doesn't look like yours.
Awesome - Thank you!
Legend, thanks
Excelent
cool tut!!!
Great
What does it mean when my regression is not the same as the trendline?
Thank you so much🙏🏽🙏🏽
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
Thank you for the video; it is very helpful. Can you please the training data file?
Why is significant F so small? It looks it's different from the F table figure
Very helpful. Thank you.
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
😭❤️❤️❤️ thank you🙏
How do i know if i can reject null hypothesis from this - please help!
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
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
Any ideas on regression analysis
hey can you please provide the link for downloading these sheets?
thanks for this
great
Bocahe Bu Any 🤙
Nice
Could you pls share the link to part B
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.
Good work
How to do when we have X?
You forgot to add "sort by speed, low to high" before doing anything else.
Thank you.
-17 is not the slope.
how to do in r programming ,data(cars)
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]
Sad. My excel don't have regression
Can you pls. Share the data source
Where is part B?
Thank you
skip to 2:40
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.