How to do Linear Regression with Excel Data Analysis Toolpak

[@pelagiushipbone7968]

Good Lord I just spent 4 hours worth of Uni classes trying to grasp Linear regression using excel and you taught it to me in 10 minutes. You really just saved me!

[@MattMacarty]

Thanks. Glad it helped.

[@jameshintexas]

Matt, your brilliant video explained linear regression perfectly. thankyou.

[@MattMacarty]

Thank you. Glad it helped.

[@lvteachme973]

You're the best instructor ever! Thanks you!

[@MattMacarty]

Thanks. Glad it helped.

[@jackm891]

Absoulte legend!! Made my home work make sense in 10 minutes.

[@MattMacarty]

Thanks. Glad it helped

[@kasmindanil5527]

thanks sir for the great explanation

[@MattMacarty]

Glad it helped.

[@yz7650]

Really detailed video. super helpful!

[@MattMacarty]

Thanks. Glad it helped

[@kevinmckennanar]

Outstanding video!

[@MattMacarty]

Thanks very much. Glad it helped

[@tanishascottham]

You saved my night! Thank you! [3:25]

[@MattMacarty]

Glad it helped

[@SoneriVishwa]

excellent explanation sir🎉

[@MattMacarty]

Glad it helped

[@AnandPenmatcha]

Excellent video

[@MattMacarty]

Thanks. Glad it helped

[@sheenamachica9068]

thank you 💙

[@MattMacarty]

Glad it helped

[@jDeppen]

Thanks!

[@MattMacarty]

Thanks very much. Glad it helped

[@berto_osorio_fl]

thank you!

[@MattMacarty]

Glad it helped.

[@or-mielfaraja8718]

This is awesome. Great video.

[@MattMacarty]

Thanks. Glad it helped.

[@bencastro92]

Lifesaver

[@MattMacarty]

Glad it helped

[@sonyse2t5]

Master class

[@MattMacarty]

Glad it helped

[@prestoncummins4646]

Why didn’t you include the standard error in the equation to predict the price of the house? The formula to predict the y-value is y = B sub 0 + B sub 1 • x + € (that’s supposed to be epsilon).

[@MattMacarty]

Yes that's right the presentation of the equation includes an error term, but it is expected to be 0. We don't use it to calculate the least squares line. Standard error is an altogether different term though. If I were calculating a prediction interval or confidence interval then I would need the standard error.

[@imranmaarof9910]

In the example, the p-value for the intercept is 0.41919 which is greater than 0.05 right. So what happened to the intercept value? do we use the value of -222.68?

[@MattMacarty]

Hi. In general we don't do anything with the intercept p-value. It's the slope p-value we are interested in. P-value will always be positive, the -228 number is the t and with such a high t you must have a very low p-value indicating that in all likelihood the slope is not 0,

[@imranmaarof9910]

Thank you so much, I understand now👍👍👍

[@razzyd]

how do i do this on a mac book pro??? I tried holding the alt key pressing t and i and it didn't work for me .

[@MattMacarty]

Do you how do you turn on Data Analysis? It's in the Tools menu at the bottom you will see Excel Add ins.

[@rajeshj5994]

For every one sq.ft increase, the sale price increases by 2.12 or 2.12 multiplied by 100?

[@MattMacarty]

The data are in the same scale so it's 2.12/sq ft, but yes to get back to the original data it's 212/sq ft.

[@daidai1562]

后卫

[@MattMacarty]

好的