Help with linear regression

2 views (last 30 days)
Teshan Rezel
Teshan Rezel on 3 Feb 2022
Commented: Rik on 4 Feb 2022
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 Comments
Teshan Rezel
Teshan Rezel on 4 Feb 2022
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
Rik on 4 Feb 2022
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

Sign in to comment.

Answers (0)

Categories

Find more on Matrices and Arrays in Help Center and File Exchange

Products


Release

R2021b

Community Treasure Hunt

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

Start Hunting!