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!

[Rik]

The \ operator requires data arrays as operands, not container data types.

And what do you mean by the index with the best correlation?

[Teshan Rezel]

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]

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