Regression #5: LINEST() function for multivariate regression

The LINEST() is dynamic: you don't need to re-run if the data changes. It returns an array, so don't forget to START by selecting a RANGE and finish with CTRL+SHIFT+ENTER.

Category:

Education

Tags:

• Excel
• regression
• function
• statistics
• econometrics
• quant
• quantitative

[TheWhitewaterrafting]

I just tried to do this and it didn't work and now im stuck with an array I can not delete. what should i do?

[bionicturtledotcom]

@TheWhitewaterrafting to delete an array, you may have to select the entire array before deleting. But select all, delete should clear it

[andyv123]

Are these coefficient done usesing the OLS regression???

[bionicturtledotcom]

Yes, ordinary least square (OLS)...

[starvator]

life saver ! :D

[Paipsh]

Thank you very much! You just saved my life! :)

[purpsmoka]

You are the best Excel tutor in the world

[tushitjain]

He takes 10mins to save things that can be said in 3 mins!! Unfortunately, my net is slow..

[mericha]

Thanks, you saved my life !!!

[zubayar]

Awesome HELP !

Thank you !!