How to find relationship between three data

Question

Kushagra Kirtiman 2022-3-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1677054-how-to-find-relationship-between-three-data

回答： Ayush 2023-11-14

I have an excel data consisting of three columns. I want to find the relationship between the the data in equation form. Can anybody explain the process for it?

2 个评论
显示无隐藏无

Torsten 2022-3-21

编辑：Torsten 2022-3-21

Either the physical background leads to a senseful relation or you must guess the functional form of the relation (mostly on the basis of a graphical representation).

Mathieu NOE 2022-3-22

Can you share the data ?

请先登录，再进行评论。

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

Answer 1

Ayush 2023-11-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1677054-how-to-find-relationship-between-three-data#answer_1352202

在 MATLAB Online 中打开

Hi Kushagra,

I understand that you want to find the relation between the data in the equation form for the data consisting of three columns.

You can use linear regression, which is a statistical approach to model the relation between the dependent variable and one or more independent variables.

Suppose you have “x1” and “x2” representing the first and second columns of data respectively. While the dependent third column variable is given by “y”. You can use the backslash operator “\” which performs a least-squares regression to obtain the coefficients for each independent variable. Thus, you will get an equation for “y” with respect to “x1” and “x2”. You can refer the code below, where I have used this operator for small sample data:

% Example data
x1 = [1; 2; 3; 4; 5];    % Independent variable 1
x2 = [4; 4; 6; 8; 10];   % Independent variable 2
y = [7; 12; 18; 24; 30]; % Dependent variable
% Create the design matrix (X) by concatenating the independent variables
X = [x1, x2];
% Perform linear regression using the backslash operator (\)
coefficients = X \ y;
% Extract the coefficients for each independent variable
b1 = coefficients(1);
b2 = coefficients(2);
% Display the equation
equation = ['y = ', num2str(b1), ' * x1 + ', num2str(b2), ' * x2'];
disp('Equation:');
Equation:
disp(equation);
y = 5 * x1 + 0.5 * x2