Help with linear regression

1 次查看（过去 30 天）

显示更早的评论

Teshan Rezel 2022-2-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1642630-help-with-linear-regression

评论： Rik 2022-2-4

b.mat
a.mat

Hi folks,

I have 2 tables. A is 256x54 and B is 1x54.

I want to correlate each of the 256 values in each column of table A to the corresponding value in table B, and then find the index within table A that gives the best correlation.

Is this possible? So far I have been unseccessul in applying the \ operator as per the documentation in here: https://uk.mathworks.com/help/matlab/data_analysis/linear-regression.html

Attached are my tables!

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

Teshan Rezel 2022-2-4

hi @Rik, I meant, for example, if of the 256 values within A corresponding to the value of B, that the best correlation was found at the 3rd row across all 54 columns, or the 16th etc...then it will return 3 or 16.

Rik 2022-2-4

在 MATLAB Online 中打开

You want to find the index of the closest number, purely based on the value?

So for the example data below it should return 1 and 3?

A=table([1;2;3],[10;20;30]),B=table(1.4,26)
A = 3×2 table
    Var1    Var2
    ____    ____

     1       10 
     2       20 
     3       30 
B = 1×2 table
    Var1    Var2
    ____    ____

    1.4      26 