How to do the equivalent of Excel linest function?

18 次查看（过去 30 天）
Tom Graney
Tom Graney 2017-8-13
评论： Tom Graney 2017-8-14
I have been solving these problems using Excel linest for years, but I want to solve problems that are too large for Excel. Something on the order of 200 independent variables (predictors) and 5000 observations. I've looked at some of the examples and tried to follow the help, but as with all programming, unless you do it exactly right you get nothing. I need a little guidance to build my first model. Once I have the coefficients, I will move them to another environment for further evaluation. The predictors are financial market technicals. The observations are hypothetical profit or loss.
Thanks for any assistance. I can load my data (csv file) into a workspace and then to the command window, but when I open the curvefit toolbox, I can get no further.

请先登录，再回答此问题。

回答（1 个）

Walter Roberson
Walter Roberson 2017-8-14
  1 个评论
Tom Graney
Tom Graney 2017-8-14
This is what I have found with internet search: 1)Put my data in an Excel file, naming the columns with the independent and dependent variable names. 2) In the command window: MyTable = readtable("filespec") 3) In the command window: MyModel = fitlm(MyTable)
Presto, I have my answer. Thanks MatLab.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by