Help with linear regression

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 个评论

The \ operator requires data arrays as operands, not container data types.
And what do you mean by the index with the best correlation?
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.
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

请先登录,再进行评论。

回答(0 个)

类别

帮助中心File Exchange 中查找有关 Tables 的更多信息

产品

版本

R2021b

评论:

Rik
2022-2-4

Community Treasure Hunt

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

Start Hunting!

Translated by