how to run multiple number of regressions?

Question

alpedhuez 2021-7-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/888767-how-to-run-multiple-number-of-regressions

编辑： alpedhuez 2021-7-30

I have table T with

Date Location Sales Visitors
1/1 NY 10 5
1/1 LA 7 3
1/2 NY 9 5
1/2 LA 4 1

Then I want to run regressions

(sales)=a_i*(visitor)+b_i

for each i = {NY, LA}. Is there any simpler way to do this?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

dpb 2021-7-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/888767-how-to-run-multiple-number-of-regressions#answer_756907

在 MATLAB Online 中打开

tRegress=rowfun(@(x,y)polyfit(x,y,1),T,'GroupingVariables',{'Location'}, ...
                                       'InputVariables',{'Visitors','Sales'}, ...
                                       'NumOutputs',1, ...
                                       'OutputVariableNames',{'Coefficients'});

3 个评论
显示 1更早的评论隐藏 1更早的评论

dpb 2021-7-30

在 MATLAB Online 中打开

tRegress=rowfun(@(x,y)fitlm(x,y,'linear'),T,'GroupingVariables',{'Location'}, ...
                                           'InputVariables',{'Visitors','Sales'},  ...
                                           'NumOutputs',1, ...
                                           'OutputVariableNames',{'Model'}, ...
                                           'OutputFormat',"cell");

If it gets too much more complicated may have to use an m-file for the function instead of anonymous function...also have to switch to a cell output to catenate the model outputs instead of table.

alpedhuez 2021-7-30