Тёмный

Least Squares Linear Regression - EXCEL 

Cody Tabbert
Подписаться 4,1 тыс.
Просмотров 291 тыс.
50% 1

The first part of this video shows how to get the Linear Regression Line (equation) and then the scatter plot with the line on it. We also look at computing the sum of the squared residuals. The second part of the video looks at using the inserted Data Analysis Pack - this can be added on to EXCEL.

Опубликовано:

 

1 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 43   
@dorjitshering560
@dorjitshering560 2 года назад
How to programme R square manually from given data where excel sheet has no such features?.
@conspartaco
@conspartaco 4 года назад
Data analysis pack method: 6:43
@aswingruber
@aswingruber 10 лет назад
Fantastic! Thanks so much for taking the time to post these. It's a big help on homework.
@georgebush4221
@georgebush4221 Год назад
hey mate i used this video to help do an assignment im doing, if your still active on youtube could i use you as a reference? if possible a link to your linkin account if you have one
@simsong822
@simsong822 2 года назад
I can see only chart design and format. there is no layout showing up. I can't do it.
@codytabbert
@codytabbert 2 года назад
This is a pretty old version now. But if you have the scatter plot - click on the chart. Then there is an option under the Home header called “add chart element”. Click that and go down to trendline. Hope that helps. You can google where these items are at with whatever version you are using. This is for a Mac 365.
@brittanyhowell6683
@brittanyhowell6683 4 года назад
Thank you SO much! This helped more than any other RU-vid video. I wish my professor was as great as you!
@kimberlycorasio7603
@kimberlycorasio7603 7 лет назад
You are super awesome...I have watched this 4 times, finally sort of getting it :) Thank you!!!
@TheSTEPHEN009
@TheSTEPHEN009 3 года назад
Sir you just saved my life. God bless you.
@hayderal-sarraf667
@hayderal-sarraf667 2 года назад
thank you so much
@richardalonsagay4166
@richardalonsagay4166 5 лет назад
Thank you! This helped me a lot. You're an amazing instructor!
@JulainSmithiscool
@JulainSmithiscool 4 года назад
Amazing ty
@chanda9683
@chanda9683 2 года назад
Thank you, this was very useful!
@manfaat
@manfaat 4 года назад
Thanks. appreciate the knowledge sharing.
@madridi891
@madridi891 5 лет назад
thank you very much
@yilihan8874
@yilihan8874 7 лет назад
Which excel version are you using?
@lovebunnykaz
@lovebunnykaz 10 лет назад
So is the sum of the squared residuals the errors of the 'calibration curve' [in my case]?
@melvalewis6643
@melvalewis6643 9 лет назад
If a team manager saw the least squares regression line and not the actual data, how many runs would he or she predict for a team with 6176 at-bats?
@prodigy72721
@prodigy72721 6 лет назад
very good instructional video
@rayyansyed6664
@rayyansyed6664 2 года назад
Thank you so much. I actually understood my maths homework for once.
@mary-myangeles6962
@mary-myangeles6962 4 года назад
Thank u for this video
@arjunaaah
@arjunaaah 10 лет назад
Oh man, thank your very very much!
@joaopereira5055
@joaopereira5055 5 лет назад
What if I have multiple x variables??
@mohammedjoe5181
@mohammedjoe5181 5 лет назад
excuse me can i get the excel sheet file ,please
@khalidjanabi
@khalidjanabi 5 лет назад
Thanks for sharing this video :)
@goyomedina
@goyomedina 10 лет назад
You have saved my life! thanks.
@UplusIequals69
@UplusIequals69 10 лет назад
What would I have to do to test that the slope of the line is equal to one?
@cianronan9267
@cianronan9267 3 года назад
This guy is such a hero 🙌
@juliaportillo5485
@juliaportillo5485 8 лет назад
Feeling very grateful that I finally got this. . You're a great teacher.
@rjugoschua
@rjugoschua 10 лет назад
Thank you very much Cody :-)
@DoctorDupe
@DoctorDupe 4 года назад
thanks!!
@arjunkataria2298
@arjunkataria2298 9 лет назад
How would I calculate the standard error?
@rohimikhaleel5171
@rohimikhaleel5171 10 лет назад
Thank you very much
@mohammedjoe5181
@mohammedjoe5181 5 лет назад
excuse me can i get the excel sheet file ,please
@codytabbert
@codytabbert 5 лет назад
Mohammed Joe - No. the video shows you how to create it. You need to learn how to use excel. Follow along. You can do it.
@amdeworkgochelmamuye1311
@amdeworkgochelmamuye1311 7 лет назад
thanks so much
@KellyOhara
@KellyOhara 8 лет назад
Your a good teacher! Thanks
@DeepikaKommanapalli
@DeepikaKommanapalli 10 лет назад
Thanks for that!!
@111sonny111
@111sonny111 10 лет назад
Thank you brother
@Bryan-ov1sx
@Bryan-ov1sx 3 года назад
6:48 in excel
@codytabbert
@codytabbert 3 года назад
For the data analysis pack. But you may not have it installed.
Далее
How To Perform Simple Linear Regression In Excel
14:51
Просмотров 447 тыс.
Как открыть багажник?
00:36
Просмотров 15 тыс.
ХОМЯК ВСЕХ КИНУЛ
10:23
Просмотров 617 тыс.
Forecasting in Excel using Linear Regression
12:44
Просмотров 271 тыс.
Linear Regression Least Squares Method
16:56
Просмотров 16 тыс.
What is Least Squares?
2:43
Просмотров 64 тыс.
Fit Nonlinear Model to Data with Excel
13:33
Просмотров 62 тыс.
Multiple Regression in Excel
11:02
Просмотров 771 тыс.
Curve Fitting in Excel
12:47
Просмотров 115 тыс.
Least Square Regression Line
7:02
Просмотров 26 тыс.